Dear Folks
I have a problem in numbering. for ex say i have put number 1 to 10. if I
delete one number in betwen still last munber is 10. how i can define the
formula to get automaticaly 9 than 10

=row()
--
David Biddulph

"Fareez" wrote in message
...
Dear Folks
I have a problem in numbering. for ex say i have put number 1 to 10. if I
delete one number in betwen still last munber is 10. how i can define the
formula to get automaticaly 9 than 10

To serialize it downwards ...
Place in any starting cell,
say in B2: =ROWS($1:1)
Copy down as far as required to generate: 1,2,3,...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Fareez" wrote:
I have a problem in numbering. for ex say i have put number 1 to 10. if I
delete one number in betwen still last munber is 10. how i can define the
formula to get automaticaly 9 than 10

If I delete a row (or delete a cell and move up), that leaves a gap in the
number series.
--
David Biddulph

"Max" wrote in message
...
To serialize it downwards ...
Place in any starting cell,
say in B2: =ROWS($1:1)
Copy down as far as required to generate: 1,2,3,...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Fareez" wrote:
I have a problem in numbering. for ex say i have put number 1 to 10. if I
delete one number in betwen still last munber is 10. how i can define the
formula to get automaticaly 9 than 10

"David Biddulph" <groups [at] biddulph.org.uk wrote in
:

If I delete a row (or delete a cell and move up), that leaves a gap in
the number series.
--
David Biddulph


i guess in this case

=ROWS(A$1:A1)

would work better.
then fill down, and delete rows in the middle, and it will adjust

No, pub, it wouldn't.
If you delete a row in the middle (or delete a cell and move up), that
formula too will leave a gap.
--
David Biddulph

"pub" wrote in message
...

i guess in this case

=ROWS(A$1:A1)

would work better.
then fill down, and delete rows in the middle, and it will adjust

"David Biddulph" <groups [at] biddulph.org.uk wrote in
:

If I delete a row (or delete a cell and move up), that leaves a gap in
the number series.

"David Biddulph"
If I delete a row (or delete a cell and move up), that leaves a gap in
the number series.

Think the earlier suggestion should work ok, ie it'll auto-adjust for entire
row deletions, which was what I guess the OP is asking for. Other than that
scenario, for eg: delete a cell and move up (as you mentioned) I agree it
doesn't work.

I'm not sure why you say it doesn't work for entire row deletions
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---