Solution: Clear the expected spill range. Reason: The area to be populated with the formula results contains non-empty cells.
#Group sequential testing how to
Once you determined the cause, please find the corresponding example below with the detailed instructions on how to resolve that particular case. To know the exact root of the problem, click the warning icon (a yellow diamond with an exclamation point), and read the message in the first line highlighted in grey: To fix an error, you'll have to investigate each case individually and determine the root of the problem.Īs mentioned above, a #SPILL! error might be caused by various reasons. Or, you might have run into one of the very few features that do not support dynamic arrays. Or the same formula copied across the entire column blocks a spill range. Perhaps, one or more cells in the spilled area contain a space or a non-printing character invisible to a human eye. For instance, if your formula is expected to return more than one value, but the nearby cells are filled with some other data, simply delete that data, and an error will be gone.īut sometimes the reasons are not so obvious and therefore confusing. And if something on the sheet prevents filling that range, a #SPILL! error occurs.įor the most part, this behavior is understandable and predictable. A range of cells containing the results is called a spill range. Please notice, any formula, even the ones that were not initially designed to handle arrays. With the launch of dynamic arrays in Excel 365, any formula that produces multiple calculation results automatically "spills" those results into neighboring cells. Generally, a #SPILL! error occurs when a formula produces multiple results but cannot output them all on the sheet.īefore we dive into specific use cases, let's get a general understanding of spilling in Excel. Does anyone know what it means? Of course, we do, and you'll get your solution in a moment :) Whatever you do, you are now getting a #SPILL error. Just imagine this: you upgraded to Microsoft Office 365 with the latest Excel updates and for some reason the tried and tested formulas you've been using for years have suddenly stopped working. To learn what can trigger this error and how you can resolve it, please keep reading. What does #SPILL mean in Excel? It's an error that occurs when a formula is unable to populate multiple cells with the calculated results.