Allow Dynamic Array Spill Range in official Excel Table
It would be great if we can insert dynamic array formulas in official excel table, currently its not supported.
Wonder what in the world can happen if we can use Dynamic Array functions like FILTER/UNIQUE in an auto expanding and auto collapsing excel tables. This will AUTOMATE lots of work in a single feature.
Please consider the request.
I don't understand what Excel team to add this feature 😱
Pavel Kabir commented
As a first baby step, at least a spilling formula could auto-expand a data table.
In our business scenario, it is not even necessary to auto-collapse it if the user removes the spilling formula.
Singaravelu S commented
Microsoft need to bring this in their roadmap asap. I was shocked when learnt that spill won't work in tables.