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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Raul" schrieb im Newsbeitrag
...
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

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Raul" schrieb im Newsbeitrag
...
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

Raul wrote:
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