Forum Discussion
In whick version of Excel was adynamic arrays general available?
Hi Geir,
In Office365 build number is not very important, new functionality is distributed by channels. Dynamic Arrays are available so far for insiders, i.e. on Insiders Fast and Monthly Targeted (aka Insiders Slow) channels. You may have higher build number compare to one for which DA was introduced, but if you are on another than above channel the functionality is not switched-on.
Within channel new functionality is also distributed gradually, not at one time for all users on the channel. Thus some delay could be after announcement, especially for local versions.
Crossing my fingers that wide release will be announced this week in conjunction with Ignite -- but here are the steps to move to Targeted, if you want to update now with 365 Pro Plus:
Steps: https://docs.microsoft.com/en-us/office365/troubleshoot/administration/switch-channel-for-office-365
Link to get url for monthly targeted: https://docs.microsoft.com/en-us/sccm/sum/deploy-use/manage-office-365-proplus-updates#change-the-update-channel-after-you-enable-office-365-clients-to-receive-updates-from-configuration-manager
Summary: -- copy batch script to notepad (making sure you update it with the correct URL for Targeted), save as .bat file and run-as-adminstrator; then do an Update Now from excel to get the new download.
Ah, spoke too soon! -- sounds like dynamic arrays will begin rolling out to standard 365 users this week on a rolling basis:
"We’re happy to announce that dynamic arrays will be generally available starting this week on Excel for the web. We will be rolling out to subsets of our users to continue to gather feedback and monitor quality as we strive to provide a great experience for our customers. With dynamic arrays, you can write one formula such as FILTER, SORT, or UNIQUE (among others) to get an array of values returned, rather than having to write one formula that returns only one value at a time. Values from dynamic arrays will automatically “spill” or be placed in neighboring blank cells so that you get all the values you need from one formula."
https://techcommunity.microsoft.com/t5/Excel-Blog/Excel-Announcements-Ignite-2019/ba-p/964482
wanderslth , that's only for Excel Online.