Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 04, 03:33 AM
bawilli_91125
 
Posts: n/a
Default compare unique identifiers in multiple ranges

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.


  #2   Report Post  
Old November 30th 04, 06:34 PM
Barb Reinhardt
 
Posts: n/a
Default

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.

"bawilli_91125" wrote in message
...
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.





Reply
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



All times are GMT +1. The time now is 04:24 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017