Hello,
I got the following very useful post from this forum:
very nice, I would modify the formula to allow for easier
insertion / deletion of rows by using offset, makes maintenance
a lot easier.
for cell A2: -- then fill down
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
....David McRitchie in 2004
This works well. I would like to take it a step further though and have the numbering start over at 1 when the contents of the B column changes.
I got the following very useful post from this forum:
very nice, I would modify the formula to allow for easier
insertion / deletion of rows by using offset, makes maintenance
a lot easier.
for cell A2: -- then fill down
=IF(B2<>"",MAX($A$1:OFFSET($A2,-1,0))+1,"")
....David McRitchie in 2004
This works well. I would like to take it a step further though and have the numbering start over at 1 when the contents of the B column changes.