Hi,

I have two columns full of email addresses and there are duplicates in
both the columns. How do I eliminate duplicates? IS there any function
that I could use to solve this problem? Thanks

"Harish" wrote in message
...
Hi,

I have two columns full of email addresses and there are duplicates in
both the columns. How do I eliminate duplicates? IS there any function
that I could use to solve this problem? Thanks

Sort the spreadsheet by the column(s) with duplicates in ascending order



In a helper column type-

=IF(A2=A1,1,0)

and copy down to the last occupied row



Change the formula to numbers. To do this -

Highlight the helper column

Click on <Edit<Copy<Edit<Paste special<Values<OK



Sort on the helper column

Delete all rows where value in the helper column is 1



That will eliminate duplicates in individual columns.



Bill R

On the SAME or different rows?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Harish" wrote in message
...
Hi,

I have two columns full of email addresses and there are duplicates in
both the columns. How do I eliminate duplicates? IS there any function
that I could use to solve this problem? Thanks