Numbering From Row Numbers
Key points
- Choose ROWNUM
- Enter the header row
- Copy it
In SEQUENCE Builder you can build a formula whose numbers renumber when rows are added or removed.
Steps
- Choose ROWNUM
- Enter the header row
- Copy it
Enter the number of the header row.
Use "Build a SEQUENCE Formula" (free)
Tools that go well with this
- Build a Date Offset Formula: Build date offset formulas.
- Build an ARRAYFORMULA: Build ARRAYFORMULA formulas.
- Build a Rank Formula: Build rank formulas.