SOLVED
Home

New dynamic array functions not available in latest Excel version

%3CLINGO-SUB%20id%3D%22lingo-sub-793373%22%20slang%3D%22en-US%22%3ENew%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793373%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Excel%20Version%201907%20(Build%2011901.20176)%20and%20according%20to%20the%20list%20of%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhat-s-new-in-excel-for-office-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Enew%20features%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3Bthis%20version%20should%20include%20the%20new%20dynamic%20array%20functions%20(%3CSPAN%3EFILTER%2C%20SORT%2C%20SORTBY%2C%20UNIQUE%2C%20SEQUENCE%20and%20RANDARRAY).%20But%20the%20new%20function%20aren't%20available%20in%20my%20Excel.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20ideas%20on%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20in%20advance.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETieme%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793452%22%20slang%3D%22en-US%22%3ERe%3A%20New%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20according%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fmonthly-channel-2019%23excel-feature-updates%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%3C%2FA%3E%26nbsp%3Bthe%20new%20functions%20are%20not%20part%20of%26nbsp%3B%3CEM%3EBuild%2011901.20176.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793469%22%20slang%3D%22en-US%22%3ERe%3A%20New%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BThanks%2C%20that%20explains%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793719%22%20slang%3D%22en-US%22%3ERe%3A%20New%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20help%20from%20MS%20technical%20support%20I%20was%20able%20to%20solve%20this.%3C%2FP%3E%3CP%3EI%20wanted%20to%20use%20Excel%E2%80%99s%20dynamic%20array%20functions%20(e.g.%20Filter()%2C%20RandArray()).%3C%2FP%3E%3CP%3EI%20am%20an%20Office%20365%20Home%20Subscriber.%3C%2FP%3E%3CP%3EI%20was%20using%20version%201907%20Build%2011901.20176.%3C%2FP%3E%3CP%3EPer%20MS%20support%20suggestion%2C%20I%20joined%20Insider%20and%20subscribed%20to%20the%20insider%20newsletter.%3C%2FP%3E%3CP%3EIt%20took%20about%2010%20minutes%20but%20eventually%2C%20new%20updates%20became%20available%20to%20Excel.%20(File-%26gt%3BAccount-%26gt%3BOffice%20Updates).%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20downloading%20the%20updates%2C%20I%20closed%20and%20restarted%20Excel.%3C%2FP%3E%3CP%3EThe%20functions%20are%20now%20available%20to%20me.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126062i44BC3DD64291AE9A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-08-07%2014_04_33-Book1%20-%20Excel.jpg%22%20title%3D%222019-08-07%2014_04_33-Book1%20-%20Excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794142%22%20slang%3D%22en-US%22%3ERe%3A%20New%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131546%22%20target%3D%22_blank%22%3E%40Tieme%20Woldman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnjoy%20the%20new%20functionality.%26nbsp%3B%20As%20good%20as%20they%20are%2C%20the%20new%20functions%20are%20only%20part%20of%20the%20story.%26nbsp%3B%20Instead%20of%20array%20formulae%20being%20the%20exception%20as%20in%20normal%20spreadsheet%20development%2C%20it%20is%20now%20rare%20that%20one%20needs%20to%20use%20anything%20but%20array%20formulas.%26nbsp%3B%20One's%20whole%20mindset%20can%20change%20and%20copying%20single%20cell%20formulas%20becomes%20a%20thing%20of%20the%20past!%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795004%22%20slang%3D%22en-US%22%3ERe%3A%20New%20dynamic%20array%20functions%20not%20available%20in%20latest%20Excel%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366980%22%20target%3D%22_blank%22%3E%40Grosner%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20installed%20the%20latest%20insider%20update%20(I'm%20om%20Office%20Pro%20Plus%20and%20had%20to%20update%20through%20Office%20deployment)%20and%20now%20the%20new%20(stunning)%20functionality%20is%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20support.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Tieme Woldman
Occasional Contributor

I have Excel Version 1907 (Build 11901.20176) and according to the list of new features

 this version should include the new dynamic array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY). But the new function aren't available in my Excel.

Any ideas on this?

 

Thanks in advance.

Tieme

 

 

5 Replies
Solution

@Tieme Woldman 

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

 

@Tieme Woldman 

With help from MS technical support I was able to solve this.

I wanted to use Excel’s dynamic array functions (e.g. Filter(), RandArray()).

I am an Office 365 Home Subscriber.

I was using version 1907 Build 11901.20176.

Per MS support suggestion, I joined Insider and subscribed to the insider newsletter.

It took about 10 minutes but eventually, new updates became available to Excel. (File->Account->Office Updates). 

After downloading the updates, I closed and restarted Excel.

The functions are now available to me.2019-08-07 14_04_33-Book1 - Excel.jpg

@Tieme 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!  

@Peter Bartholomew @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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies