Spill Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1503692%22%20slang%3D%22en-US%22%3ESpill%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503692%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help%20-%20Spill%20error%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1503708%22%20slang%3D%22en-US%22%3ERe%3A%20Spill%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F717750%22%20target%3D%22_blank%22%3E%40jonathanplastina%3C%2FA%3E%26nbsp%3BYou%20have%20entered%20a%20Dynamic%20Array%20formula%2C%20that%20spills%20the%20results%20to%20a%20range%20of%20cells.%20If%20there%20is%20not%20enough%20space%20to%20spill%20into%2C%20the%20%23SPILL!%20error%20occurs.%20Free-up%20the%20area%20where%20Excel%20wants%20to%20put%20the%20results%20or%20move%20your%20formula%20away%20from%20occupied%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Please help - Spill error

1 Reply
Highlighted

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