Is there a way in VBA to compare two sets of numbers to see if there is a match, and use each value only once? For example (imagine each number is in its own cell and there are 3 columns):
1 2 3 matches with 1 2 3
1 3 3 does not match with 1 2 3
1 2 3 matches with 1 3 2
I'm looping through worksheets in a workbook and comparing them to a column in a different workbook. I can probably handle the specifics, but need a little help with the technique.
Thanks,
Bookmarks