Dec 29 2021 12:16 AM
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.
Dec 29 2021 02:44 AM
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.
Nikolino
I know I don't know anything (Socrates)