items in list B that are not in list 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?

 

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

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