Sequential Numbering.

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

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

Regards

--
Greetings from New Zealand
Bill K
"Rodney" <[email protected]> wrote in message
news:[email protected]...
>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
>
>
>
>

Thanks Bill.
Worked a treat.

Regards from Perth.


"Bill Kuunders" <[email protected]> wrote in message news:[email protected]...
| enter 1 in B1
| enter =IF(A2>A1,B1+1,1) in B2 and copy it down
|
| Regards
|
| --
| Greetings from New Zealand
| Bill K

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

"Rodney" <[email protected]> wrote in message
news:[email protected]...
> Thanks Bill.
> Worked a treat.
>
> Regards from Perth.
>
>
> "Bill Kuunders" <[email protected]> wrote in message
> news:[email protected]...
> | enter 1 in B1
> | enter =IF(A2>A1,B1+1,1) in B2 and copy it down
> |
> | Regards
> |
> | --
> | Greetings from New Zealand
> | Bill K
>
>
>