SINGLE

SINGLE(value)

Returns the value from a cell range which is the intersection of a row OR a column.

value

The value to evaluate using implicit intersection.

REMARKS

* Removed in 365 and not kept for backwards compatibility.
* The Implicit Intersection Operator @ should be used in Excel 365 to indicate implicit intersection.
* If "value" is a range, the cell at the intersection of the row or column of the formula cell with the intersection of the row and column of the range.
* If "value" is a range and there is no intersection then #VALUE! is returned.
* If "value" is a range and there is more than one cell that intersects then #VALUE! is returned.
* If "value" is an array, the first item (row1, column1) is returned.
* You can use the INDEX function to return the intersection of a row AND a column.
* For the Microsoft documentation refer to support.microsoft.com
* This function was only available in Excel 2021 when Dynamic Formulas were first introduced.
* This function was first released in July 2020, available in Excel 2021 and then removed in Excel 365.

	A	B	C
1	SINGLE(C1:C2) = 5	5
2	SINGLE(C1:C2) = 10	10
3	SINGLE(C1:C2) = #VALUE!
4	SINGLE(C4:D4) = #VALUE!	15	20

1 - What is the intersection of the cell A1 with the range B1:B2. The row intersects so the cell returned is B1.
2 - What is the intersection of the cell A2 with the range B1:B2. The row intersects so the cell returned is B2.
3 - What is the intersection of the cell A3 with the range B1:B2. The row and column do not intersect.
4 - What is the intersection of the cell A4 with the range B4:C4. The row intersects but there are multiple cells B4 and C4.