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. * 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. * 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 

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