Scrubbing two excel worksheets, returning unique values from one sheet

J

jphogan

Hello,
I'm hoping somebody can help me with this. I have two worksheets wit
databases of names, addresses, etc. The headers are Email, Name
address, etc.

I want to compare worksheet 1 with worksheet 2 and leave ONLY thos
records on worksheet 1 that are not found in worksheet two.

I've done a lot of searching through the forums and have only foun
something similar for single columns, not comparing multiple columns
Any help is appreciated. Thank you
 

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

Compare data (2 columns) from 2 worksheets within a workbook 2
Excel for comparing two columns exceeding 1,048,576 count 3
Compare two datasets and extract unique records from each 3
multiple column comparison on 2 worksheets 1
Compare two different workbook sheet to show the difference in text 0
Conditional Formatting Between Worksheets 0
Merging text cells from two worksheets with one shared column 3
Can I compare two worksheets using Excel? 5

Top