Forum Discussion
Need formula to auto update cell reference
I am trying to compare Column A to Column B, so in C I did =A1=B1.
Where Column C says false, I delete the data from Column A (as B is the data I truly need). When I have done this in the past...
Hi Amanda,
In general here it shall be no difference between 2010 and 2016. Could you please attach Excel file as on your screenshot instead?
See attached. I deleted cell A3 and that shifted everything up, but I got the reference error. Also, clicked in B5 and inserted to move the number 70 down and typically C6 would update to TRUE, but it didn't.
Amanda, perhaps your 2010 in manual calculation mode, and 2016 in automatic. You may check in File->Options->Formulas, or in ribbon
at least for 2016
Unfortunately, that did not help.
