Formulas > =SEQUENCE()
How To Use SEQUENCE() Function in Google Sheets
Description
How To Actually Use SEQUENCE() in Sheets
SEQUENCE(rows, columns, start, step)
Try SEQUENCE yourself
In cells A1:A10, use the SEQUENCE formula to generate a list of numbers from 1 to 10. The correct answer must display the numbers vertically in the specified range.
Hints (3)
-
Think about how many rows you need for the numbers.
-
You can start the sequence at 1.
-
The step value can be set to 1 to get consecutive numbers.
2 Better Sheets Tutorials
Magical Numbering
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)
COUNTA()
SEQUENCE()
Recreate a Starbucks Order Status Sign
Create a status flow chart, like a kanban board but for displaying coffee orders.
COUNTA()
FILTER()
IF()
ISBLANK()
SEQUENCE()
Learn more about the SEQUENCE() formula:
Generate a SEQUENCE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SEQUENCE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SEQUENCE() formula