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?