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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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
35,177
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
45,283
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
35,177
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,922
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,102,844
Messages
5,489,221
Members
407,681
Latest member
HoneyBadger914

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top