Dynamic Arrays Debut September 24

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,688
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It was in Joe McDaid's Twitter feed. :)
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,058
Office Version
365, 2010
Platform
Windows, Mobile
Thanks got it :)
Just in case anyone wants to see it (Jan 17 if anyone looks at this at a later date)...
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,302
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.
 

MARK858

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,711
Office Version
365
Platform
Windows
Are you using 365 & if so what channel are you on?
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,302
365 yes, but it's a semi-annual channel, so that's probably why. I'm on Version 1908, Build 11929.20562.
 

MARK858

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

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,058
Office Version
365, 2010
Platform
Windows, Mobile
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,089,637
Messages
5,409,464
Members
403,265
Latest member
HMR120

This Week's Hot Topics

Top