items in list B that are not in list A

  • Thread starter Thread starter alexl
  • Start date Start date
A

alexl

hi, say if I have 2 columns, list a and list b, how do I make a list c
which is a list of items in B that are not in A?
 
hi, say if I have 2 columns, list a and list b, how do I make a list c
which is a list of items in B that are not in A?
Click to expand...

In C1 put:

=IF(ISERROR(MATCH(B1,$A$1:$A$10000,0)),B1 & " was not found","")

Then copy C1 down as far as Column C extends

Jim
 
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

Anyone Else Facing Public Folder Migration Errors in Exchange? 0
List Subsets?! 2
data validation list 17
Automated Solution to Repair PST Files 2
help with a vlookup 2
SUM - IF - AND 7
The death of music TV channels in UK - but not Europe? 4
Data Validation and drop-down list using IF, AND and what else? 8

Back
Top