LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intersect and Union u473 Excel Programming 2 October 29th 10 08:16 PM
Intersect or Union? Joerg Mochikun Excel Programming 2 July 23rd 08 09:12 AM
Intersect or Union? Bob Phillips Excel Programming 0 July 23rd 08 08:45 AM
Complex Union Intersect [email protected] Excel Worksheet Functions 3 May 23rd 07 12:23 PM
Intersect, Union... where's Deduct? rumi Excel Programming 5 September 13th 05 06:39 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"