View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SADEQ AHMAD CHOWDHURY SADEQ AHMAD CHOWDHURY is offline
external usenet poster
 
Posts: 1
Default Important Union Intersect VBA Problems

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