Forum Discussion

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.