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:

[TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl66, width: 27, bgcolor: #D9D9D9"][/TD]
[TD="class: xl67, width: 37, bgcolor: #D9D9D9"]A
[/TD]
[TD="class: xl67, width: 34, bgcolor: #D9D9D9"]B
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]1
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]2
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]3
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]4
[/TD]
[TD="class: xl64, bgcolor: transparent"]Row #
[/TD]
[TD="class: xl64, bgcolor: transparent"]Value
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]5
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]312
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]6
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]232
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]7
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]202
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]8
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]483
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]9
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]281
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]10
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]269
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]11
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]107
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]12
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]249
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]13
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]434
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]14
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]208
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]15
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]128
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]16
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]12
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]187
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]17
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]13
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]451
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]18
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]235
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]****
[/TD]
[TD="class: xl64, bgcolor: transparent"]******
[/TD]
[TD="class: xl64, bgcolor: transparent"]*****
[/TD]
[/TR]
</tbody>[/TABLE]


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.