Dynamic arrays not working on Mac

[tim71]

Dear all, I am a Mac user and wonder if anyone has encountered issues on unable to use the new formulas. I deliberately subscribe to Office 365 to be able to use the new formulas as it would save me months on a database project i am using ... when i try to use sort or filter it says the function is invalid. It would be great if someone could shed some light on this as i am contemplating on buying a PC just for the project, but it will be costly. Thanks in advance 

[#2]

@tim71 , to my knowledge DA are only for Windows, only for Excel 365 and only for Office Insiders. So far.

However, better to ask in comments to this blog https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Dynamic-Arrays-in-Excel/ba-p/252944/pag... with direct @mention of Joe (author of the blog and manager of this program).

[#3]

just subscribed to office 365 for the sole purpose of dynamic array functions ... i am on mac and to my utter surprise , it does not work ...

i am on office 365 - Excel 16.29.1 (19091700) for mac , i thought dynamic functions should be present on excel for mac since release 16.27.

Pls help 

[#4]

@yeba456 

Version number practically doesn't matter, new functionality is distributed by channels. Dynamic Arrays were introduced with version 16.27 on Insiders Slow channel https://insider.office.com/en-us/releasenotes/mac/slow. If you are not insider - you don't have such functionality even if your build has higher number. Dynamic Arrays are only for insiders so far, both on Mac and Windows.