Excel SEQUENCE Function
Summary
The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional. Start and step values are arguments.
Purpose
Get array of list of seuential numbers
Return value
Array of sequential values
Syntax
=SEQUENCE (rows, [columns], [start], [step])
Arguments
- rows - Number of rows to return.
- columns - [optional] Number of columns to return.
- start - [optional] Starting value (defaults to 1).
- step - [optional] Increment between each value (defaults to 1).
Version
Usage notes
The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, controlled by rows and columns arguments. Start and step (increment) values are also supplied as arguments. In the example shown, the formula in B4 is:
=SEQUENCE(10,5,0,3)
With this configuration, SEQUENCE returns an array of sequential numbers, 10 rows by 5 columns, starting at zero and incremented by 3. The result is 50 numbers starting at 0 and ending at 147, as shown in the screen.
To return 10 numbers in one column, starting at -5 and ending at 5, incremented by 1:
=SEQUENCE(10,1,-5,1)
SEQUENCE is a new function available in Excel 365 only.
SEQUENCE formula examples
The new dynamic array formulas in Excel 365 make it much easier to solve certain tricky problems with formulas.
In this example, the goal is to generate a list of random 6-character codes. The randomness is handled by...
Excel doesn't have a way to cast the letters in a text string to an array directly in a formula. As a workaround, this formula uses the MID function, with help from the ROW and INDIRECT functions to achieve the same...
The SEQUENCE function is a dynamic array function that can generate multiple results. When used by itself on the worksheet, SEQUENCE outputs an array of results that "spill" onto the worksheet in a "spill range".
In...
The FILTER function, new in Excel 365, is can help simplify some some tricky formula problems.
In this example, the goal is to sum the first 3 scores for both Jake and Hailey, based on the order they appear in the...
The FILTER function is designed to filter and extract information based on logical criteria. In this example, the goal is to extract every 3rd record from the data shown, but there no row number information in the data...
The EDATE function moves forward or backwards in time in one-month increments from a given start date. The SEQUENCE function is a dynamic array function that can generate multiple results that "spill" onto the...
At the core, this formula uses the WEEKDAY function to test a number of dates to see if they land on a given day of week (dow) and the SUMPRODUCT function to tally up the total.
When given a date, WEEKDAY simply...
At the core, this formula uses the INDEX function to retrieve 10 random names from a named range called "names" which contains 100 names. For example, to retrieve the fifth name from the list, we use INDEX like this...
The SEQUENCE function is a dynamic array function that can generate multiple results. Like other dynamic array functions, SEQUENCE outputs an array of results that "spill" onto the worksheet in a "spill range"....
The SEQUENCE function is a dynamic array function that can generate multiple results. When used by itself on the worksheet, SEQUENCE outputs an array of results that "spill" onto the worksheet in a "spill range"....
Working from the inside out, we use the SEQUENCE function to construct a row number value for INDEX like this:
SEQUENCE(3,1,1,1)
We are asking SEQUENCE for an array of 3 rows x 1 column, starting at 1, with a step...
At the core, this formula uses the MID function to extract each character of a text string in reverse order. The starting character is given as a list of numbers in descending order hardcoded as array constant:
MID(B5...
Related videos
With the introduction of dynamic array formulas, Excel includes 6 brand new functions that directly leverage dynamic array behavior. In this video, we quickly demo all 6.
In this video, we'll look at how to generate a sequence of times with the SEQUENCE function.
In this video, we'll look at how to generate a sequence of dates with the SEQUENCE function.
In this video, we'll introduce the SEQUENCE function. The SEQUENCE function lets you generate numeric sequences, which can be used for dates, times, and more.
Related functions
See also
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
