| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data
I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees
names. When an employees name does not appear on the pivot table, it returns #REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn the 4 into a 0, but then when the number is not a 4, I get #N/A. Is there any way to get a 0 off of the pivot table if an employee name does not show up? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Threaded Mode
