Deleting Duplications

[Guest]

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?

 

[Niek Otten]

http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?

 

[Guest]

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

 

[Guest]

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