Hi Leo,

The OP's posting indicates, that data is various percentages, positive
and/or negative and in no particular order.

The OP's original post clearly showed a consecutive integer sequence, 1 to
4800, apparently starting in A1. The problem was to reproduce the desired
number sequence, which is what my solution does - I could just as easily
have used ROW() instead of the A1 reference.

I am also aware that there was a mention of percentages the day after I
posted my reply but, nonetheless, the OP said my solution provided the
answer sought. Maybe that's because it was being used as a key (eg via
INDEX, MATCH, OFFSET or LOOKUP, etc) to the percentages.

Your clever formula doesn't reorganize the *contents* of the cells but
"only" the numbering.

That's all I was trying to do.

My VBA solution reorganizes the contents.

But it gives the wrong result:
A B C
1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 11
12 22 22
13 23 23
14 24 24
15 25 25
16 26 31
22 42 42
23 43 43
24 44 44
25 45 45
26 46 51
32 62 62
33 63 63
34 64 64
35 65 65
36 66 71
The original sequence is 'A', your's is 'B' and mine is 'C'.

Cheers

--
macropod
[MVP - Microsoft Word]