u/AuthorPractical2102

Hi community
I‘m learning about Array formulas and I understand the theory, they seem useful but I cannot imagine practical application in my work life. I work with FC, Budget and Reporting and some times Financial modelling around the budget phase and for this I use excel, power query and power bi.

Did you work with them in These areas? Or do you have other examples where you found such formulas useful?