De-duping a spreadsheet
 

Does Excel provide a utility for removing duplicate records from a
spreadsheet -- the entire record is considered a duplicate entry based on the
data in one specific field - the rest of the record need not be an exact
duplicate.

I have a file of 41,000+ records with approximately 5000 dups.

I appreciate anyhelp I can get on this one...
thanks!

Hi ML Edwards. Check out Chip Pearson's site.
http://www.cpearson.com/excel/duplicat.htm

--
Sincerely, Michael Colvin


"ML Edwards" wrote:

Does Excel provide a utility for removing duplicate records from a
spreadsheet -- the entire record is considered a duplicate entry based on the
data in one specific field - the rest of the record need not be an exact
duplicate.

I have a file of 41,000+ records with approximately 5000 dups.

I appreciate anyhelp I can get on this one...
thanks!

select the column, do Data=Filter=Advanced Filter. Select Uniques in the
dialog and filter in place. You can ignore criteria. Click OK

Now select all the data and copy and paste it to a new worksheet. Only the
visible (unique rows) will be copies.

--
regards,
Tom Ogilvy


"ML Edwards" <ML wrote in message
...
Does Excel provide a utility for removing duplicate records from a
spreadsheet -- the entire record is considered a duplicate entry based on
the
data in one specific field - the rest of the record need not be an exact
duplicate.

I have a file of 41,000+ records with approximately 5000 dups.

I appreciate anyhelp I can get on this one...
thanks!