Hopefully very easy question re numbering rows, starting at 1, but on different rows than 1/top

[Jennifre]

I want to number rows of data, where the data row 1 does not start at the top cell. I added rows over row 1, and deleted other rows, so I need to re-do this.

I need to be able to restart row numbering at 1 from, say row 5, and drag down over a column section, to then show rows 1 2 3 4 5 etc. Is that possible?

(And NOT tied to the row numbers of the Excel doc)?

Thank you!

 

[JoeMo]

Copy the formula in A5 down further than you expect your data to extend.

Excel Workbook
	A	B
5	1	Data1
6	2	Data2
7	3	Data3
8	4	Data4
9	5	Data5
10	6	Data6
11	7	Data7
12	8	Data8
13	9	Data9
14	10	Data10
15	11	Data11
Sheet21

 

[Jennifre]

Thanks, though I'm not sure I was clear.

I do not need to drag the numbering down further for more data to be numbered by row.

The data I need to be numbered does not start on Row 1 of the Excel doc. So, I need to know the formula to sequentially number rows starting with 1, even when the data starts on say row 5.

Is there a formula to sequentially number rows, and to tell it to start at 1 in its numbering?

Thanks so much.

 

[markmzz]

Another way:

Formula:

A5-> =ROWS(A$5:A5)

Layout:

	A	B
1
2
3
4	Row #	Value
5	1	312
6	2	232
7	3	202
8	4	483
9	5	281
10	6	269
11	7	107
12	8	249
13	9	434
14	10	208
15	11	128
16	12	187
17	13	451
18	14	235
****	******	*****

<tbody>
</tbody>

By the way, JoeMo's formula work here.

Markmzz

 

[JoeMo]

Thanks, though I'm not sure I was clear.

I do not need to drag the numbering down further for more data to be numbered by row.

The data I need to be numbered does not start on Row 1 of the Excel doc. So, I need to know the formula to sequentially number rows starting with 1, even when the data starts on say row 5.

Is there a formula to sequentially number rows, and to tell it to start at 1 in its numbering?

Thanks so much.

That's what the formula I posted does. If you want an alternative, put a 1 in the first row you want to begin numbering (say A5 for example) and in A6:
=A5+1
and so on.