I a formula that outputs the number of occurances of a specific t.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Artem wrote...
I am trying find out a number that a specific word appears in a single
Click to expand...
worksheet, is there an excell function that can do that?
Click to expand...

=SUMPRODUCT((LEN(A1:Z1000)-LEN(SUBSTITUTE(A1:Z1000,YourWord,"")))
/LEN(YourWord))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
Counting multiple memberships 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Voltage supply issue related to NUC PC Core i7 0
How to calculate number of occurencies of a specific number number 4
Best method / software for graphical output from dynamic excel data 0
Count specific characters in a cell 7
Excel Sequential Numbering System 0

Back
Top