SEQUENCE
TheSEQUENCE
function generates a sequence of numbers in an array. It is most commonly used to create a matrix of sequential numbers with a defined number of rows and columns. The sequence starts at a specified number and increments by a specified step size.
 How to use
SEQUENCE
formula?  Examples of using
SEQUENCE
formula SEQUENCE
formula not working? Similar formulas to
SEQUENCE
Usage
Use the SEQUENCE
formula with the syntax shown below, it has 2 required parameters and 2 optional parameters:
 rows (required):
The number of rows in the output array. Must be a positive integer or a reference to a cell containing a positive integer.  columns (required):
The number of columns in the output array. Must be a positive integer or a reference to a cell containing a positive integer.  start (optional):
The starting value of the sequence. If omitted, defaults to 1. Can be any number or a reference to a cell containing a number.  step (optional):
The step size between each number in the sequence. If omitted, defaults to 1. Can be any number or a reference to a cell containing a number.
Examples
Here are a few example use cases that explain how to use theSEQUENCE
formula in Google Sheets.
Generate a matrix of sequential numbers
To generate a matrix of sequential numbers, use the SEQUENCE
function with the desired number of rows and columns, and specify the starting value and step size if necessary. For example, =SEQUENCE(3, 3, 1, 1)
will return a 3x3 matrix of sequential numbers starting at 1 and incrementing by 1.
Create a custom sequence of numbers
To create a custom sequence of numbers, use the SEQUENCE
function with the desired number of rows and columns, and specify the starting value and step size. For example, =SEQUENCE(5, 1, 0, 0.5)
will return a column of 5 numbers starting at 0 and incrementing by 0.5.
Create a range of dates
To create a range of dates, use the SEQUENCE
function with the desired number of rows and columns, and specify the starting date and step size. For example, =SEQUENCE(7, 1, DATE(2022, 1, 1), 1)
will return a column of 7 dates starting at January 1st, 2022 and incrementing by 1 day.
Common Mistakes
SEQUENCE
not working? Here are some common mistakes people make when using the SEQUENCE
Google Sheets Formula:
Incorrect number of arguments
Users may forget to include all required arguments or include too many arguments.
Invalid data type
Users may provide nonnumeric values for arguments where numeric values are expected.
Invalid range
Users may provide a range that exceeds the available space in the sheet, causing errors or unexpected results.
Incorrect starting value
Users may provide a starting value that is not compatible with the step value, causing unexpected results.
Incorrect step value
Users may provide a step value that does not result in the desired sequence or causes errors.
Related Formulas
The following functions are similar to SEQUENCE
or are often used with it in a formula:

ROW
The
ROW
formula returns the row number of a specified cell reference. If no cell reference is provided, it returns the row number of the cell in which the formula is entered. This formula is most commonly used for data analysis and manipulation. 
COLUMN
The
COLUMN
formula returns the column number of a given cell reference. It is most commonly used as a helper function for other formulas that require the column number as an argument. 
INDEX
The
INDEX
formula in Google Sheets is used to return a value or reference of a cell at the intersection of a specified row and column in a given range. The formula is commonly used to lookup and retrieve values from a table or range of cells. 
ARRAYFORMULA
The
ARRAYFORMULA
formula in Google Sheets allows for the application of a formula to an entire column or range of data, without needing to manually copy the formula to each cell. It is most commonly used to simplify and automate complex calculations across large data sets. 
TRANSPOSE
The
TRANSPOSE
formula in Google Sheets allows you to flip a table of data by turning rows into columns and columns into rows. This can be useful for reorganizing data or preparing it for use in other formulas.
Learn More
You can learn more about the SEQUENCE
Google Sheets function on Google Support.