Hi
i have two columns where in i have a field Region ID coming from two diff tables. Now i need to find out the common Region ID values between Table 1 and Table 2. InTable 2, i have duplicate Region ID's. How can i find out the common values between the two columns with duplicate values also.
I have attached the file with the values.
Pls help me what can i do.
Thanks
Rita
It would help if you outlined expected results.
If you're saying you want to list all items from Table2 that appear in Table1 including any duplicated entries then:
then
Please Login or Register to view this content.
the above is based on sample file in which values in A & B are sorted in Ascending order.Please Login or Register to view this content.
edit: above revised to account for possibility that first List2 value is lower that first List1 value
Last edited by DonkeyOte; 10-13-2010 at 06:14 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks