A #SPILL! error occurs when a dynamic array formula cannot return its results because the destination range is obstructed.
Provalo con l'IAThis error happens when a formula is designed to return multiple values, but existing data in the adjacent cells prevents the array from expanding. To resolve it, you must clear the cells blocking the spill range or move the formula to an empty area.
=UNIQUE(A1:A10)If you enter =UNIQUE(A1:A10) in cell B1, but cell B2 already contains data, Excel will return a #SPILL! error because it cannot display the full list.
Click the #SPILL! error cell, and Excel will highlight the specific cells that are currently obstructing the output.