Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
Searching a range of numbers for a specified total | Excel Worksheet Functions | |||
Create a new list that singles out duplicate numbers | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions |