serial numbers
 

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

serial numbers
 

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

serial numbers
 

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

serial numbers
 

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 -

serial numbers
 

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 -

serial numbers
 

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

serial numbers
 

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

serial numbers
 

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