NEED HELP PLEASE!! Generating numbers in cell

[RKH1989]

What I am Attempting to do seems simple but I cannot for the life of me get it right.

I'm trying to generate sequential number based on my starting number. Lets say 220500.
If cell B2 has any text the a2 will automatically populate the number 220500. This number would increase by one in the following rows as the B cell is populated.
I've tried combining if statement with sequence how ever it populated the whole A column when text was add to the b cell. I know I'm missing something simple.

Can someone assist with this?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SEQUENCE(COUNTA(B:B),,220500)

if you have something in B1 then subtract 1 from the counta.

 

[RKH1989]

Hi & welcome to MrExcel.
How about

=SEQUENCE(COUNTA(B:B),,220500)

if you have something in B1 then subtract 1 from the counta.

I appreciate it.
I wrote it like
=IF((C2= "*");SEQUENCE(COUNTA(C:C),1,220500))

I'm just getting false back.

 

[Fluff]

Did you try the formula I posted?

 

[Alex Blakenburg]

If you need to cover off the that the starting position is blank, then you could just wrap Fluff's formula in an IFERROR statement.

=IFERROR(SEQUENCE(COUNTA(B:B),,220500),"")

(or C:C since you seem to have swapped columns between post 1 and post 3)