Dynamic Arrays Debut September 24

[bdika]

Hi Mark858:

I signed up and got what I was looking for.

Thanks.

 

[Peter_SSs]

Microsoft Help still appears to be saying that the new functions (in this case UNIQUE) " is one of several beta features, and currently only available to a portion of Office Insiders at this time. " and yet in this thread (posts 12-22) we have two users who are not Insiders who say they have the UNIQUE function. Have all the new dynamic array functions now been released to all 365 subscribers?

 

[MARK858]

No Peter I still don't have the new functions.

 

[Fluff]

I'm not on the insider program, but got the Dynamic Array Functions at the end of November. MS are rolling them out slowly to see what happens.

Office 365 filter function not working

Just subscribed to office 365,filter f7nction working on my laptop and excel on my phone yet not working on other laptop, I have 5 devices which I can use the subscription on, why is the filter function working on some devices and not others!

www.mrexcel.com

 

[Peter_SSs]

Thanks Fluff. I had 'read' Bill's post to mean "Office 365 Insiders Monthly Channel accounts'. It's a bit of a mess until everybody gets the functions! And you don't know you have them unless you go looking. Anyway, that is clearer now. Thanks again.

 

[Jon von der Heyden]

Thanks Fluff. I had 'read' Bill's post to mean "Office 365 Insiders Monthly Channel accounts'. It's a bit of a mess until everybody gets the functions! And you don't know you have them unless you go looking. Anyway, that is clearer now. Thanks again.

I agree. It's great to see all this new functionality, but from my perspective I simply don't know when it's safe to use them. Our entire company is on 365 but how am I supposed to know when these features are rolled out to all? Is there some sort of announcement once they are truly released globally?

 

[Fluff]

A complete disaster IMO, I only realised I had them when I copy/pasted a formula into Xl & it "spilled down", as it was the first time I'd seen it I was thinking WTF!!?

Hopefully MS will announce when all 365 subscribers have them, but I won't hold my breath.

 

[MARK858]

Just an update I have just had the new functions added to mine (not sure exactly what day they were added, probably the 15th as there were Microsoft updates that day for me).

 

[RoryA]

They announced a couple of days ago that they are generally available in the monthly release channel.

 

[MARK858]

They announced a couple of days ago that they are generally available in the monthly release channel.

Hi Rory, do you have a link as the only link I can see is the one below where I don't see them mentioning that the rollout is now generally available.

Release notes for Monthly Channel releases in 2020 - Office release notes

Provides IT Pros with release notes for Monthly Channel releases for Microsoft 365 Apps in 2020

docs.microsoft.com