grouping data

One easy way to do this (assuming you really have a lot more data than is shown) would be to create a Pivot table / Pivot Chart based on your datatable.

See Excel's menu Data >> Pivot Table. In Step one of the wizard, use the default selections. In Step 2, select the column with your data. Note that the column of Data needs to have a header row.

In the pivot table itself, drag in the data's header twice, once in the "rows", and again in the "data".

After that, right click anywhere in the Pivot table and select the Wizard. This time, click on the "Layout" button. In the layout, right-click on the data's header in the "data" section, and change the field from Sum (the default) to "Count".

After you have the data table the way you want it, use the Pivot Table toolbar and click on the Chart button. This will create the chart you seek.

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

If the Pivot Table beats you, you can put, in B1,

=IF(COUNTIF(A$1:A1,A1)>1,"",COUNTIF(A:A,A1))

and formula fill that to the end of your data, then Data Filter and filter column B for Non-Blanks

Copy the rows displayed to a new location.

But, it's worthwhile to practice with the Pivot Table.

hth
---