Thread: I a formula that outputs the number of occurances of a specific t.
View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default
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 With QuoteReply With Quote