The Implicit Intersection Operator: The Function You’ll Probably Never Use

Abbott Ira Katz · Apress eBooks · 2022

We just said it before, and we’ll say it again: you probably won’t ever use the intersection operator, for reasons we’re about to detail. But the operator is available, just the same; and what the operator – signified by the @ sign – does, for what it’s worth, is reduce a dynamic array spilled range to a single-celled output, thus emulating the behavior of formulas in pre-Excel 365 versions.

Read the paper · More papers on PaperTik