Understand Implicit Intersection
January 28, 2022 - by Bill Jelen
In the previous article, Why use the intersection operator, notice that the formulas in the last two figures were outside of the range B:I. Before Dynamic Arrays are introduced to Office 365, those formulas would not work in that area due to a feature called “Implicit Intersection”. Here is how it works.