serial numbers

[Naveed]

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

 

[Stefi]

Use =ROW() function instead of constant numbers!

Regards,
Stefi

„Naveed†ezt írta:

 

[Khoshravan]

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

 

[Pete_UK]

Or you could use:

=ROW(A1)

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

Hope this helps.

Pete

 

[Khoshravan]

Nice solutions

 

[Ashish Mathur]

Hi,

You can try this as well.

1. Enter 1 in the first cell, say E6;
2. In cell E6, enter MAX($E$6:E6)+1 and copy down

Now if you delete any row, the serial number will automatically update. This
would be marginally more efficient than the ROW() function because MAX() is
a non volatile function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Rasoul Khoshravan]

A minor correction is necessary in your function. The next formula
should be entered in cell E7 not E6. A clever and nice solution.