Quote Originally Posted by bconnor
I am sorry if I posted this in the wrong section. I am not quite sure where it should go. Anyhoo, does anyone know how to group data. For instance, lets say I have:

24
25
21
33
33
33
42
44
44

And I wanted a chart that said :

24 1
25 1
21 1
33 3
42 1
44 2

So basically I want to the number of times each value was present in my list. Any ideas on how to do this?


Thanks for any help.

Brendan
-First you need to create a header in row1 and your datat start from A2:A10
-In the menu select Data > Filter > Advanced Filter > under Action select Copy to another location > List range: select A1:A10 (of couse including a header) > Copy to: select your empty cell B1 > click Unique recods only > click OK. Now you have all the unique record in B1:B10
- Formula in C2 =COUNTIF($A$2:$A$10,B2)
- Drag from C2 to C10