| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of text?
There is a list of text from cell A1 to A100, I would like to count the
number of "Mary" within this range, each cell may contain a senstance, such as Mary goes to school by bus, or John meets Mary in Library ... etc. So far, the counter for Mary is 2. Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of text values in a specific row | Excel Worksheet Functions | |||
| count number of text in a column | Excel Discussion (Misc queries) | |||
| count number of times text appears | Excel Discussion (Misc queries) | |||
| count number of specified text within a text/cell | Excel Discussion (Misc queries) | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Threaded Mode
