Forum Discussion
Any solution for #SPILL error in Excel Table
Hi,
Is there any solution for #SPILL error in Excel Table while using array formulae?
- But this is the big flaw, because Tables are the most structured way to work in Excel and if we cannot use ARRAY functions inside it, we cannot scale-up in such an organized way.
anshul-marele But structured tables are by themselves already "spilling" automatically. Using a dynamic array function inside such a table would create problems.
In your example, what would be the expected result in column H ("Hdr4") with that formula?
I understand that, but when you use power query, power automate, etc. where table format is the default output and you need to use some array functions, you stuck.
Please check below a example.
It is simply not possible/allowed to use dynamic array functions (like UNIQUE) inside a structured table.
