Sequence Function

Description:

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.

Syntax:

=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: