Select Distinct Items in a Column

[Guest]

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

 

[Frank Kabel]

Hi
just record a macro while using 'Data - Filter - Advanced Filter' with
checking 'Unique entries'

 

[Guest]

That works.
Thanks

Is there a way to populate an array with the advanced filter results without
puting the results on the spreadsheet first?

Raul

 

[Alan Beban]

That works.
Thanks

Is there a way to populate an array with the advanced filter results without
puting the results on the spreadsheet first?

Raul . . .

Without regard to the advanced filter results, if the functions in the
freely downloadable file at http://home.pacbell.net/beban are available
to your workbook

myArray=ArrayUniques(Range("A2:A12"))

Alan Beban