ExcelBanter - Renumbering a list of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Renumbering a list of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/77830-renumbering-list-numbers.html)

Dr.Alvixagon

Renumbering a list of numbers

How do I make a list of numbers re-number itself, continue the sequence,
after deleting rows?

Sloth

Renumbering a list of numbers

Make the list numbers dependant on the row using the ROW() function.

Example: If you want the numbers to start on row 2, then use this formula
and copy down.

=ROW()-1

"Dr.Alvixagon" wrote:

How do I make a list of numbers re-number itself, continue the sequence,
after deleting rows?

All times are GMT +1. The time now is 12:37 AM.