Table of Contents
The purpose of using the SEQUENCE function in Google Sheets is to automatically generate a sequence of numbers or dates based on a specified range and step value. This function is useful for creating organized lists, tracking progress, and performing numerical operations in a structured manner. It eliminates the need for manual input and saves time and effort in data management. Additionally, SEQUENCE allows for easy customization by allowing users to specify the starting number and direction of the sequence.
Google Sheets: Use SEQUENCE Function
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 .
Additional Resources
The following tutorials explain how to use other common functions in Google Sheets: