Comparing columns with repeating data

[Chi-Chi]

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?

 

[Squeaky]

HI ChiCHi,

I don't quite understand what you are wanting to do. In your formula you have

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

which looks in COLUMN B for the value of A1. You said workbook A info is in
column N, and workbook B is in column A. No reference is made to column B.

What information are you trying to get out?

Squeaky

 

[Chi-Chi]

This is basically what I want:

Workbook A Workbook B
- Chi-Chi

 

[Chi-Chi]

This is basically what I want:

Workbook A Workbook B
- Chi-Chi