Deleting Duplicate Data in Excel

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?
 
R

RB Smissaert

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls help me in finding duplicate entries in a column range 2
Filter duplicate data in excel spreadsheet 2
Counting multiple memberships 1
Duplicate entries in Access 2000 5
Duplicate rows a given number of times in Excel? 3
Coding Question 3
finding duplicate addresses 2
Comparing Large Data Sets in Excel 1

Top