Forum Discussion
If you thought Spills killed CSE, read this post
I build financial models. All financial models I have ever seen do the same thing - they show one reporting date per column. Every next reporting period evolves from the previous financial close. ...
I'm interested in seeing an anonymized sample workbook with this calculation crunch. There's not a lot of official documentation concerning dynamic arrays and Lambda in regards to performance and optimization.
I'm attaching a workbook that was referenced in an older discussion that may have been overlooked by many. It's worth checking out because the workbook contains a reproduceable anomaly in the way the screen updates to fill out the spill. I'm curious if your example is anything like this.
Puzzling performance issues with LAMBDA array formulas | Microsoft Community Hub