"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