View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seller Smith Seller Smith is offline
external usenet poster
 
Posts: 2
Default 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