Consequential numbers

B

Boethius1

I have formulated A2 so i get consequential numbers down column A,
however if i insert a new row, the sequence is lost. Is there a way to
stop this happening?
------------------------:)
 
V

vezerid

Your best choice is to use the following formula in A2)

=OFFSET(A2, -1, 0)+1

When you insert a new row, temporarily you will get strange results,
but as soon as you copy the formula to the new cells the order will be
restored automatically..

HTH
Kostis Vezerides
 
P

Pete

An alternative is to use:

=ROW( )

This will always tell you which row you are on, even if you insert or
delete rows. However, any formula will have to be copied to a new row
if you insert one.

Hope this helps.

Pete
 
B

Boethius1

Thanks for the suggestion but i really wanted something that meant i
dont have to keep copying the formula in.
----------------------------------------:)
 
Top