It's not as poweful as SQL, but the new array functions bring some fresh air https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-exc

It's not as poweful as SQL, but the new array functions bring some fresh air https://blog-insider.office.com/2019/06/13/dynamic-arrays-and-new-functions-in-excel/ https://blog-insider.office.com/2019/06/13/dynamic-arrays-an...