Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the formula inside #REF error
Hi ,
I have a formula which is refering to a another sheet as follows =SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!) I want to know what is the formula written inside the #REF! Is there any way I can find the formula inside the #REF Thanks MKJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
Lookup formula & an error to find the match | Excel Worksheet Functions | |||
find and replace inside comments? | Excel Discussion (Misc queries) | |||
IF(FIND Formula gives #VALUE! error | Excel Worksheet Functions | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) |