From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Using SEQUENCE for dynamic ranges

Using SEQUENCE for dynamic ranges - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

Using SEQUENCE for dynamic ranges

“

- [Instructor] Let's talk about the first dynamic array function, SEQUENCE. What SEQUENCE allows us to do is to generate a list of sequential numbers in an array, such as one, two, three, four. And you might say, "Well, so what? What can we do beyond that?" Well, let's take a look. =SEQUENCE, Rows, Columns, Start, Step. Okay, so let's go through each one of these elements. Rows, rows is the number of rows that you want to return. Columns, the number of columns that you want to return. Start is the first number that you want in this sequence. And then, Step is the incremental increase or decrease that you want to climb or go down from the start. So if I had one for my rows, I would have just one row. If I had five for columns, I would have five columns. All of this would automatically spill. If I start at one and my step is one, it goes one, two, three, four, five. If I were to start at two, it would start two, three, four,…

Contents