Just to add to Bob's response...

Debra Dalgleish shows how to do this advanced filter:
http://contextures.com/xladvfilter01.html#FilterUR


Bob Phillips wrote:

Why not just produce a list of unique values using Advanced Filter?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Valery" wrote in message
...
But i need selected all values to any cells or to any variables, from
criteria list of autofilter.
It's possible? How to get this list?
exel this list is present!
How manually
"Joel" wrote:

You can add an auxilary column to the worksheet which contains years.
The
column can be hidden or put it in a coulumn that is not normally seen
(IV).

"Valery" wrote:

Hi all!
It seems to me that my last question about criteria wasn't considered
:(
I read this http://www.j-walk.com/ss/excel/usertips/tip044.htm but
it's not
That I'll now one more try explain my problem
link to file http://aljany.com/Criterias_.jpg and my example file is
here
http://aljany.com/My_Book.xls
The first column contains years, the second contains month. On these
columns
Autofilter is applied. There is a form of input of filter for users.
In it
we choose a year, for example 1977. Excel will filter on a year the
first
column and will rotin in Autofilter in the second column collection
from
months, for example «august, september, june» are avaliable. How to get
this
avaliable criteria values? If the program chooses in form input in
listbox
these three months, and I will choose july for example. Now in form
input an
only one month - «july» will appear in listbox. And I need all of
variants
months on 1977 year. How to take them all avaliable criteria from the
list of
Autofilter?

How to get this?
In fact Excel it as did do that?
Help me please in it :(
Thank you

--

Dave Peterson