View Single Post
  #1   Report Post  
ML Edwards
 
Posts: n/a
Default 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!