try it:

http://www.j-walk.com/ss/excel/usertips/tip027.htm

hth
regards from Brazil
Marcelo

" escreveu:

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