I've got a column of product names and I need to create a list of the
distinct product names in that column. I can do this by looping through the
data and updating a list, but I was wondering is there is a
better/cleaner/faster way to do this. The autofilter function creates a list
of distinct item in that column. Is there a way to use that functionality?

Thanks in advance,
Raul