Follow this topic

Last answered:

10 Aug 2021

Posted on:

09 Aug 2021

1

How does your data get immediately formated as soon as you paste the formula into other cells

in Data Analysis with Excel Pivot Tables / GetPivotData is great! Extracting data from the Master Pivot Table

I cant seem to figure out what formatting you did to get the numbers in RED with the BRACKETS as soon as you paste the formula. I follow very closely and I havent seen you show this.

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

10 Aug 2021

0

HI Nicolas,
Good to hear from you. I believe the cells were formatted off-screen and then simply pasted in these cells.
Apologies for the confusion.
Best,
Ned

Submit an answer

related questions

2

16

The 'GetPivotData' formula does not work

Asmaa Abdulhamid

0

10

Resolved: there is no final exam to attend in order to get the certificate for this course

Abdelrahman Essam

0

8

Getting different (GETPIVOTDATA) Formula

Muhammad Ali Jafri

0

6

Don't understand why am i getting error in some cells while others are responding fine.

Panagiotis Blatsas

0

6

Can you please explain how to fill the table GETPIVOTDATA in practice exam 2?

0

4

Resolved: I don't get the same result as the video.

0

4

Resolved: Paste special to hole column

Asmaa Abdulhamid

1

4

how to put many cells side by side in every row of the slice??

Churchill Onyeije

1

2

Get Pivot Data function and REF error

1

2

Unable to get the value by fixing this as well

Muhammad Mujtaba

0

2

Why you added -1 in %variations after dividing both years' value?

Syed Muhammad Mudassir

0

2

why did you divide the number by 1000??