| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count frequency of a word in range of cells
Hi.
I want to count the word "overachievement" in a range of cells. Problem is, this word appears with other words in cells. Like "Overachievement Q1" or "Overachievement bonus" or "overachievment growth". The word does not stand alone. Is there a way to use count or frequency function to do this? Please help. Urgent! -- Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count frequency of a word in range of cells
hi
You received a response from Pete_UK yesterday; did you try it, it should work, if not tell us what is happening. HTH John "learningaccess" wrote in message ... Hi. I want to count the word "overachievement" in a range of cells. Problem is, this word appears with other words in cells. Like "Overachievement Q1" or "Overachievement bonus" or "overachievment growth". The word does not stand alone. Is there a way to use count or frequency function to do this? Please help. Urgent! -- Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count frequency of a word in range of cells
Try,
=COUNTIF(A1:H35,"*overachievement*") Mike "learningaccess" wrote: Hi. I want to count the word "overachievement" in a range of cells. Problem is, this word appears with other words in cells. Like "Overachievement Q1" or "Overachievement bonus" or "overachievment growth". The word does not stand alone. Is there a way to use count or frequency function to do this? Please help. Urgent! -- Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the frequency of each word in Excel | Excel Discussion (Misc queries) | |||
| Count Occurance of Text/Word in a Range | Excel Discussion (Misc queries) | |||
| Why does a simple frequency distribution count out of range data? | Excel Worksheet Functions | |||
| count number of occurances of a word in a range | Excel Worksheet Functions | |||
| SPECIFIC WORD COUNT FROM A RANGE | Excel Discussion (Misc queries) | |||
Linear Mode
