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 |
| * 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 |
|
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top