Text Counting

T

TYTQ

How to count the frequency of a word appearing in a range of data, even the
word appears together with other word, i.e. "manager" and "assistant
manager". When criteria is set as "manager", and "assistant manager" will
also be counted. Thank you.
 
T

T. Valko

Try this:

=COUNTIF(A1:A10,"*manager*")

Or, use a cell to hold the word:

B1 = manager

=COUNTIF(A1:A10,"*"&B1&"*")
 

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

Office365 Family + TXT or MX Domain 0
How to have two tables on same line? 1
List items based on the count given 4
Remove Identical words 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Embed the same Excel multiple times 0
Extracting data/using COUNTIFS 2

Top