items in list B that are not in list A

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?
 
A

anon

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
 
Top