Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Scenerio:
Set A = 1,2,3,4,5 (lets the numbers are in E2 to I2) Set B = 1,2,6,7,8 (lets the numbers are in E3 to I3) Now how to find the following problems: 1. Set A union set B in cell A10 (i.e in A10 cell the numbers should be 1, 2, 3, 4, 5, 6, 7, 8) 2. Set A Intersection Set B in cell A11 (i.e. in A11 cell the numbers should be 1, 2) 3. Uncommon numbers between Set A and Set B in cell A12 (i.e. in A12 cell the numbers should be 3, 4, 5, 6, 7, 8) Could anyone can help me to solve this problem? Thanks Sadi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Intersect and Union | Excel Programming | |||
Intersect or Union? | Excel Programming | |||
Intersect or Union? | Excel Programming | |||
Complex Union Intersect | Excel Worksheet Functions | |||
Intersect, Union... where's Deduct? | Excel Programming |