Dynamic Arrays

Occasional Visitor

Hi There!


I have office 365 version for Mac, but I am unable to get/use the dynamic array formulas i.e. Unique, Sort, Filter etc. 

However, when I went to help in all functions, it does show in the list there. 

Please help me understand how to get the same. 

1 Reply


You can use array formulas to perform complex tasks

Guidelines and examples of array formulas


Additional Informations:

Dynamic arrays not working on Mac

Dynamic Array Formulas (Excel for Mac)


Hope I was able to help you with this info.



I know I don't know anything (Socrates)