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

* This function is only available in Office 365 to Office Insiders at the moment.
* You can use the INDEX function to return the intersection of a row AND a column.
* This function is provided for backwards compatibility with implicit intersection formulas that can be used in earlier versions of Excel.
* You will no longer get implicit intersection of your formulas, instead, where it detects an implicit intersection, this function will be added.
* For the Microsoft documentation refer to support.office.com

 A
1??


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