Skip to content

INTERSECTION

Given two sets A and B, the INTERSECTION function returns a new set containing the domains that A and B have in common.

For example, given these two sets:

setOne:
    1
    1.01
    1.15
    1.17

setTwo:
    1.01
    1.15
    1.18

the statement:

var common = INTERSECTION(setOne, setTwo);

defines and populates the common sets this way:

1.01
1.15

because domains 1.01 and 1.15 are the only that belong both to setOne and setTwo.

The syntax is:

INTERSECTION(set1, set2)

where set1 and set2 are set variables.