| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I a formula that outputs the number of occurances of a specific t.
I am trying find out a number that a specific word appears in a single
worksheet, is there an excell function that can do that? |
|
#2
|
|||
|
|||
|
Artem wrote...
I am trying find out a number that a specific word appears in a single worksheet, is there an excell function that can do that? =SUMPRODUCT((LEN(A1:Z1000)-LEN(SUBSTITUTE(A1:Z1000,YourWord,""))) /LEN(YourWord)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
Linear Mode
