Forum Discussion
jonathanplastina
Jul 03, 2020Copper Contributor
Spill Error
Please help - Spill error
Riny_van_Eekelen
Jul 03, 2020Platinum Contributor
jonathanplastina You have entered a Dynamic Array formula, that spills the results to a range of cells. If there is not enough space to spill into, the #SPILL! error occurs. Free-up the area where Excel wants to put the results or move your formula away from occupied cells.