Hello everyone,

I'm currently trying to find out how to compare two columns that I'm working
with. The first one is within a workbook that has repeating values and the
other column is in another workbook with missing values. Here is an example
of what I want done:

Workbook A Workbook B
Column N Column A
a z
b b
b c
c d
d e

Missing from Column N Workbook A: a, b (only had one occurence of value b)

I have gotten close with this formula but it doesn't quite do what I want:

=IF(COUNTIF(B:B,A1)0,"",A1)

Can someone please help?