Microsoft Office Tutorials and References
In Depth Information
Filter by
MULTIPLE CRITERIA
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.
1
On the worksheet with your list,
type the column head names of
the columns you want to filter.
1
2
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
=M.
2
3
Click the Data tab.
3
4
Click Advanced.
4
94
Search JabSto ::




Custom Search