Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two relatively large 1D arrays (I could make them into a two D
with a dummy column if that would help, but I can't imagine how). Both arrays contain a series of strings, with each string being exactly the same length (in this case 18 characters). The characters are numbers as strings. Each array contains 20,000-30,000 elements. The challenge is finding a fast way to compare each element in one array to see if it exists in the second array. I find that if I do this through any simple stepwise looping it takes forever. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing ranges/arrays | Excel Worksheet Functions | |||
Comparing 2 arrays | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Worksheet Functions | |||
Comparing two arrays/ranges | Excel Programming |