Ask Your Question
1

Show index number next to each nonempty row

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

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

.

.

.

etc

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
1

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

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. )

=IF(ISBLANK(INDIRECT("B" & ROW()));""; ROW() - 5 - COUNTBLANK(B6:INDIRECT("B" & ROW())))

HTH, lib


image description

edit flag offensive delete link more

Comments

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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 14 times

Last updated: Dec 07