Convert Dynamic Arrays into Tables
The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.
it'll be great!!,,, like and alternative for Query but with functions
Table structured references are a more well-defined way to model information.
It is very natural that dynamic arrays should be able to be used in tables and expand and contract the number of rows.
Tables are also an invaluable asset to work with automation with Microsoft Flow, it should be possible to combine dynamic arrays with them and leverage the result in Microsoft Flow automation.
Umang Kejriwal commented
Table has an option of total row which would be very useful for filtered data. since number of rows of a filtered data is not constant, the total row can automatically move up and down which is very useful.
Ed Hansberry commented
The biggest shortcoming to the new Dynamic Array functions is the inability to use them in a table.
Eder Rodrigues de Souza commented
It will help a lot if this happens.
Cristiano Galvão commented
Hi Guido. Yes, dynamic arrays are awesome. I published a video about them too: https://youtu.be/J7XW9CPq1rU
HackSlash, I mean the opposite: dynamic arrays to table.
I want to be able to use dynamic arrays with tables, not convert them to tables.
I find this a great idea. I've seen nice vids/demos of MVP on dynamic array functions, but I was also a bit disappointed when they announced the incompatibility with tables.
Somehow it seems natural, since tables can resize, that they would resize based on the array spill result.
Do you mean convert tables to Dynamic Arrays? It looks like Dynamic Arrays can do everything that tables can do plus the source data can expand just like the table itself.