Chapter 9: Introducing Formulas and Functions
9
The intersection operator is one of three reference operators used with ranges. Table 9.4
lists these operators.
FIGURE 9.14
You can use a range intersection formula to determine values.
TABLE 9.4 Reference Operators for Ranges
Operator What It Does: (colon) Specifies a range.
, (comma) Specifies the union of two ranges. This operator combines multiple range refer-
ences into a single reference.
Space Specifies the intersection of two ranges. This operator produces cells that are
common to two ranges.The real value of knowing about range intersections is apparent when you use names.
Examine Figure 9.15, which shows a table of values. We selected the entire table and then
chose Formulas ➪ Defined Names ➪ Create from Selection to create names automatically by
using the top row and the left column.
FIGURE 9.15
With names, using a range intersection formula to determine values is even more helpful.