SEQUENCEfunction 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
- Examples of using
SEQUENCEformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
SEQUENCEformula 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.
SEQUENCEnot working? Here are some common mistakes people make when using the
SEQUENCEGoogle 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 non-numeric values for arguments where numeric values are expected.
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.
The following functions are similar to
SEQUENCE or are often used with it in a formula:
ROWformula 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.
COLUMNformula 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.
INDEXformula 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.
ARRAYFORMULAformula 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.
TRANSPOSEformula 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.
You can learn more about the
SEQUENCE Google Sheets function on Google Support.