I think this'll work

=IF(COUNTA(G1:G4)=COUNTA(SUBSTITUTE(G1:G4,"Bob","" )),"john","bob")

"jenhow" wrote:

I think this has an easy fix, but I can't seem to get my head around it right
now.

I have a column of data which has a variety of formulas in it that return a
variety of words. I would like a way to know if two certain words are in that
column. If they are, I want to know which word is present. Here is an example

Bob
Mike
Tom
Alan

I want to know if it says "John" or if it says "Tom" and it to return which
name so my final result here would be "Tom". My data will never have both a
John and a Tom in the same column, but Tom or John could be in row 3 or 4 or
5, etc.