Dynamic Arrays Debut September 24

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

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,660
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,147
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
41,704
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,660
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,147
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
8,787
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?
 

Forum statistics

Threads
1,077,780
Messages
5,336,256
Members
399,072
Latest member
abublitz

Some videos you may like

This Week's Hot Topics

Top