Condensing a list of numbers into a range

[Guest]

Hi all,

I have a range of numbers, i.e. 1,2,3,5,6,10,11,13,14,15,16,20,22,23 and my
aim is to produce/convert this into a list that contains ranges and single
values, i.e.

1>3, 5, 6, 10>11, 13>16, 20, 22>23

Any ideas? This is a really long list, and the prospect of doing this
manually is causing me considerable headaches.

Many thanks in advance,

Andy

 

[Franz Verga]

Hi all,

I have a range of numbers, i.e. 1,2,3,5,6,10,11,13,14,15,16,20,22,23
and my aim is to produce/convert this into a list that contains
ranges and single values, i.e.

1>3, 5, 6, 10>11, 13>16, 20, 22>23

Any ideas? This is a really long list, and the prospect of doing this
manually is causing me considerable headaches.

Many thanks in advance,

Andy

Hi Andy,

I think you could use a pivot table and than group numbers...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy