Dynamic Arrays Debut September 24

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,458
Office Version
365
Platform
Windows
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,427
Office Version
365, 2010
Platform
Windows, Mobile
No Peter I still don't have the new functions.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,989
Office Version
365
Platform
Windows
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.

 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,458
Office Version
365
Platform
Windows
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. (y)
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,797
Office Version
365
Platform
Windows
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. (y)
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,989
Office Version
365
Platform
Windows
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

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,427
Office Version
365, 2010
Platform
Windows, Mobile
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,816
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
They announced a couple of days ago that they are generally available in the monthly release channel.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,427
Office Version
365, 2010
Platform
Windows, Mobile

Watch MrExcel Video

Forum statistics

Threads
1,096,169
Messages
5,448,754
Members
405,530
Latest member
MamaButt

This Week's Hot Topics

Top