Dynamic Arrays Debut September 24
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Dynamic Arrays Debut September 24

  1. #1
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    873
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Dynamic Arrays Debut September 24

    Microsoft just announced Dynamic Arrays for Excel.

    They say that Ctrl+Shift+Enter will not have to be used anymore.

    It is the 4th item on this page: https://www.microsoft.com/en-us/micr...day-at-ignite/

    but I think it is the most important. My first article about them:
    https://www.mrexcel.com/excel-tips/e...in-office-365/
    Last edited by MrExcel; Sep 24th, 2018 at 09:01 PM.
    View a collection of recent Excel articles in the Excel Daily News

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,288
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    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 ...!!!

  3. #3
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,724
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    About time they caught up with Google!

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

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,339
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    Thanks for the information Bill. Look forward to trying these things out!
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  5. #5
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,288
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    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 ...!!!

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,724
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    No, it won't, to the best of my knowledge.

  7. #7
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,288
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    Quote Originally Posted by RoryA View Post
    No, it won't, to the best of my knowledge.
    Thanks Rory ...

  8. #8
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,472
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    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.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  9. #9
    New Member
    Join Date
    Jul 2015
    Posts
    0
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    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?

  10. #10
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    10,995
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Dynamic Arrays Debut September 24

    Some (if not all) are available now if you sign up to the Insiders program.

    https://insider.office.com/en-us/
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •