Deleting rows causes #Ref!

  • Thread starter Thread starter Rick
  • Start date Start date
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....
 
Back
Top