Sequential Numbering.

[Rodney]

I have a column of numbers in
assorted sequential but non contiguous blocks from 4 to 30.
I seek a formula to renumber them 1 and onwards,
until a lower number is found, whereupon they would begin again at 1.

Can anyone assist please?

eg:

Col A
2
3
6
8
13
4
5
6
8
12
21

I seek Column B to show
1
2
3
4
5
1
2
3
4
5
6

 

[Bill Kuunders]

enter 1 in B1
enter =IF(A2>A1,B1+1,1) in B2 and copy it down

Regards

 

[Rodney]

Thanks Bill.
Worked a treat.

Regards from Perth.


| enter 1 in B1
| enter =IF(A2>A1,B1+1,1) in B2 and copy it down
|
| Regards
|
| --
| Greetings from New Zealand
| Bill K

 

[Bill Kuunders]

You're welcome.
Thanks for the feedback.
Bill K