Listing recurring values in a column alphabetically and automatically AND counting the occurrence of each value

[Help101]

Is there a non-array formula and not using VBA script that would automatically pick recurring values in Column A, list them alphabetically (or alphanumerically) in Column B, and count how many times these recurring values appeared in Column A and list these counts in Column C? Thanks.

..........A..........B..........C
1........CC.......A2A......2
2........C..........CC.......3
3........A2A
4........BB1
5........A2A
6........CC
7........CC

 

[healey21]

Please don't duplicate your thread you can use BUMP

 

[Help101]

I apologize, healey21, that I inadvertently posted this thread twice. The FAQ talks of an Edit button used to delete posts but it is nowhere to be found on my screen. I have self-reported this inadvertent posting before you posted above so that a moderator can take action and consolidate replies into just one thread. Thanks.

 

[Andrew Poulsom]

Duplicate:

http://www.mrexcel.com/forum/excel-...matically-counting-occurrence-each-value.html