VBA to get List of Unique Items from column
While I see you're building an answer array you might consider using some of
Excel's built-in Advanced Filter functionality to create an answer table.
You could even read the result into an array if that is really the end
result you want:
Range("J2", Range("J2").End(xlDown)).AdvancedFilter xlFilterCopy, ,
Range("K2"), True
--
Jim Rech
Excel MVP
|