Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Ref!
When deleting rows above my reference line, I get #Ref! in my referenceline.
How can I keep the proper reference in the reference line? Example: Col A is a date field Col B row 1 contains a Text "This is it." , row 2 contains =if(A2="",B1,"Why?" row 3 contains =if(A3="",B2,"Because",,, and so on until you get to the reference line which contains =(B10)... after I delete rows( 7,8,9 ) I get #Ref! in row 10. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Ref!
See your other post.
"Rick" wrote in message ... When deleting rows above my reference line, I get #Ref! in my referenceline. How can I keep the proper reference in the reference line? Example: Col A is a date field Col B row 1 contains a Text "This is it." , row 2 contains =if(A2="",B1,"Why?" row 3 contains =if(A3="",B2,"Because",,, and so on until you get to the reference line which contains =(B10)... after I delete rows( 7,8,9 ) I get #Ref! in row 10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|