Repeating Numbers
Key points
- Choose REPEAT
- Enter the cycle length
- Copy it
In SEQUENCE Builder you can build numbers that repeat like 1, 2, 3, 1, 2, 3.
Steps
- Choose REPEAT
- Enter the cycle length
- Copy it
It is handy for seat orders and grouping.
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.