dynamic arrays

3 Topics

Excel Dynamic Array Improvements
Since announcing dynamic arrays, we’ve received an overwhelmingly positive response from the community. Being a fundamental change to the way formulas work, we wanted to take some time to gather and incorporate user feedback. Below are some of the improvements we've made.
JoeMcDaid
Mar 23, 2020 Place Excel Blog
49KViews
14likes
71Comments
Array
I am new to dynamic array and i have downloaded the template but instead of value #NAME? is coming and i m unable to solve it. pls help
Ams28
Sep 03, 2019 Place Excel
1.3KViews
0likes
3Comments
Dynamics Arrays & Array Formulas in Excel Online
Anyone have any clue as to when or even if excel online (the javascript/web version of excel) will be getting dynamics arrays and array functions (especially the new ones e.g UNIQUE)? Right now they definitely do not work in excel online for my tenant, and I cannot find any info about if they ever will. The current behaviour when opening a document already using dynamic arrays or the new functions is very counter-intuitive and sometimes fully dysfunctional. I want to adopt the hell out of these, but can't even gauge when/if I should. In my opinion you should be able to open any excel document in both apps so long as they are both using only cell functions because the alternative is very confusing for average users, so this stops me from using them except for pet cases.
Solved
Myles Gallagher
Aug 09, 2019 Place Excel
2KViews
0likes
2Comments