Deleting Duplicate Data in Excel

  • Thread starter Thread starter hagend87
  • Start date Start date
H

hagend87

I have two excel files with over 10,000 total combined locations. I need tocross reference both files and make sure there are no duplicated entries because I'm importing the addresses into a database. Are there any shortcutsor suggestions on how to accomplish this without going through the entriesone by one?
 
Simplest is with Data, Filter, Advanced Filter, Unique records only.

RBS


I have two excel files with over 10,000 total combined locations. I need to
cross reference both files and make sure there are no duplicated entries
because I'm importing the addresses into a database. Are there any shortcuts
or suggestions on how to accomplish this without going through the entries
one by one?
 
Back
Top