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! 🙂
=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.