Numbering - Brain Block Moment

[DJFANDANGO]

Hi Guys,

I have a column of names, and they are numbered 1 through 140 for example, when I delete, or should I say remove or add a name row from the list, I have to redo the 'numbering' again... Probably simple to figure out but my brain is mush just now.

Example, I remove Row number 4, then what was number 5 becomes number 4, the name in column B doesn't change though... Make sense?
Equally if I insert a row, lets say in row 3, then the row below is automatically numbered 4 etc...

So basically I would like column A to auto number...

Thanks in advance!

GASafetyObservation637483124972966672.xls
	A	B
1	Number	Name
2	1	Mike
3	2	John
4	3	Steve
5	4	Susan
6	5	Debbie
7	6	Nicola
8	7	Janet
9	8	David
10	9	Paul
11	10	Tracey
Sheet1

 

[MARK858]

Book1
	A	B
1	Number	Name
2	1	Mike
3	2	John
4	3	Steve
5	4	Susan
6	5	Debbie
7	6	Nicola
8	7	Janet
9	8	David
10	9	Paul
11	10	Tracey
Sheet2

Cell Formulas
Range	Formula
A2:A11	A2	=ROWS($A$1:$A1)

 

[DJFANDANGO]

Book1
	A	B
1	Number	Name
2	1	Mike
3	2	John
4	3	Steve
5	4	Susan
6	5	Debbie
7	6	Nicola
8	7	Janet
9	8	David
10	9	Paul
11	10	Tracey
Sheet2

Cell Formulas
Range	Formula
A2:A11	A2	=ROWS($A$1:$A1)

YEP!!! That's the ticket!

Thank you so much Mark858, I think I should have a lie down! hahaha

 

[DJFANDANGO]

Hi Mark858,

Actually... just in testing it works great for removing rows, but when I insert a row, the formula is not inserted... which in turn breaks the formula... any ideas?

Thanks...

 

[MARK858]

Drag the formula down or convert it to a table

 

[DJFANDANGO]

Hi Mark858,

Yes, that's the only way for it to do it automatically, my problem is I cant convert the data set into a table... boo hoo, thanks again.