word search!!!

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

Pivotrend

hello

i have statement in Cell A1 that Update every 1 Minute
ok. i need Cell B1 to Show Up with a result when Cell A1 has a specifi
word i have selected.

ie: A1= Mad-Cow Beef Recall Expands to 8 States 3:12 PM
& my Choosen Word is Mad-Cow , B1 to display =Important

ie2: A1=Away on Business: A Look at 2004
then B1 to display nothing or a dot =
 
J.E. McGimpsey said:
One way:

B1: =IF(ISERR(SEARCH("*Mad-Cow*",A1)),"","Important")
Click to expand...
....

If searching through a cell's value, save a function call.

=IF(COUNTIF(A1,"*Mad-Cow*"),"Important","")
 
that worked perfectly

thanx guys

i got something else
can i add another phrase or a word
for Cell B1 to show

-like if A1= 'Mad-Cow Beef Recall Expands to 8 States 3:12 PM'.
since A1 had the Word 'Mad-Cow' B1 will say 'IMPORTANT MAD COW'
-when A1 Contains a Word like Sars B1 will say 'IMPORTANT SARS'
-or when A1 Contains the word like Aids B1 will say 'IMPORTANT AIDS'

is something like News Tracking Sheet

is it Possible in the same Cell Or do i have to do it Different Cells
 
One way (this isn't pretty but it works):

Enter your keywords in, say, D1:D4. Then in B1:

=IF(SUMPRODUCT(--NOT(ISERROR(SEARCH(D1:D4, A1))), ROW(D1:D4)),
"IMPORTANT " & INDEX(D1:D4, SUMPRODUCT(--NOT(ISERROR(SEARCH(D1:D4,
A1))), ROW(D1:D4))),"")

Alternatively, a bit shorter, but less maintainable:

=CHOOSE(SUMPRODUCT(--NOT(ISERROR(SEARCH(D1:D4,A1))),ROW(D1:D4))+1,"",
"IMPORTANT "&D1,"IMPORTANT "&D2,"IMPORTANT "&D3,"IMPORTANT " & D4)
 
k guys

is it possible to highlight the word that i want in the News Cell

like when A1 comes up with breaking news like:
A1= Mad-Cow Beef Recall Expands to 8 States 3:12 PM

& Mad-Cow will be highlighted with bigger Font & a Different color


is that possible to do with Excel ?
 
Back
Top