Spill list as a table

[ajocius1]

I use FILTER function to limit data I get from rather large table on separate workbook (about 500 000 lines), that results with about 7 000 lines. Those 7 000 lines is base for number of calculations. It would be great to have that list of 7 000 lines as a table, so that formulas linking to this table could be easily dynamic. Spill range, which is result of FILTER function will increase or shrink in size as source data will grow or reduce. Is it possible to use table with spill result, assuming that table size will follow number of records returned by FILTER formula?

 

[Fluff]

No, you cannot use spill ranges in a structured table.

 

[shift-del]

Hi

Spillings formulas and tables do not go together.