Forum Discussion

anshul-marele

Copper Contributor

Dec 23, 2023

Any solution for #SPILL error in Excel Table

Hi, Is there any solution for #SPILL error in Excel Table while using array formulae?

excel

anshul-marele

Copper Contributor

Dec 23, 2023

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.

Riny_van_Eekelen

Platinum Contributor

Dec 23, 2023

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?