Nice solutions
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Pete_UK" wrote:

Or you could use:

=ROW(A1)

on the first row (row 12), and then copy it down.

Hope this helps.

Pete

On Feb 5, 3:32 pm, Khoshravan
wrote:
Nice solutions. To complete Stefi's solution, if you start from let say B13,
in order to get numbers starting from one, you have to use:
Row()-12
--
R. Khoshravan
Please click "Yes" if it is helpful.



"Stefi" wrote:
Use =ROW() function instead of constant numbers!

Regards,
Stefi

€žNaveed€� ezt Ã*rta:

Hi,
When we put serial numbers in Excel sheet for example top to down 1 to
100 and we delete a row for example 30th so is this possible that serial
number can auto update and that sheet shows 1 to 99 nothing missing in-between

Looking for your resp.
BR
Naveed- Hide quoted text -

- Show quoted text -