Sequence - Blank Cell Adding One

Uses previous cell to see if blank exist then places a sequence

Formula in Cell B3 =IF(A3=A2,B2+1,1)

Example

Number Sequence

A B

2 123456789 1

3 2

4 322222222 1

5 888888888 1

6 2

7 3

8 111112222 1