You can use the SEQUENCE function in Google Sheets to return an array of sequential numbers.
This function uses the following basic syntax:
SEQUENCE(rows, columns, start, step)
where:
- rows: The number of rows to return
- columns: The number of columns to return (default is 1)
- start: The number to start the sequence at (default is 1)
- step: The amount to increase or decrease each number in the sequence (default is 1)
The following examples show to use this function in different scenarios in Google Sheets.
Example 1: Create Sequence of Values in One Column
We can use the following formula to create a sequence of values in one column:
SEQUENCE(10)
The following screenshot shows how to use this formula in practice:
The result is a single column that contains the sequential values 1 through 10.
Example 2: Create Sequence of Values in One Row
We can use the following formula to create a sequence of values in one row:
SEQUENCE(1, 5)
The following screenshot shows how to use this formula in practice:
The result is a single row that contains the sequential values 1 through 5.
Example 3: Create Matrix of Sequential Values
We can use the following formula to create a matrix of values with 10 rows, 3 columns, starts at 0, and increases each value by 5:
SEQUENCE(10, 3, 0, 5)
The following screenshot shows how to use this formula in practice:
The result is a matrix with 10 rows, 3 columns, starts at 0, and increases each value by 5.
Note: You can find the complete documentation for the SEQUENCE function in Google Sheets here.
Additional Resources
The following tutorials explain how to use other common functions in Google Sheets:
How to Use AVERAGEIFS Function in Google Sheets
How to Use ISERROR Function in Google Sheets
How to Ignore #N/A Values with Formulas in Google Sheets
