Formula to number sequentially

[Arts]

Hi all

I have a list of items that needs numbering (goes down quite a way) but I can't seem to find a formula to number each item as there is a gap after each line.

example below (which I did manually for the first few) there is always number against text then a blank row then number... I tried a few ways using sequence and counta but cant seem to get it to number sequentially. I don't mind putting the formula in helper column and then pasting over if that makes it easier

Thanks as always

on excel 365

1	Text	Text
2	Text	Text
3	Text	Text
4	Text	Text
5	Text	Text
6	Text	Text

 

[Cubist]

I think what you're attempting to do is generate a sequence of 1 row and each sequence starts with the COUNTA() like this, however, a sequence with 1 row is the same as Option #2 in post #3.

Book2
	A	B	C
1	Option3	Header1	Header2
2	1	Text	Text
3
4	2	Text	Text
5
6	3	Text	Text
7
8	4	Text	Text
9
10	5	Text	Text
11
12	6	Text	Text
Sheet1

Cell Formulas
Range	Formula
A2:A12	A2	=IF(B2="","",SEQUENCE(1,,COUNTA($B$2:B2)))

 

[Arts]

Adding MAX will eliminate the repeated values as you drag the formulas down i.e. MAX(1) = 1; MAX(1,2) = 2; MAX(1,2,3) =3; ect...

Thank you for that explanation!

You are completely right in what I was trying to achieve and the formulas you provided were perfect. I was looking at the formula Hagia provided (and Fluff slightly shortened) in the hope of understanding them but then you provided =IF(C2="","",COUNTA($C$2:C2)) which I thought was brilliant in that it seemed easier to understand (at least me to me, not taking anything anyway from Hagia's solution) It's amazing when people can create formulas like that (hats of to them) but when I saw yours I was quite pleased as that seemed easier to breakdown so thank you once again!