Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two simple array variables in some VBA code. I'm wondering
what is the simplest way to compare the contents (typically less than 50 items in each array) to find dupes. Specifically, I would do this: If arFirstList (i) is in arSecondList then Do this stuff.... Else Do this other stuff End if Is there a function that would handle this or do I need to create a For Next loop that completely cycles through the arSecondList each time I go to a new member in arFirstList? Thanks in advance. - John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate Find not finding all dupes | Excel Discussion (Misc queries) | |||
Compare arrays | Excel Worksheet Functions | |||
Compare arrays | Excel Worksheet Functions | |||
how to compare two arrays? | Excel Programming | |||
How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) |