

December 8, 2017




VIP

Trusted Members

June 25, 2016

For the Conditional formatting you can refer here:


December 8, 2017

Hello Sunny;
This is Mitul.
Good Morning
How are you ?
Thank you for sending me article on conditional formatting formula. I am looking for article on how to compare 2 lists using conditional formatting
formulas. Also, this morning (especially New York, USA morning, I placed 2 new posts here , entered sample data of what cond. form. formulas to write for those 2 scenarios, so can you please help me out.
Also, yesterday, I attached 1 Getpivotdata file in which I am keep getting #REF! error,I tried best, but I could not get desired result.
Thank you very much.
Have a great day.
Sincerely;
Mitul.

VIP

Trusted Members

December 7, 2016

Hello Mitul,
To start with, this article describes why you get a #REF! error and how you can correct it.
Secondly, this article describes the GETPIVOTDATA function. Another article, in my view a better one, is written by Mynda and you find it in the blog section or by clicking on this link.
Lastly, the error you made is that you use SALESPERSON as a field reference when the actual name in the Pivot Table is Name. So change following
=(GETPIVOTDATA("Sum of Dollars",$R$8,"SALESPERSON","Jen","Product","lipstick"))
to
=(GETPIVOTDATA("Sum of Dollars",$R$8,"Name","Jen","Product","lipstick"))
and you will get the result, which is 3953.300132.
Even if you change name of any header in the Pivot Table, you need to stick with the headers you have in the table columns when referencing to them.
Br,
Anders
1 Guest(s)
