T
Tony S.
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!
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!