Autonumber in Microsof Excel (works after inserting rows)

If you want the autonumber to work even after you insert a row in Excel, use the following formula.

=CELL(”contents”, INDIRECT(CONCATENATE(”B”, ROW()-1)))+1

I am assuming the list of values are in B column.

A simple formula =”aboverow”+1 does not work if you insert a new row which falls in the value range.

If you have a better way of doing this please let me know

This entry was posted on 31 Oct 2008 at 11:39 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.