Consequential numbers
 

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?
------------------------:)


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=510712

Consequential numbers
 

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

Consequential numbers
 

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

Consequential numbers
 

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


--
Boethius1


------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=510712