| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find the formula inside #REF error
The #Ref! error means that the range that the formula referred to has been
deleted. I'd bet it used to point at a column that was deleted. Can you go back to a previous version to see? #REF error wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find the formula inside #REF error
Hi Dave,
Thank you for your quick reply. But I want to know what are the referenced rows which were deleted or moved. "Dave Peterson" wrote: The #Ref! error means that the range that the formula referred to has been deleted. I'd bet it used to point at a column that was deleted. Can you go back to a previous version to see? #REF error wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find the formula inside #REF error
Take a look at the previous version if you still have it.
If you don't, then you're out of luck. Excel doesn't keep track columns that you delete. #REF error wrote: Hi Dave, Thank you for your quick reply. But I want to know what are the referenced rows which were deleted or moved. "Dave Peterson" wrote: The #Ref! error means that the range that the formula referred to has been deleted. I'd bet it used to point at a column that was deleted. Can you go back to a previous version to see? #REF error wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find the formula inside #REF error
Hi Dave,
My bad luck,I don't have a previous version of it. Regards, MKJ "Dave Peterson" wrote: Take a look at the previous version if you still have it. If you don't, then you're out of luck. Excel doesn't keep track columns that you delete. #REF error wrote: Hi Dave, Thank you for your quick reply. But I want to know what are the referenced rows which were deleted or moved. "Dave Peterson" wrote: The #Ref! error means that the range that the formula referred to has been deleted. I'd bet it used to point at a column that was deleted. Can you go back to a previous version to see? #REF error wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find the formula inside #REF error
Maybe you could look at headings to see what kind of data was being brought
back. If the header says "Customer ID", then look at the "sending" sheet and see if there's still a column marked "customer id" (or close to it). #REF error wrote: Hi Dave, My bad luck,I don't have a previous version of it. Regards, MKJ "Dave Peterson" wrote: Take a look at the previous version if you still have it. If you don't, then you're out of luck. Excel doesn't keep track columns that you delete. #REF error wrote: Hi Dave, Thank you for your quick reply. But I want to know what are the referenced rows which were deleted or moved. "Dave Peterson" wrote: The #Ref! error means that the range that the formula referred to has been deleted. I'd bet it used to point at a column that was deleted. Can you go back to a previous version to see? #REF error wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| 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) | |||
Linear Mode
