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!