Tip #048 – Excel

Excel: Dynamic Row Numbering

Scenario: You have a list (employees, items, whatever) of records that you would like to number (1, 2, 3….). HOWEVER, you want to ensure that if you insert or delete a row within the body of the list…the numbers automatically compensate.

 

Full tip: Excel tip