ExcelBanter - Need Comparison Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need Comparison Formula (https://www.excelbanter.com/excel-discussion-misc-queries/136617-re-need-comparison-formula.html)

ufo_pilot

Need Comparison Formula

=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!?

All times are GMT +1. The time now is 03:25 PM.