| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Ref! after row deletion
How can one stop the #Ref! from appearing after deleting row from above? Exam:
Col A = Date field Col B = Data field Col C = Reference from Col B, formula = if(A2="",C1,B2) Etc. to row 10. Row C11 contains formula =C10 delete rows 3,4,5 leaves row 11, now row 8 with #Ref! What kind of formula can stop the #Ref! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| name deletion | Excel Discussion (Misc queries) | |||
| simple row deletion | Excel Discussion (Misc queries) | |||
| Accidental Deletion | Setting up and Configuration of Excel | |||
| On deletion of rows | Excel Discussion (Misc queries) | |||
| #REF! after cell deletion | Excel Discussion (Misc queries) | |||
Threaded Mode
