MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing data in two different spreadsheets

Posted by Jessica on February 04, 2002 9:44 AM

i have two databases, each in which has generated a list of customer names, phone numbers, etc. These lists are both in seperate workbooks in excel format. Each also has over 15000 entries. I would like to somehow merge this information and pull out any name that is not found on both databases, I also want to pull out any name found on both docs more then once. My goal here, to give you insight, is to delete any customer account that isnt provisioned on both databases, and also to purge some of the many duplicate accounts that were provisioned on both, but more then once. PLEASEEE help- I know this can be done, as I have been provided this information before, Im not sure how to do it. Please email any information you think would help. Thanks so much

Posted by Scott on February 04, 2002 12:22 PM

A simple way would be to paste one under the other, and then sort by customer, or customer account. Then used a formula like =if(A1=A2,1,0)and copy down. Then using auto filter, you can select "1" and then delete these entries.

Posted by Jessica on February 04, 2002 9:36 PM


Thanks for your help- Could you explain this in a little more detail as Im having trouble with these instructions. If I paste the documents as you suggest, the information will be mixed after I sort by name or account number, leaving me with a really large doc and no clue what name is from which database...or am I misunderstanding what you are saying- I appreciate your input- Please email me at with any additional information .