PLEASE HELP! Sorting numbers(make gap where missing number)now with example i xlsx

**jegerikke** · 12-22-2009, 04:33 AM

Hi.

I made a list(see attachment).

colum A is in order low to high number.
but when i sort colum B i want it to live a gap where im missing a number.
Now it just makes the list form low to high.
is it possible?
i want it like i sett it up in the ok.jpg

hope on quick respons.

**jrdnoland** · 12-22-2009, 07:39 AM

Your spacing in the OK version is not consistent so it's hard to tell exactly what you're looking for.

With some code you could sort the column, put it into an array and then compare the array elements and put it back into the column with spacing, but you have to decide what the spacing "rule" will be.