Hello,
I have an excel database where I have 1 column for a UID no which is pretty much a serial number.
I need a formula where the number would auto generate based on the number in the last row +1.
Currently have the formula set where the value of the first row is set at 1 and second row is a1+1 and so on.
However, when I delete a record or add to the database this goes haywire and i have to fix the formulas.
Any work around this?
I have an excel database where I have 1 column for a UID no which is pretty much a serial number.
I need a formula where the number would auto generate based on the number in the last row +1.
Currently have the formula set where the value of the first row is set at 1 and second row is a1+1 and so on.
However, when I delete a record or add to the database this goes haywire and i have to fix the formulas.
Any work around this?