Oct 18 2021 02:13 PM
Hi there,
I am using filter function to bring 2 columns from a another table. I want to make it a table. But I get the regular #SPILL error message. Is it a limitation or is there a way to write filter formula for a table.
Thanks,
Imalka
Oct 23 2021 01:09 PM
SolutionSpills are not married with tables, you may use dynamic array function within table if only it returns one value, not spill. That's by design, at least by current design.
Oct 24 2021 07:37 AM
spill does not work inside excel defined tables, it has to be a regular range otherwise you're just going to get a #spill error
Oct 23 2021 01:09 PM
SolutionSpills are not married with tables, you may use dynamic array function within table if only it returns one value, not spill. That's by design, at least by current design.