Some excellent advice to be seen here, on Debra Dalgleish's site
Contextures.com
http://www.contextures.com/xladvfilter01.html
Regards,
Alan.
"Il Principe" <Il wrote in message
...
Hi,

I am trying to filter a number of rows according to the entry in one of
the
columns, using the advanced filer option and copying to another location.
Each of the columns has a heading.

I have tried to use the Advanced Filter function, but I am confused as to
what range exactly to select in the three fields: list range; Criteria
range
and Copy to and Unique records only.

For clarity, imagine I have 10 rows and 3 columns. The third column can
either have two entries: No and Yes. Basically, I want to extract all rows
where the third columd is Yes.

Thanks for the help