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!