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
|