compare data in two sheets with duplicate rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to compare two sets of data (with numeric vales) to see what in sheet A doesn't match sheet B and what in sheet B doesn't match sheet A

Any help would be greatly appreciated....

I have used vlookup but it does not account for duplicates

Thanks
d.
 
Hi
try the following in column C: start in C1
=IF(COUNTIF($B$1:B1,B1)<=COUNTIF($A$1:$A$1000,B1),"included in col. A",
"not in col. A")
and copy down
 
You must log in or register to reply here.

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 two worksheets and highlight unmatched Data 0
Compating all rows in two sheets 2
Comparing two columns 7
Compare two Sheets 1
Excel vba code to match duplicates 4
How to compare two spreadsheets 1
Create if partial match then copy and paste data from one cell to another 1
Autohide rows based on formula in another sheet 0

Back
Top