Forum Discussion

ImalkaJ's avatar
ImalkaJ
Copper Contributor
Oct 18, 2021
Solved

Filter function in table

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 

BI & Data Analysis
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 23, 2021

    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.

2 Replies

  • Yea_So's avatar
    Yea_So
    Bronze Contributor
    Oct 24, 2021

    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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 23, 2021

    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.

Resources