=IF((COUNTIF($A$1:$A$200,B1)),"",B1)
this will show (not found items)

=IF((COUNTIF($A$1:$A$200,B1)),B1,"")
this will show duplicates)

"Webtek" wrote:

I'm looking for a comaprison formula for text in two different columns. I
have two lists of names (A & B), and I want to generate a third list with the
names that are not on list B - Compare list A and list B. Help!?