advanced filter a range
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
|