- Excel Desktop Client new !
SET evaluates set operations to be performed on a pair of lists.
Duplicate objects are removed so A ^ A may generate a smaller list than A. Also there is no guarantee as to the order of the elements in the resulting set.
|List A:||The first LIST|
|List B:||The second LIST|
|Function:||Intersection, Union, Difference|