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