Excel Column Renumbering Question

C

clacount

If I put numbers in Column A (1, 2, 3 etc.) and then I will have to remove
various rows from Column A (#10, #15, #34, #45 etc.) can I get Column A to
automatically renumber in sequence after I remove variuos rows?
 
J

Jim Thomlinson

You can use the Row() function to deteremine the row that the formula is in.
Using an offset such as
=row() + 3
will allow you to get the numbering you want. Note however that row() is a
volatile function and if you have thoushads of these functions you could
adversely affect performance.
 
Top