Text Counting

  • Thread starter Thread starter TYTQ
  • Start date Start date
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.
 
Try this:

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

Or, use a cell to hold the word:

B1 = manager

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