| 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 |
| 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) | |||
Threaded Mode
