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
|