From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Designing a layout to incorporate spill ranges

Designing a layout to incorporate spill ranges - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Designing a layout to incorporate spill ranges

“

- [Instructor] You've probably noticed by now that a dynamic array needs to have a lot of space around it. In an example like this, if you try to add something in the middle of the range, you will end up with a spill error. And this means that you have to be very careful with adding anything below or to the right of a dynamic range. And as with any calculations, you need to be careful about adding extra rows into the schedule. If you were to add something here, you can see that that would not be included in the calculations. If you wanted to include an extra row, you would have to add it in the middle of the range like that. This is exactly the same previously, whether you are using dynamic arrays or not. Now, because we've designed this schedule to expand across, we also need to be really careful about what we add to the right. In the previous chapter, we had built this BYCOL function, which will add a dynamic total. We can do exactly the same thing to the right, except this time…

Contents