Using "IF" with a "NAME" search?
Ooops... When I first read your function I thought it would return 2 if it
found multiple instances of John in the same cell. Turns out my brain is
still on vacation but my fingers are at the keyboard...
--
HTH...
Jim Thomlinson
"Jim Thomlinson" wrote:
I actually used to know a guy named John Johnson and I had a professor named
Ivan Ivanovich. Your function would lead me to believe that these individuals
were twice as good (which I am sure they might agree with)...
--
HTH...
Jim Thomlinson
"Tom Ogilvy" wrote:
=Countif(K2,"*John*")
--
Regards,
Tom Ogilvy
"Jo" wrote:
Hi,
Say I have a "Name" column which could have someone name like "John
Davis" or "Adam John Nelson"
Now, I want to use "IF" statement so that any name has the word "John"
be considered. For example, using the above example I want to get the
answer like this:
John Davis
Adam John Nelson
Using a statment liks this: If(K2="John", "1","0") wouldn't work
right! Help please....
Thanks,
Jo
|