Microsoft Office Tutorials and References
In Depth Information
With advanced filtering, you can go beyond the
limitations of the AutoFilter command discussed in
Task #41. With advanced filtering, you can create
two or more filters and easily coordinate a set of
filters between columns. For example, you can filter
a survey to find people age 30 or younger who are
male and people age 60 or older who are female.
Advanced filtering requires a bit of work, even when
you use the Advanced Filter menu command. You
must find a block of cells on the worksheet and
create a criteria range. Use one or more column
heads from a list. In the cell below each head, type
criteria by which to filter each column, such as
<=35, to find people 35 and under and = “=M” to
find all males.
Using the Advanced Filter dialog box, you specify the
cell addresses of the entire list, the criteria range,
and a location for the filtered list. The filtered list
must be on the same worksheet as the original list.
On the worksheet with your list,
type the column head names of
the columns you want to filter.
Type criteria by which you want
to filter values.
Note: Use operators to define
criteria and place text in quotes.
For example, to find all males,
type = “=M” ; Excel will display
Click the Data tab.