Automatic Numbering in Excel

[suet]

Hi I need some help with automatic sequential numbering in excel.

So as I add rows I want to increase the row number. But if I delete a row then I need to the following rows to auto adjust.

I am unable to work out how to do automatic numbering in excel like you get in Word.

I have attached a sample spreadsheet to clarify what I am trying to achieve.

As you can see when I delete rows the number in the following rows doesn't not update to reflect the change.

Any help and guidance greatly appreciated. Thanking you in advance.

 

[Peter_SSs]

Try this, copied down as far as you might ever need.

21 10 19.xlsm
	A	B
1	1.	text
2	2.	text
3	3.	text
4
5
6	4.	text
7	5.	text
8
9	6.	text
10
11
Auto Number

Cell Formulas
Range	Formula
A1:A11	A1	=IF(B1="","",COUNTA(B$1:B1)&".")

 

[Peter_SSs]

@suet
I removed your last post since all it did was quote my previous post, with no additional comments or questions.
Did that formula do what you wanted?

 

[suet]

Try this, copied down as far as you might ever need.

21 10 19.xlsm
	A	B
1	1.	text
2	2.	text
3	3.	text
4
5
6	4.	text
7	5.	text
8
9	6.	text
10
11
Auto Number

Cell Formulas
Range	Formula
A1:A11	A1	=IF(B1="","",COUNTA(B$1:B1)&".")

Hi Peter

That worked a treat!!! Thank you so so very much.

Have a great day and thanks once again.

Regards
Sue

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.