Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate #REF
Hi all, As I read on another thread, I tried to use the conditional formatting in order to eliminate #REF error (due to lack of a certain item in pivot, that I'm going to reference with GETPIVOTDATA) but I still have the #REF as the result of sum several items if one of it is #REF. Is there any solution to solve this issue? Thanks in advance, regards, Pat:) -- pat59 ------------------------------------------------------------------------ pat59's Profile: http://www.excelforum.com/member.php...o&userid=31861 View this thread: http://www.excelforum.com/showthread...hreadid=517822 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate #REF
You could use an IF formula to test the result, e.g.:
=IF(ISERROR(GETPIVOTDATA("Units",$A$6,"Region","On tario")),0, GETPIVOTDATA("Units",$A$6,"Region","Ontario")) pat59 wrote: As I read on another thread, I tried to use the conditional formatting in order to eliminate #REF error (due to lack of a certain item in pivot, that I'm going to reference with GETPIVOTDATA) but I still have the #REF as the result of sum several items if one of it is #REF. Is there any solution to solve this issue? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to eliminate #REF
thanks, Debra! bye -- pat59 ------------------------------------------------------------------------ pat59's Profile: http://www.excelforum.com/member.php...o&userid=31861 View this thread: http://www.excelforum.com/showthread...hreadid=517822 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
Excel should let me eliminate "duplicate records" in a column | Excel Discussion (Misc queries) | |||
Macro to eliminate extra space | Excel Discussion (Misc queries) | |||
eliminate partial content from the cell | Excel Worksheet Functions | |||
how eliminate zeros in blank cells using paste link | Excel Worksheet Functions |