G
Guest
I am trying to get excel to stop automatically editing my formulas when I
delete cells. Like right now I have a two lists of data and I'm going through
to find the same data points between the lists. So I have on list in column B
and one in column C. So my formula in column D is =if(B1=C1, "TRUE") but
every time I go to delete cells from column C and move them to the top my
formula changes to =if(B1=!REF, "True") and if I deleted say one cell the
next line row in column D the formula will be =if(B2=C1, "TRUE") How Can I
stop Excel from doing this?
delete cells. Like right now I have a two lists of data and I'm going through
to find the same data points between the lists. So I have on list in column B
and one in column C. So my formula in column D is =if(B1=C1, "TRUE") but
every time I go to delete cells from column C and move them to the top my
formula changes to =if(B1=!REF, "True") and if I deleted say one cell the
next line row in column D the formula will be =if(B2=C1, "TRUE") How Can I
stop Excel from doing this?