IF statement question
I have a data set that has several thousand names and I am trying to
remove any duplicates. I used the formula IF(A1=A2,0,1) but the fields
I know are identical are returning "1". I think it might be a format
problem, but it has me stumped. Thanks
|