another IF question

[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.

 

[JE McGimpsey]

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.

One way:

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

 

[JE McGimpsey]

this produced a list of only names that are in both columns so I
reversed the B5 and "" and worked fine.

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