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
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.