View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Grandpoobah Grandpoobah is offline
external usenet poster
 
Posts: 1
Default 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