The new Let() function gives you multi row formulas, with local variables. https://insider.office.com/en-us/blog/let-names-in-formulas-for-excel https://inside

The new Let() function gives you multi row formulas, with local variables. https://insider.office.com/en-us/blog/let-names-in-formulas-for-excel https://insider.office.com/en-us/blog/let-names-in-formulas-... And it's a hack, but you can put text comments inside an N() function and add them into your formulas. https://support.microsoft.com/en-us/office/n-function-a624cad1-3635-4208-b54a-29733d1278c9 https://support.microsoft.com/en-us/office/n-function-a624ca...