Incrementing cell values by a formula and not a system column
I thought this would be relatively straightforward. I am looking for a formula that will increase the previous cell value by one when the cell contains a letter followed by the numbers i.e P1159 next row P1160 next row P1161 etc. Every time we create a new row the column formula will increase the previous row by 1.
I cant use a system column because i move the row to another sheet with a different autonumber sequence it still keeps its number from its original sheet and we need to number the same as the rows in this new sheet ?
Hope that make sense ?
Help Article Resources
Check out the Formula Handbook template!