| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting groups of words
I have a column of cells that I would like to count the occurances of
duplications of each group of words. Example: AMIN500S 1 AMIN400EC 9 AMINO500 5 and so on. I would like a formula that does not require me to input any specific text to search for in the formula as there are over 12000 entries in the column. Any help on this dilema is greatly appreciated. AMIN500S AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMIN400EC AMINO500 AMINO500 AMINO500 AMINO500 AMINO500 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting within groups | Excel Worksheet Functions | |||
| COUNTING GROUPS IN ONE COLUMN | Excel Discussion (Misc queries) | |||
| Counting highest values within groups of four | Excel Worksheet Functions | |||
| counting age groups | Excel Discussion (Misc queries) | |||
| counting age groups | Excel Worksheet Functions | |||
Threaded Mode
