Condensing a list of numbers into a range
 

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.

13, 5, 6, 1011, 1316, 20, 2223

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

Condensing a list of numbers into a range
 

Grandpoobah wrote:
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.

13, 5, 6, 1011, 1316, 20, 2223

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