ExcelBanter - =GETPIVOTDATA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =GETPIVOTDATA (https://www.excelbanter.com/excel-discussion-misc-queries/238909-%3Dgetpivotdata.html)

dchristo

=GETPIVOTDATA

=I am populating a report with GetPivotData formula. If the data does not
exist in
the Pivot, #REF! is returned; how can I change the error to "0" as it is a
calculated field.

i.e #REF! becomes 0

Thanks for the help!!

All times are GMT +1. The time now is 08:52 PM.