"Alert" only if 'not contained in'
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Steve" wrote in message
...
Perfect. Thanks much. Both worked great.
Steve
"T. Valko" wrote:
Try one of these:
=IF(COUNTIF(B2,"*"&A2&"*"),"","Alert")
=IF(ISNUMBER(SEARCH(A2,B2)),"","Alert")
--
Biff
Microsoft Excel MVP
"Steve" wrote in message
...
I have 2 separate name data downloads.
One in column A, the other in Column B
A B C
Smith Smith, Alex IF(A2=B2,"", "ALERT")
I really only need C to produce the alert if a different name is in A,
and
therefore want the above sample to result in ""
Can a/the formula show in C something like...
If all of A is contained in B, then "", "Alert").
Thanks,
Steve
.
|