ExcelBanter - Text Counting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text Counting (https://www.excelbanter.com/excel-worksheet-functions/211343-text-counting.html)

TYTQ

Text Counting

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. Valko

Text Counting

Try this:

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

Or, use a cell to hold the word:

B1 = manager

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

--
Biff
Microsoft Excel MVP

"TYTQ" wrote in message
...
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.

All times are GMT +1. The time now is 10:22 PM.