Filter function in table

[ImalkaJ]

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 

[#2 · Accepted solution]

@ImalkaJ 

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

[#3]

@ImalkaJ 

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