I'd have 2 large ranges:
Both contain duplicates.
I'd like to determine which unique values from A range are contained in B range.
I thought of ruling out these methods:
a) Looping thru arrays and making array of unique values
b) Range.AdvancedFilter Unique:=True
c) Creating pivot tables
I found on Ozgrid this nice looking method:
But it still takes long processing time.
What would you suggest as fastest way ?