Using Array Lambda Formula C(olumns) and R(ows) times in excel formula
After resolving the https://techcommunity.microsoft.com/t5/excel/using-array-formula-c-olumns-and-r-ows-times-in-excel-formula/m-p/4125426
Thanks @Hans Vogelaar and @Peter Bartholomew
I’m looking to expand a lambda formula that can accommodate building scenarios over a span of 5 years (columns) and 8 cases (rows).
I can effectively handle the setup for one row and generate the outcomes across various years.
I can then drag the formula down to address the rest of the cases.
However, the cases might change dynamically, and I need an adaptable and general solution.
Can anyone provide some guidance on this?
I’ve attached a spreadsheet where I try to explain the concept in more detail.
After resolving the https://techcommunity.microsoft.com/t5/excel/using-array-formula-c-olumns-and-r-ows-times-in-excel-formula/m-p/4125426 Thanks @Hans Vogelaar and @Peter Bartholomew I’m looking to expand a lambda formula that can accommodate building scenarios over a span of 5 years (columns) and 8 cases (rows). I can effectively handle the setup for one row and generate the outcomes across various years.I can then drag the formula down to address the rest of the cases. However, the cases might change dynamically, and I need an adaptable and general solution.Can anyone provide some guidance on this? I’ve attached a spreadsheet where I try to explain the concept in more detail. Read More