I know I have seen this somewhere, but can't seem to find it. I have a column of names (B1:B10). What I would like to do is put a formula in C1 that inserts "YES" if three (3) specific names (for example, "John", "Mary", or "Frank") are present in B1:B10, and "NO" if they aren't .
Taks in advance.
Taks in advance.