| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding text
If I have text in a cell = "I love Excel", I want to find and count the
number of times "Excel" appears in a range. CountIF seems to want all words. TIA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text
=SUM(IF(FIND("Excel",A1:A100,1),1,0))
array-enter it = CTRL+SHIFT+ENTER |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text
Your formula returns #VALUE! error
=SUM(IF(FIND("Excel",A1:A100,1),1,0)) Try like this: =SUM(IF(ISNUMBER(SEARCH("Excel",A1:A100)),1)) ctrl+shift+enter, not just enter or =COUNTIF(A:A,"*Excel*") "Jarek Kujawa" wrote: =SUM(IF(FIND("Excel",A1:A100,1),1,0)) array-enter it = CTRL+SHIFT+ENTER |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text
Great...seems that =COUNTIF(A:A,"*Excel*") works ok and is a smaller
formula. I see that the "*" must specify a wildcard, thats where my error was. Tx.... "Teethless mama" wrote in message ... Your formula returns #VALUE! error =SUM(IF(FIND("Excel",A1:A100,1),1,0)) Try like this: =SUM(IF(ISNUMBER(SEARCH("Excel",A1:A100)),1)) ctrl+shift+enter, not just enter or =COUNTIF(A:A,"*Excel*") "Jarek Kujawa" wrote: =SUM(IF(FIND("Excel",A1:A100,1),1,0)) array-enter it = CTRL+SHIFT+ENTER |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding text
yep, sorry
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding text | Excel Worksheet Functions | |||
| Finding a text box | Excel Worksheet Functions | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding a particular text | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Linear Mode
