Serial Number

  • Thread starter Thread starter Fareez
  • Start date Start date
F

Fareez

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
 
If I delete a row (or delete a cell and move up), that leaves a gap in
the number series.
Click to expand...

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"
If I delete a row (or delete a cell and move up), that leaves a gap in
the number series.
Click to expand...

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
---
 
It's interesting that it behaves differently depending on the starting
point...
Click to expand...

In the context of my response to the OP, any entire row deletion(s) within
the formulated range, ie within B2:Bx itself will not disrupt the numbering.
It'll auto-adjust.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
 
Back
Top