Implicit Intersection Operator: @

link -
The implicit intersection operator was introduced when the Formula Language was upgraded to support dynamic arrays.
Before Dynamic Arrays implicit intersection existed and happened behind the scenes automatically.
The @ operator to now used to indicate where implicit intersection could (or did) occur.

Implicit Intersection

Implicit intersection logic happens when a formula returns multiple values but only displays a single value in one cell.
If the value is a range, then return the value from the cell on the same row or column as the formula.
If the value is an array, then pick the top-left value.
With the introduction of Dynamic Arrays, Excel is no longer limited to returning single values from formulas, so silent implicit intersection is no longer necessary.
If an old formula was invisibly triggering implicit intersection, Excel will prefix the formula with the @ character.

link -

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext