Notifications
Clear all
Topic starter
Hi,
I had If formula and made them table, then cells with If formula have 'Spilled arrays error' and won't display the result. It shows all information when I remove table but won't show the result when it become a table.
Does anyone know what's going on with this?
Posted : 25/09/2021 7:51 am
What is the formula?
Posted : 25/09/2021 11:36 am
Hi Eun,
Dynamic array formulas cannot spill in Tables. In other words, you cannot write a dynamic array formula in a Table. This is simply a limitation of them because Tables are designed for the same formula to occupy every row, whereas a dynamic array spills the results.
Mynda
Posted : 25/09/2021 7:43 pm
Topic starter
Mynda,
Hello, Thank you for your help.
Eun Jung
Posted : 25/09/2021 9:16 pm
