List of dynamic array relevant functions - MMMUK1/LambdaForRealEstate GitHub Wiki

Excel functions that return ranges or arrays

CELL

COLUMN

FILTERXML

FORMULATEXT

FREQUENCY

GROWTH

HYPERLINK

INDEX

INDIRECT

ISFORMULA

LINEST

LOGEST

MINVERSE

MMULT

MODE.MULT

MUNIT

OFFSET

ROW

TRANSPOSE

TREND