Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getpivotdata error
In Excel 2002 - I am using the following formula;
=GETPIVOTDATA(SUMMARY!I7,"Jane Brown"); however, if her name is not showing up in the pivot table that day I am getting a #REF! error. How can I change/formulate that to be 0 or blank? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getpivotdata | Excel Worksheet Functions | |||
GetPivotData function returning N/A error for some rows | Excel Discussion (Misc queries) | |||
GETPIVOTDATA returns #REF error | Excel Worksheet Functions | |||
GetpivotData returns a #REF! error | Excel Worksheet Functions | |||
Getpivotdata "N/A" error | Excel Worksheet Functions |