Dynamic Arrays Debut September 24

It was in Joe McDaid's Twitter feed. :)
 

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.
Thanks got it :)
Just in case anyone wants to see it (Jan 17 if anyone looks at this at a later date)...
 
I'm a little bummed. I got the latest Office updates this morning. There are some obvious changes to the icons, the ribbon, and other odds and ends, but it did not include the dynamic array functions.
 
Hi Eric, I didn't receive XLookup and XMatch (they are still only on the Insider program as far as I am aware) but I think I got everything else, is there anything other than XLookup and XMatch that you didn't receive?
 
Are you using 365 & if so what channel are you on?
 
365 yes, but it's a semi-annual channel, so that's probably why. I'm on Version 1908, Build 11929.20562.
 
That'll explain it, as far as I know the last release was only to the Monthly channel (still have a little wait for the lookup functions still it seems).

1579636186701.png
 
Just an update in case anyone hasn't seen or realised it but XLookup and XMatch have now been put on general release to everyone with a 365 monthly channel subscription. Semi-Annual in the July release.

1580699101784.png


1580699427354.png
 

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top