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 Microsoft 365.
* This function was available to Office Insiders but was replaced with the @ implicit intersection character before the final public release.
* This function is only provided for backwards compatibility.
* This function can return a Dynamic Array Formula.
* You can use the INDEX function to return the intersection of a row AND a column.
* You will no longer get implicit intersection of your formulas, instead, where it detects an implicit intersection, this function will be added.

 A
1??


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