Ask Your Question

Show index number next to each nonempty row

asked 2017-12-07 13:41:52 +0200

MuhammadOsta gravatar image

Hello there,

Would you please help me on this, I want to know how to show number next to each row of data as in: data in column B start at row 6 and goes on to about 100, I want to show the numbering in column A example: A B

1 data

2 data

3 data





I know how make the number manually from first cell and drag till last one, but I want this to be automatic numbering so any time I enter a new data in column B, an index number will show in column A.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-12-07 21:45:43 +0200

librebel gravatar image

Hello @MuhammadOsta,

Please try with the following formula in your cell A6 to A100:

NB. The formula should be Exactly the same in each cell, so you better Copy-Paste it 94 times down from cell A6 until cell A100, instead of dragging the handle. ( Else the reference to B6 will be altered with each row, instead of staying fixed at “B6” for all rows. )


HTH, lib

image description

edit flag offensive delete link more


worked perfectly! thank you so much!dank u wel :) (I couldn't upvote your answer, I must have more points to be able to do that)

MuhammadOsta gravatar imageMuhammadOsta ( 2017-12-08 09:04:09 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-07 13:41:52 +0200

Seen: 30 times

Last updated: Dec 07 '17