Thread: Compare 2 arrays, results into third array

Hi all,

I have two arrays i need to do an element comparison on.
Arr is the first array, which is a list from a worksheet range.
ArrRestults is the return results from an sql query, using Arr in the where clause.

ArrResults will contain the same or less data/elements than Arr.

Is there a simple way to loop through Arr, and find any element/data that isn't in ArrResults, and if found, put that value into a third array? (i.e. ArrFound)

Cheers,
Skmr3.

Originally Posted by pike

AHi skimmer333

welcome to the forum
one possible way would be with a Dictionary

Thanks for your reply pike.

Your code got me thinking again, and I got this to work:

For Each c In Arr()
    For i = LBound(ArrResults) To UBound(ArrResults)
    If c = ArrResults(i) Then
            ActiveCell.Value = c
            ActiveCell.Offset(1, 0).Activate
    End If
    Next
Next c

It dumps out all values that are in Arr and also in ArrResults.
Which looks correct.

Now, i'm just trying to work out the reverse.
Dump out all values that are in Arr but not in ArrResults.

/Skmr3.