Forum Discussion
Implicit intersection operator
Actually it works as explained in support article and forces exactly the same implicit intersection behaviour as it is in pre-DA Excel where it is performed silently by default.
OFFSET returns range, not array. Thus second point is applicable to your situation. Since formula returns horizontal range, you may return intersection with the column, not with the row. As for example
Implicit intersection with the row returns an error since returned by formula range has multiple values in the row, actually we have no intersection here. That could be illustrated on more simple example:
And if formula returns an array, not range, implicit intersection operator returns first element of such array.
Actually it works as explained in support article and forces exactly the same implicit intersection behaviour as it is in pre-DA Excel where it is performed silently by default.
OFFSET returns range, not array. Thus second point is applicable to your situation. Since formula returns horizontal range, you may return intersection with the column, not with the row. As for example
Implicit intersection with the row returns an error since returned by formula range has multiple values in the row, actually we have no intersection here. That could be illustrated on more simple example:
And if formula returns an array, not range, implicit intersection operator returns first element of such array.
Thank you for your response, including your spreadsheet. I opened your spreadsheet and followed your examples. I appreciate that you added additional information to help clarify.
KStecyk , you are welcome, glad to help