Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort numeric range and insert gaps
I have a collection of sequential numbers in excel, I would like to
sort them and have any gaps represented by an empty cell. EG: 1, 3, 4, 5, 8, 9 <sorted with gaps [1] [ ] [3] [4] [5] [ ] [ ] [8] [9] I can't for the life of me find a way to do this. Is it possible? I will need to do this often with different worksheets, i would rather not have to create VB to do it, but if that's the only option... Thanks for any help, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to insert a formula based on a range | Excel Discussion (Misc queries) | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Changing the range of a table sort | New Users to Excel | |||
Auto insert a range | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |