Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Alert" only if 'not contained in'
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Alert" only if 'not contained in'
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Alert" only if 'not contained in'
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 . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF #N/A ( in a range), "ALERT","OK" | Excel Worksheet Functions | |||
Printing From An "Alert" Cell | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Repeat alert, "No more new fonts may be applied to this workbook" | Excel Discussion (Misc queries) | |||
How do I turn off the "do you want to save" alert in excel? | Excel Discussion (Misc queries) |