This is the second in a series on dynamic array formulas and spill ranges. In this video, we'll create a dynamic amortization schedule ... and it is actually pretty fun!
Written tutorial and sample file here:
[ Ссылка ]
Before we had spill ranges, it was a hassle to update an amortization schedule when the number of periods changed. That is, you may want to see it for a loan with 360 months, and then update it for a loan with 180 months, and so on. As the number of periods change, so does the number of lines we want displayed. So, we'd have to fiddle with the formula rows or use some clever technique like conditional formatting or dynamic print ranges. But, now we can use dynamic array formulas and spill ranges.
