#Ref!

R

Rick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top