Table of Contents
The SEQUENCE function in Google Sheets is a useful tool for creating sequences of numbers, dates, or text strings. It can be used to generate a range of numbers, dates, or strings, and can also be used to increment a number or date. It takes two arguments: the start and the end of the sequence, and it can be used to fill a range of cells with a certain number of items. It can also be used to create a series of dates in a given range.
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:
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 .
The following tutorials explain how to use other common functions in Google Sheets: