Hi
Need some help.
This is what I am facing
I have two arrays with the following unique values
Array1: a,b,c,d,e (all unique,no repetition)
Array2: a,b,c,d,e,f,g,h,i,j (these values can be repeated as a,b,a,a,c,b,j,h...)
Every time the array 2 element matches the array 1 element, in a new column I want the value 1, else 0
eg for the above series (1,1,1,1,1,1,0,0)
I have looked up the forum but not found the right answer.
Please help.
Thanks in advance
I have no doubt the other guys who are actually good with Arrays can come up with a more efficient method than this
depending on case sensitivity of match etc you might wish to adjust the comparison method
Please Login or Register to view this content.
edit:
do you mean you want to conduct a Match on each element to the unique vals to see if it exists (irrespective of position) - I suspect you do ....Originally Posted by PradeepRed
Last edited by DonkeyOte; 09-17-2010 at 04:08 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
If my edit's correct then in theory you could use something like the below rather than iterating v2 item by item:
though the above in that form would return Boolean True/False rather than 1/0Please Login or Register to view this content.
(and Match is not case sensitive - unknown if that's an issue or not)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks