SEQUENCE Function Explained
The SEQUENCE function in Microsoft Excel generates a list of sequential numbers in an array, based on the given parameters. It takes three arguments: start_num, step, and stop_num. start_num is the first number in the sequence, step is the difference between each number in the sequence, and stop_num is the last number in the sequence. The SEQUENCE function is useful for creating a list of numbers for use in calculations or for creating a chart.
SEQUENCE Function Syntax
SEQUENCE(rows, [columns], [start], [step])
- rows: The number of rows in the sequence.
- columns: (Optional) The number of columns in the sequence. If omitted, the default value is 1.
- start: (Optional) The starting value of the sequence. If omitted, the default value is 1.
- step: (Optional) The difference between each number in the sequence. If omitted, the default value is 1.