Deleting Duplicate Data in Excel
 

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?

Deleting Duplicate Data in Excel
 

Simplest is with Data, Filter, Advanced Filter, Unique records only.

RBS


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