Set Operators — Filter Sets from Criteria

Operation

From minus also in

Use set letters A, B, C… from cards. Operators: UNION INTERSECT EXCEPT SYMDIFF. Parentheses control order — e.g. (A INTERSECT B) UNION C or A EXCEPT (B UNION C).

Extra columns from full dataset — auto-updates when you Run

∩

Upload data and create sets

Example: Set A = phones with orders 1 Jul – 2 Jul. Set B = phones with orders 3 Jul – 10 Jul. EXCEPT gives phones in A but not B.