Forum Discussion

Woldman's avatar
Woldman
Iron Contributor
Aug 07, 2019
Solved

New dynamic array functions not available in latest Excel version

I have Excel Version 1907 (Build 11901.20176) and according to the list of https://support.office.com/en-us/article/what-s-new-in-excel-for-office-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73  this vers...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Aug 07, 2019

    Woldman 

    But according to this the new functions are not part of Build 11901.20176.

     

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Aug 07, 2019

Woldman 

Enjoy the new functionality.  As good as they are, the new functions are only part of the story.  Instead of array formulae being the exception as in normal spreadsheet development, it is now rare that one needs to use anything but array formulas.  One's whole mindset can change and copying single cell formulas becomes a thing of the past!  

  • Woldman's avatar
    Woldman
    Iron Contributor
    Aug 08, 2019

    PeterBartholomew1 Grosner Detlef_Lewin 

    I installed the latest insider update (I'm om Office Pro Plus and had to update through Office deployment) and now the new (stunning) functionality is available.

     

    Thanks for your support.

Resources