I need code to add row numbers in a chart. Like, 1, 2, 3, etc. I've usedand that auto numbers the rows; however, it will not update the numbers if one row is deleted in the middle of the section. I've actually tried lots of things, but haven't come up with something that works when a row is deleted. Thanks.
Please Login or Register to view this content.
Hello, put number 1 in A1 and in A2 formula : ="OFFSET(A2;-1+1" and pull it down. no spaces OFFSET(A2;-1 ; )+1
Thank you for responding but please look at the code you gave me. I cannot decipher what you mean.doesn't work.Please Login or Register to view this content.
Yes, it would. If it's not happening for you, please upload an example.Originally Posted by dkitzerow
Also - you can just use this:
=ROW()
That will return the row number of the cell you typed the formula into (if that's what number you need). Also - you should definitely not resort to using OFFSET() or any volatile function for something as simple as this.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
I've uploaded. If you delete the row numbered 2, for example, the "new" row 2 remains numbered 3. Thank you.
Ok, now I see what you mean.
Try this: =ROW()-5
Where '5' is just an offset to get the numbering to start at 1.
OR: =COUNTA(E5:E$5)
SEE ATTACHED:
Many thanks! But why does my numbering start at 0 unless I add "+1?"
Because the cell, B13 is blank.
COUNTA() counts the non-blank cells for a given range. For my example in the E column, I started counting on the cell with the value "OR THIS:"
Make sense?
Yes!Thank you for your time and explanation! I'm not sure how to mark this post "resolved."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks