Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting text | Excel Worksheet Functions | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Counting text? | New Users to Excel | |||
counting text | Excel Worksheet Functions | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions |