[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:

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

[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
--
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

[Pete_UK]

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 -

[Khoshravan]

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 -

[Ashish Mathur[_2_]]

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

"Naveed" wrote in message
...
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

[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.

On Feb 6, 7:00*am, "Ashish Mathur" wrote:
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 MVPwww.ashishmathur.com

"Naveed" wrote in message

...

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

[Chris Bode via OfficeKB.com]

Please follow following steps
1.Enter values 1 in first cell (say C1) and 2 to the second cell (say C2)
2.Now select cell C3 and enter following formula
=MAX($C$1:C2)+1
3.Now drag the cell C3 below to apply it to other cells as well

Hope you get it

Have a nice time€¦.


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200902/1