Duplicates

M

mmcstech

I am working with two databases. The first one is 6139 records that we have
already mailed brochures out to. The second one is 5300 +. I want to
compare the second data base with the first and eliminate the duplicates in
the second database. I have tried the duplicate elimination function in
Excel but this does not give me the info. I need. Any ideas?
Also...the supplier of the second data base put an apostrophe before the
beginning of the text in each of the cells. Can they be eliminated simply
with a function?

Thanks!
 

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

Remove Duplicates logic 3
Using vlookup to populate multiple rows at once 6
removing duplicate data from a single list 1
Duplicates are GOOD: How to find the most duplicated values? 1
How to remove duplicated data repeated.... 7
Compare two spreadsheets and eliminate duplicates 7
Copy/paste in based on duplicate value in previous row 0
Compare data in docs 2

Top