Forum Discussion
Excel SORT() and FILTER() functions are missing
Chris2280 , strange, it shall work. Try simply insider.office.com or google "Office 365 insider program". Actually this site gives an information about Insiders program and somewhere it shall be instruction how to join and install insiders version - it depends on your platform and are you on personal or business subscription.
The Excel SORT function is one of 6 released in July 2019 to build Version 1907 (Build 11901.20176) but I am on a later build (Version 1908 Build 11929.20300) and I still cannot see these new formulas available.
These days build number practically means nothing. It only indicates that starting from this build you have a chance to receive this or that new functionality.
New functionality is deployed gradually by channels. First Insiders Fast, next Monthly Targeted, next Monthly channel, etc. You may have some build on Monthly channel but have no new functionality witch another person on Monthly Targeted received with the same build.
Moreover, gradual deployment is within same channel as well. You may be on the same channel and on the same build with another person, but one of you already have new functionality, another one not.
That could take months to deploy functionality to everyone within same channel. I don't know what is the exact mechanism of deployment, perhaps you receive some registry key when next time login to Office. What is the logic on server side, when and to whom to flick the switch.
SergeiBaklan
I have enrolled in First Insiders Fast with Office 365 subscription and I also see that SORT() and FILTER() are not available.
I encountered the problem when downloading from Google Sheets to Excel.
Any more information on when the functions will be available?If you are on Insiders Fast it shall be available. Please check your channel with File->Info->Account->About Excel
If your channel as above and you have no Dynamic Arrays functionality, send a Frown to Microsoft with File->Feedback
