| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getpivotdata error
I figured it out - i just need to needed to show items with no data in the
pivot table. "dchristo" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getpivotdata error
Another option is to use ISERROR in the formula, e.g.:
=IF(ISERROR(GETPIVOTDATA(SUMMARY!I7,"Jane Brown")),"", GETPIVOTDATA(SUMMARY!I7,"Jane Brown")) dchristo wrote: I figured it out - i just need to needed to show items with no data in the pivot table. "dchristo" wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| 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 | |||
Linear Mode
