SINGLE

SINGLE(value)

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

valueThe 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.
* This function was only available in Excel 2021 when Dynamic Formulas were first introduced.
* This function was released in July 2020, available in Excel 2021 and then removed in Excel 365.
* 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

 ABCD
1SINGLE(C1:C2) = 5 5 
2SINGLE(C1:C2) = 10 10 
3SINGLE(C1:C2) = #VALUE!   
4SINGLE(C4:D4) = #VALUE! 1520

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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top