Cross reference?

  • Thread starter Thread starter Kelly Naff
  • Start date Start date
K

Kelly Naff

Hello there. Here is my problem. In one file, we'll call
file "A", there is a list of lets say 100,000 phone
numbers. Now in file "B" there is a list of 50,000 phone
numbers, some may match those is file "A" and some may
not. I need a way to combine those two files and have
only the numbers in file "A" that didn't match with the
numbers in file "B" go into some sort of group of their
own. Is this do-able??

Kelly
 
Given the size of your lists, I think excel is not really the product.
Load the data into MSaccess and run the 'Find duplicates query wizard'
and 'Find unmatched query wizard'

They are intended to solve just your problem.
 

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

Back
Top