When a dynamic array formula outputs multiple values, it is said to spill these values onto the worksheet.
The rectangle that encloses these values is called the “spill range”.
Notice when I select any cell in a spill range, the rectangle will appear with special highlighting.
The spill range for a given formula is dynamic, and may expand or contract as source data changes.
you’ve got the option to use this reference any way you like.
For example, I can use theCOUNTA functionto count the number of colors in the spill range.
Like all dynamic array formulas, if the source data changes, the results will update.
However, if I delete the “x”, the error disappears and the formula spills properly again.
This can also happen if I overwrite part of an existing spill range.
You’ll sometimes hear this behavior referred to as “one formula, many results”.
