another IF question

H

Harvey Waxman

I have two columns of names, A, B.

Some names appear in both columns.

I want names in C that appear only in column B

=IF(B5<>$A$5:$A$200,B5) array entered of course, doesn't work. I
looked at the selection of functions but couldn't see how to fix it.
 
J

JE McGimpsey

Harvey Waxman said:
I have two columns of names, A, B.

Some names appear in both columns.

I want names in C that appear only in column B

=IF(B5<>$A$5:$A$200,B5) array entered of course, doesn't work. I
looked at the selection of functions but couldn't see how to fix it.
Click to expand...

One way:

=IF(COUNTIF($A$5:$A$2000,B5),B5,"")
 
J

JE McGimpsey

Harvey Waxman said:
this produced a list of only names that are in both columns so I
reversed the B5 and "" and worked fine.
Click to expand...

Yup - I misread your intention. Thanks for the feedback.
 
Top