Tony S. -

For a VBA approach, you could look at the Better Histogram VBA code
available from the Histogram page at www.treeplan.com. That code uses the
FREQUENCY worksheet function for grouping data into a frequency distribution
table, and you could disregard the charting code.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Tony S." wrote in message
...
Sean,
Thanks for your reply, but I was looking for a routine to automatically
create the out I needed. Do you know if there is a VB way to acomplish
this?

"Sean Timmons" wrote:

Make sure you have a coumn Header (i.e. - "Numbers").Highlight your
column,
Data - Pivot Chart.

Drop Numbers in the row and data fields.

right-clik on one fo the numbers in the row field - Group and show
Detail -
Group.

Pick your starting number and the range per, so starting at 1 by 6 and
pick
a top range.

"Tony S." wrote:

Can someone help me with a way to produce a grouping from a list of
random
numbers. I know the column need to be sorted first, but I don't know
how to
group the results. In col "A" I have something like:
1
2
4
6
8
9
12
10
23
11
3
13
5
15

I want to produce something like:
1-6, 8-13, 15, 23

Thanks!