Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default "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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default "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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default "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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default "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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF #N/A ( in a range), "ALERT","OK" Steve Excel Worksheet Functions 7 July 22nd 09 08:57 PM
Printing From An "Alert" Cell Ra Excel Discussion (Misc queries) 4 May 23rd 09 07:45 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Repeat alert, "No more new fonts may be applied to this workbook" NoiseGuy Excel Discussion (Misc queries) 3 October 23rd 06 02:09 PM
How do I turn off the "do you want to save" alert in excel? SLB, accounting Excel Discussion (Misc queries) 1 August 29th 06 10:38 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"