For #ICAEW members, my tips on the tricks needed to get some #Excel functions to handle arrays and ranges and return arrays, is live on the #ICAEW_Excel page. Requires member login.
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/excel-tips-and-tricks-467

Excel Tips & Tricks #467 - Excel functions that are harder to get to return arrays or ranges
Such as AND, OR, and date functions like EOMONTH.

#msexcel #functions #tips #tricks #workarounds #dynamic #arrays