Jul 01 2020 03:43 AM
The dynamic arrays were released for the people in the Office Insider program in 2019. However, these formulae are not available in the Version 1908 (Build 11929.20838). It is the semi-annual enterprise channel.
Does anyone know when these formulae will be released in the semi-annual enterprise channel?
Jul 01 2020 07:25 AM
@Rushabh_Doshi Hello, see this post.
"March 31st 2020 Update
Dynamic Arrays is now available to Office 365 users on all endpoints, with the exception of users on the Semi-Annual channel. It will be available to users in Semi-Annual (Targeted) channel starting mid April 2020."
https://techcommunity.microsoft.com/t5/excel-blog/preview-of-dynamic-arrays-in-excel/ba-p/252944
Reach out to the Program Manager Joe and perhaps you'll get an updated status.
Jul 01 2020 06:41 PM
Thanks for the link.
The office version I am running is 1908. (Build 11929.20838 Click-to-Run)
Semi-Annual Enterprise Channel.
Maybe that's why the dynamic array formulae do not work in this version.
I will try and reach out to the program manager for an update.