Page 67 - Excel Data Analysis

04 537547 Ch03.qxd 3/4/03 11:50 AM Page 53

EVALUATE WORKSHEET DATA 3

You type all advanced filter The placement of the criteria determines how Excel compares
definitions into the worksheet them. Excel uses the AND operator to join filter criteria in the
before you select the Advanced same row, and the OR operator for criteria in separate rows.
Filter option. How you do so is For example, Excel interprets the following filter definition as
critical to how Excel interprets "Month equals January and Region equals East OR Month
the definition. Each filter equals February and Region equals West."
definition consists of at least
two rows. The first row contains Example
the column headings of the Month Region
columns you want to filter. Each January East
successive row defines the filter February West
criteria. For example, to find the You can also use the comparison operators in your filter
sales for January in the East definitions: =, >, <, >=, <=,or <>. For example, to find all
region type: sales for January greater than $50,000, you type:

Example Example
Month Region Month Amount
January East January >$50,000

■ The Advanced Filter ■ You can also click the ■ Excel filters the list by
dialog box displays with the Collapse Dialog buttons to hiding the records that do
selected range in the List select the range of cells. not match the criteria.
range field.
Á Click OK.
ˇ Type the filter criteria
range in the Criteria range
field.
53