Auto numbering dymanic row

[trduy1908]

Please help,

I want to get number in dynamic row.
Example: in column C, auto numbering based on value of B, if (B:B) have line is blank then, next line auto numbering start = 1

	A	B	C
row 1	Test
row 2		Test	1
row 3		Test	2
row 4	Test
row 5		Test	1
row 6		test	2
row 7		Test	3

 

[Joe4]

If the first row is actually row 1 in Excel, place this formula in cell C1:

=IF(B1="","",1)

Put this formula in cell C2 and copy down for all remaining rows:

=IF(B2="","",IF(B1="",1,C1+1))

 

[trduy1908]

If the first row is actually row 1 in Excel, place this formula in cell C1:

=IF(B1="","",1)

Put this formula in cell C2 and copy down for all remaining rows:

=IF(B2="","",IF(B1="",1,C1+1))

I save my life, thanks a lot. Wish you good health and success. Thanks!

 

[Cubist]

Another option.

Book3
	A	B	C
1	Test
2		Test	1
3		Test	2
4	Test
5		Test	1
6		test	2
7		Test	3
Sheet13

Cell Formulas
Range	Formula
C1:C7	C1	=LET(s,SCAN(0,B1:B7,LAMBDA(a,b,IF(ISBLANK(b),0,a+1))),IF(s=0,"",s))
Dynamic array formulas.

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[trduy1908]

Another option.

Book3
	A	B	C
1	Test
2		Test	1
3		Test	2
4	Test
5		Test	1
6		test	2
7		Test	3
Sheet13

Cell Formulas
Range	Formula
C1:C7	C1	=LET(s,SCAN(0,B1:B7,LAMBDA(a,b,IF(ISBLANK(b),0,a+1))),IF(s=0,"",s))
Dynamic array formulas.

Thank! Cubist

 

[smozgur]

I save my life, thanks a lot. Wish you good health and success. Thanks!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.