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
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
try it:
http://www.j-walk.com/ss/excel/usertips/tip027.htm
hth
regards from Brazil
Marcelo
"[email protected]" 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
>
>
You can also try this site:
http://www.cpearson.com/excel/duplicat.htm
I found this site very useful.
"Marcelo" wrote:
> try it:
>
> http://www.j-walk.com/ss/excel/usertips/tip027.htm
>
> hth
> regards from Brazil
> Marcelo
>
> "[email protected]" 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
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks