Eliminating duplicates

  • Thread starter Thread starter Harish
  • Start date Start date
H

Harish

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 said:
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
Click to expand...

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
 
Back
Top