Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested function 'FIND(OR)'
One way:
If you're just checking for the presence of at least one of the words: =SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0 In article , Titoto wrote: is there a way to use the function 'FIND(OR)' to search for multiple words within a cell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested function 'FIND(OR)'
Countif tells me a word is within the is there, but I don't know wich word.
I would like the formula to find/search for multiple words and display the word find. PS. in any given cell will contain 1 of the words needed. Thanks for your help "JE McGimpsey" wrote: One way: If you're just checking for the presence of at least one of the words: =SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0 In article , Titoto wrote: is there a way to use the function 'FIND(OR)' to search for multiple words within a cell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested function 'FIND(OR)'
Then you could use something like:
=IF(COUNTIF(A1,"*word1*"),"word1",IF(COUNTIF(A1,"* word2*"),"word2",IF(COU NTIF("*word3*"),"word3",""))) In article , titoto wrote: Countif tells me a word is within the is there, but I don't know wich word. I would like the formula to find/search for multiple words and display the word find. PS. in any given cell will contain 1 of the words needed. Thanks for your help "JE McGimpsey" wrote: One way: If you're just checking for the presence of at least one of the words: =SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0 In article , Titoto wrote: is there a way to use the function 'FIND(OR)' to search for multiple words within a cell |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested function 'FIND(OR)'
Thanks - I tried 3 words and it is working fine - I don't think 'IF' function
will allow more than 7 words and I have roughly 20. Any idea Again thanks "JE McGimpsey" wrote: Then you could use something like: =IF(COUNTIF(A1,"*word1*"),"word1",IF(COUNTIF(A1,"* word2*"),"word2",IF(COU NTIF("*word3*"),"word3",""))) In article , titoto wrote: Countif tells me a word is within the is there, but I don't know wich word. I would like the formula to find/search for multiple words and display the word find. PS. in any given cell will contain 1 of the words needed. Thanks for your help "JE McGimpsey" wrote: One way: If you're just checking for the presence of at least one of the words: =SUM(COUNTIF(A1,{"*word1*","*word2*","*word3*"})) 0 In article , Titoto wrote: is there a way to use the function 'FIND(OR)' to search for multiple words within a cell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested MID and FIND - OR? | Excel Worksheet Functions | |||
Nested IF, reports incorrectly, can't find anything like it to ref | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Nested Find problem | Excel Programming |