Dave BURNS from Exceljet has done an excellent work to solve hard problems in Excel older versions - WITHOUT the 6 Main Dynamic Array Functions !!!
Alternatives to Dynamic Array Functions
Dynamic Excel offers 6 brand new functions that solve hard problems in Excel like sorting, filtering, and working with unique values. For those not using…
Hope this will help