Excel SINGLE Function

The Excel SINGLE function returns a single value using implicit intersection. The SINGLE function was originally introduced with Dynamic Arrays, but later deprecated in favor of the @ character.
- value - Value to evaluate using implicit intersection.
The Excel SINGLE function returns a single value using implicit intersection. The SINGLE function is primarily for backwards compatibility with implicit intersection formulas in earlier versions of Excel.
When the supplied argument is a range, SINGLE will return the cell at the intersection of the row or column of the formula cell. Where there is no intersection, or more than one intersection, SINGLE returns a #VALUE! error.
In the example shown, the following formula in D6 "spills" and returns all values in the range B4:B8:
=B4:B8
When the single function is wrapped around the same range, SINGLE returns 3, which corresponds to cell B6, which intersects with the formula in cell D6:
=SINGLE(B4:B8)
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.