Deleting Duplications
 

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?

Deleting Duplications
 

http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ray_V" wrote in message ...
|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?

Deleting Duplications
 

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

"Ray_V" wrote:

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?

Deleting Duplications
 

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


"Ray_V" wrote:

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?