dynamic arrays
2 Topics
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.Solved2KViews0likes2Comments
