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