Formula to autonumber cells

  • Thread starter Thread starter mense23
  • Start date Start date
M

mense23

I am creating a spreadsheet for someone to make estimates with.
On the left hand side I want to automatically adjust the line #'s when
the user inserts and deletes lines. ie if I had lines 1,2,3,4
and then inserted a line between 2 & 3. I want to have 1,2,3,4,5 not
1,2,3,3,4.
 
Hi
in A1 enter the following formula
=IF(B1<>"",1,"")
in A2 enter
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")

and copy down
 
Back
Top