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