Spill ranges and Tables

[Gregg Wolin]

I’m addicted to utilizing dynamic array formulas now that they are easier to deploy but they play havoc when attempting to integrate with my use of tables (which use has historically been limited). I’m just wondering how you guys are using sequence, filter, etc. in conjunction with tables.

 

[Debaser]

You can't use dynamic array formulas in tables.

 

[GraH - Guido]

Tables are the place to store raw data. Inside a table, since they 'fill down' automatically, you don't need spilled arrays inside them. You can use Dynamic Array formulae in a table as long as they do return a single result.