Deleting rows causes #Ref!

R

Rick

Col A = Date field
Col B = Text
Col AB = reference data from col B
Col AB Row 15 = reference data from Row 14

Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....
 

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

Similar Threads

#Ref! after row deletion 3
#Ref! 1
Need Major Help on the Macro 12
Averaging unique values 2
Counting number of days excluding certain values 3
find and copy it.. 2
Stumped: Find first match in list then reference dif cell in row.. 4
Conditional formatting 3

Top