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&"*")
 
Top