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