View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default 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