Exceljet

Quick, clean, and to the point

Spill

Example of "spilling" in a dynamic array formula

The term "spill" refers to a behavior where formulas that return multiple results "spill" these results into multiple cells automatically. In the example shown, the formula in D5 is:

=SORT(B5:B14)

The SORT function returns 10 sorted results. Even though the formula is entered just once in cell D5, all 10 values "spill" into the range D5:D14 automatically.

The range of results returned by a formula that spills is called a spill range. When something on the worksheet blocks a spilled array formulas, it will return a #SPILL! error.

Note: The spilling behavior is a beta feature available only through the Office Insiders program. This feature is expected to be released in 2019 to Office 365 subscribers.