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.
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.