Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing to Arrays
Here's the other task -
I have an array6 that has dimensions as follows - the first dimension could change, but not the second - Array6(22526,25) For each n of Array6(n,25) the Array6(n,1) contains an 18 character length string that corresponds to the Array5 I describe in the earlier post. For information, Array6 contains "used" combinations within Array5. The challenge is that from time to time, the strings in Array6 may no longer be contained with Array5 - and are thus now "invalid". So what I need to do is compare Array5 and Array6 and effectively "tag" each item in Array6 now as "valid" (e.g. its contained it appears in Array6) or "invalid" (it doesn't appear in Array6). In both cases Array5 and Array6 would be sorted based on the corresponding string being compared - Array6(n,1) and Array5(q,1) Again though the problem is that Array5 and Array6 are roughly 20-30,000 long each and thus to loop through each would create a need for something like a little less than 1 billion comparisons. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing 2 arrays | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Worksheet Functions | |||
Comparing to Arrays | Excel Programming | |||
Comparing to Arrays | Excel Programming |