Hi,
I am trying to create increment numbers on my sheet and I was hoping to do it automatically. The thing is I cant just simply add 1 to the cell as there is a text value. Also, there are spaces in between, and the spaces varies from time to time.
So I was hoping for a formula where it can just detect the last row value and add one to that without leaving the text part.
In essence it goes like this, in cell A8
A3 JE 1 (starting point)
A4
A5
A6
A7 JE 2 (add one from previous known value)
A8
A9
A10 JE 3 (add one from previous known value)
I have attached the sheet as well. In my sheet the formula =Row does not work as there are spaces in between so it is not counting correctly. I hope someone could help me out. Thank you!
Bookmarks