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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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,109
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,120
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,109
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,890
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,050
Messages
5,484,417
Members
407,438
Latest member
DKrakken

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top