Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_9

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

Abbott Ira Katz¹  

(1)

Edgware, UK

 

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.

An example: you’ll recall our Beatles range a couple of hundred pages ago cataloging the ...