Eliminating duplicates

[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

 

[Bill R]

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

 

[Don Guillett]

On the SAME or different rows?