Comparing Spreadsheets - best practices

J

James

I have two spreadsheets that contain names, addresses, telephone numbers,
etc. of prospects. Both sheets have about 4000+- contacts. I want to
compare the two and accomplish a couple things but i'll just start with the
first and go from there:

I want to see what companies are found on both lists so that i can compare
the names and addresses and update one list against the other (one is new and
one is old).

Any ideas on the best way to go about this?
 
D

DM

if you either know Access or are willing to try if you have Access, import
the two into one table and generate a report by grouping the companies. this
will keep like info together for comparison.
 

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

Comparing 2 spreadsheets 1
Excel Comparing two columns 1
Comparing two ranges of data and identify the common/like informat 2
Comparing 2 spreadsheets to remove duplicate names 2
comparing two spreadsheets 2
similar names - two spreadsheets 3
comparing columns in two spreadsheets 1
Finding unique data between two diffrent spreadsheets 2

Top