Dynamic Arrays

Copper Contributor

Hi There!

@Baccma 

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

@Naveli_Gupta 

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)