Dynamic Arrays Debut September 24

Joined
Feb 8, 2002
Messages
893
Office Version
365
Platform
Windows
Last edited:

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello Bill ...

LOVE your article and your video #2233 ...:)

Seems that it will be a lot of Fun with this beginning of a new Excel Era ...!!!
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,818
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
About time they caught up with Google! ;)

This will make sorted, unique DV lists so much easier to maintain!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,464
Office Version
365
Platform
Windows
Thanks for the information Bill. Look forward to trying these things out!
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello Bill,

Would you happen to know if Excel 2019 on-premises version will include all these great functions you are describing with Modern Arrays ...

Thanks a lot for your insight ...!!!
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,818
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
No, it won't, to the best of my knowledge.
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,594
The new functions and the new calculation engine are already impressive. I've looked over MrExcel's downloadable treatise on them, and it looks really promising. I'll have to relearn how to do things. I hope one of the future functions they hint at is a SPLIT function like VBA has. It seems like a natural fit for the new paradigm. You could have a Text-to-Columns done via formula. Bill showed a way to update the old formula way, but that still looks awkward.
 

bdika

New Member
Joined
Jul 16, 2015
Messages
0
I purchased a yearly subscription to Office 365 because of these new features, only to find that they are still not included. When will they be available?
 

Watch MrExcel Video

Forum statistics

Threads
1,096,297
Messages
5,449,523
Members
405,569
Latest member
deanro

This Week's Hot Topics

Top