SEQUENCE

SEQUENCE Function Explained

SEQUENCE function creates an array of sequential values.

It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user to type a formula in a single cell, and receive a result in a whole range.

It is important to note that as of December 2019, this function is available only for Office 365 and Excel Online Users. Excel-Practice-Online.com enables you to practice those formulas regardless of which desktop version you have! 🙂

Example

Syntax

=SEQUENCE(rows, [columns], [start], [step])

rows – How many rows will be in the range

[columns] – How many columns will be in the range. This argument is optional. If left empty – only one column will be created.

[start] – What value will be the starting value of the range. This argument is optional. If left empty – the starting number will be 1.

[step] – What is the increment between each step. This argument is optional. If left empty – the step is 1.

 

Practice SEQUENCE function online