Auto-number down a column

  • Thread starter Thread starter Cassie
  • Start date Start date
C

Cassie

Is there a way to create an autonumber (e.g. 1, 2, 3, 4...
in a column) where when a row or more is deleted, the
numbering recalculates so that no numbers are missing from
the sequence?

If I do it with a formula (e.g. A2 = A1 + 1, A3 = A2 + 1),
then it cannot recalculate the formulas when a row is
deleted since it uses row references.

If I do it by doing an auto fill so there is just the
number values 1, 2, 3... in each cell down the column, it
will not autonumber after a row is deleted. You need to
select the first couple of cells again and re-fill the
columns. While I am happy to do it this way, I was hoping
there was a way that the spreadsheet would automatically
re-number for me.

Thanks
Cassie
 
Hi Cassie

you can do it using the ROW() function

in cell A1 type = ROW()
and fill down

Cheers
JulieD
 
Cassie

You could try using
=ROW()

And if you want to start with a 1 on row 2, just use =ROW()-1

Andy.
 
Hi
try the following
in A1 enter
=IF(B1<>"",1,"")
in A2 enter
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
and copy down

Besides the deletion of row 1 you can easily delete all other rows
 
Back
Top