Spill Error

Copper Contributor

Please help - Spill error

1 Reply

@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.