The term "spill range" refers to the range of values returned by an array formula that spills results onto a worksheet. This is part of Dynamic Array functionality in the latest version of Excel.
In the example shown, the formula in D5 is:
=UNIQUE(B5:B16)
This formula returns seven unique values, and these results spill into the range D5:D11 automatically. The range D5:D11 is called the "spill range". When you select any cell in a spill range, entire range will be highlighted with a blue border.
Cell reference syntax
You can refer to a spill range with the first cell in the range and a hash character (#) like this:
=D5# // entire spill range
To count values returned to the spill range, you can write:
=COUNTA(D5#) // returns 7
To retrieve the 3rd value, you could use INDEX like this:
=INDEX(D5#,3) // returns "green"
If something on the worksheet blocks a spilled formula, it will return a #SPILL! error.
