Deleting Duplications

R

Ray_V

I am attempting to delete duplicated names throughout my spreadsheet of
contacts in Microsoft Excel 2003, but it will take me a long time to manually
go through 108k leads! How might I go about deleting duplicated material?
 
E

Evan

Try Advanced Filter under Data > Filter using
[x] Copy to another location
List range: Your data in one column with a header
Criteria range: An empty cell
Copy to: An empty column
[x] Unique records only

Or you could do it with
Sort the data
An a neighboring column put 0 in the first row then =if(a3=a2,1,0) & fill
Select the new info & Data > Filter > AutoFilter with header
Click the down arrow at the header, choose 0
Copy the filtered data to another sheet
 
M

Mike The Newb

I simply create a column with vital/unique data concatenated and then sort
the file by the concatenation. Then insert a column next to it and type
=if(a2=a1,0,1) - assuming the concatenation is in column A - and copy it all
the way down. All the first found results will be assigned a 1 and the
duplicates will get a 0. Sort by the 0 &1 column and delete all the 0's.

Regards,
Mike
 
Top