Ask Your Question
1

Show index number next to each nonempty row [closed]

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

.

.

.

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by MuhammadOsta
close date 2020-07-14 13:46:46.286873

1 Answer

Sort by » oldest newest most voted
2

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

=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 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 113 times

Last updated: Dec 07 '17