Sequence Function

by Matt Mickle on September 28, 2022
The sequence function and how it can be used


The Sequence Function generates an array of numbers based on the input from the user.  The array can be one or two dimensional based on the inputs.  The start argument determines the beginning of the sequence, and the step argument determines the increment in which the numbers will be filled.



=Sequence( Rows, Columns, Start, Step )


Rows: number of rows

Columns: [optional] number of columns

Start: [optional] starting value

Step: [optional] increment between each value


In practice the function can be used as follows (4 rows and 4 columns incremented by 50 starting at 0):



Here is another practical example using dates:


Recent Posts