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!