View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] trevorbragdon@yahoo.com is offline
external usenet poster
 
Posts: 1
Default 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