The Intersection Function

Available in Sets.xla, a Microsoft© Excel add-in.
Click "Intersection",or scroll this page for Intersection examples.
Click on another function in the browser window to read about it.
Click a function.

Difference Right Associative Difference Disjoint Union Intersection MakeList MakeSet MatrixToList NMakeList PowerSet SymmetricDifference Union

The Intersection Function

The Intersection function returns a set.
The function can be called in one of two ways.
  1. From the function browser, above.
  2. Typing the function into directly into a cell.

Examples

In these examples, function outputs are colored red.
C1 = Intersection(A1:B1)
C2 = Intersection(A1:B2)
A3 = Intersection(A1:A2)
C3 = Intersection(A1:B3)
D3 = Intersection(WVName), where WVName = (A1,A4,B4,C4).
D4 = Intersection(A1,A4,B4,C4) produces an error.
  A B C D
1 1,2,3 {1,2,3},1 {1}  
2 1,2 1,{2} {1}  
3 {1,2} {1,2},3 {} {1}
4 1 {1},1 {1},2,1 #VALUE

Rules for Selections

Noncontigous cells may be intersected by reference to a workbook variable.
Cells A1,A4,B4,C4 are assigned the workbook variable name, "WVName".
See cells D3 and D4, above.

Created on ... December 27, 2001