Auto Numbering in excel

[Snowmanx812]

Example.xlsx
	B	C	D
2
3	1.00	<	MAIN HEADING
4	1.01		Blah blah blah
5	1.02		Blah blah blah
6	1.03		Blah blah blah
7	1.04		Blah blah blah
8	1.05		Blah blah blah
9	1.06		Blah blah blah
10
11	2.00	<	Sub Heading
12	2.01		Blah blah blah
13	2.02		Blah blah blah
14	2.03		Blah blah blah
15	2.04		Blah blah blah
16	2.05		Blah blah blah
17	2.06		Blah blah blah
18
19	3.00	<	Sub Heading
20	3.01		Blah blah blah
21	3.02		Blah blah blah
22	3.03		Blah blah blah
23	3.04		Blah blah blah
24	3.05		Blah blah blah
25	3.06		Blah blah blah
26
Sheet1

 

[Snowmanx812]

I would like a formula in column B (possibly a multi IF statement?) that will change the major numbering i.e. from 1.00 to 2.00 etc.. when there is a new sub-heading.
I accept that this might need another command to identify a sub heading so have suggested a "<" in column C, which i could manually insert?
also the auto numbering would ignore blanks & only insert 1.01, 1.02 etc.. when there is text in column D

 

[Joe4]

Place this formula in cell B3 and copy down for all your data rows:

=IF(D3="","",IF(D2<>"",B2+0.01,B1+1))

And be sure to format column B as a Number with 2 decimal places.

 

[Phuoc]

Try this:

Book1
	A	B	C	D
1
2
3		1	<	MAIN HEADING
4		1.01		Blah blah blah
5		1.02		Blah blah blah
6		1.03		Blah blah blah
7		1.04		Blah blah blah
8		1.05		Blah blah blah
9		1.06		Blah blah blah
10
11		2	<	Sub Heading
12		2.01		Blah blah blah
13		2.02		Blah blah blah
14		2.03		Blah blah blah
15		2.04		Blah blah blah
16		2.05		Blah blah blah
17		2.06		Blah blah blah
18
19		3	<	Sub Heading
20		3.01		Blah blah blah
21		3.02		Blah blah blah
22		3.03		Blah blah blah
23		3.04		Blah blah blah
24		3.05		Blah blah blah
25		3.06		Blah blah blah
Sheet1

Cell Formulas
Range	Formula
B3:B25	B3	=IF(D3="","",IF(C3<>"",COUNTIF($C$3:C3,"<>"),B2+0.01))

 

[Joe4]

Whoops, I had a small typo in my original formula.
Here is the updated version:

=IF(D3="","",IF(D2<>"",B2+0.01,INT(B1+1)))

 

[Snowmanx812]

Try this:

Book1
	A	B	C	D
1
2
3		1	<	MAIN HEADING
4		1.01		Blah blah blah
5		1.02		Blah blah blah
6		1.03		Blah blah blah
7		1.04		Blah blah blah
8		1.05		Blah blah blah
9		1.06		Blah blah blah
10
11		2	<	Sub Heading
12		2.01		Blah blah blah
13		2.02		Blah blah blah
14		2.03		Blah blah blah
15		2.04		Blah blah blah
16		2.05		Blah blah blah
17		2.06		Blah blah blah
18
19		3	<	Sub Heading
20		3.01		Blah blah blah
21		3.02		Blah blah blah
22		3.03		Blah blah blah
23		3.04		Blah blah blah
24		3.05		Blah blah blah
25		3.06		Blah blah blah
Sheet1

Cell Formulas
Range	Formula
B3:B25	B3	=IF(D3="","",IF(C3<>"",COUNTIF($C$3:C3,"<>"),B2+0.01))

Whoops, I had a small typo in my original formula.
Here is the updated version:

=IF(D3="","",IF(D2<>"",B2+0.01,INT(B1+1)))

View attachment 112909

Thanks Joe, you answered the question, but in some instances there are more than 1 blank, which the other members solution worked better, but appreciate your help

 

[Joe4]

Thanks Joe, you answered the question, but in some instances there are more than 1 blank, which the other members solution worked better, but appreciate your help

That's fine. I just went off the example you posted, in which there was only one blank line between sections.