| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables and the "#N/A" error
Pivot tables return "#N/A" when there are such errors in the relevant
underlying data. Is there a way to have the pivot table ignore those errors and return the known data? -- Regards, Ryan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot tables and the "#N/A" error
Maybe use a helper column and "hide" the error there.
=if(iserror(a2),0,a2) (and drag down and use this column in the pivottable. sunnyvale_playmaker wrote: Pivot tables return "#N/A" when there are such errors in the relevant underlying data. Is there a way to have the pivot table ignore those errors and return the known data? -- Regards, Ryan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
