Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2004

Tip: Looking for answers? Try searching our database.

compare unique identifiers in multiple ranges

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bawilli_91125 - 30 Nov 2004 03:33 GMT
Excel 2003.  I am trying to find a simple subroutine that will allow me to
compare entries in multiple, separate ranges, and to produce a new range
containing the entries that are common to all of the initial ranges (what I
would call an "intersection" set of identifiers).  The entries in each of the
initial ranges contain unique identifiers, which can be compared across
ranges.  I would also like to produce an additional range that contains a
list of all the unique identifiers present in all of the initial ranges
compared (what I would call a "union" set of identifiers).  
I have been doing this by iteratively filtering one range against another,
taking the resultant, and filtering against the next range.  This is tedious.
Barb Reinhardt - 30 Nov 2004 18:34 GMT
Could you create a pivot table report of each of the ranges and then use
VLOOKUP to find the "intersection"?   I'm not quite clear on what the work
product, however.

> Excel 2003.  I am trying to find a simple subroutine that will allow me to
> compare entries in multiple, separate ranges, and to produce a new range
[quoted text clipped - 6 lines]
> I have been doing this by iteratively filtering one range against another,
> taking the resultant, and filtering against the next range.  This is tedious.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.