In whick version of Excel was adynamic arrays general available?

[Geir Hogstad]

Hi,

I have an Office 365 customer (using the Norwegian version of Excel) which is till missing Filter, Unic, Sort and other dynamic arrays functions.

So which version (build do teh need to roll ou to get them? Current version in us is: 16.0.12228.35900

Best regards

- Geir

[#2 · Accepted solution]

@Geir Hogstad 

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.

[#3]

Hi Sergei,

Thank you for the update. We just have to be patient the, or get the customer on the Insider program.

It must be many users waiting for it. It bringe (more) magic to Excel.

Best egards
- Geir

[#4]

@Geir Hogstad 

Geir, Ignite starts these days, perhaps on it Microsoft will give more info about GA of DA

[#5]

Hello,

Most likely you're using Office 365 Pro Plus version. Dynamic arrays functions isn't available to Office 365pro plus users... Only available to Office 365 Insiders

[#6]

@Geir Hogstad 

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

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.  

[#7]

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

[#8]

@wanderslth , that's only for Excel Online.