Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 61

To create an Or condition with the Advanced Filter:

1 Delete the criteria in cell C17.

2 Enter the criterion < 5 7500 in cell C18.

3 Once again, click the Advanced button from the Sort & Filter group

on the Data tab to open the Advanced Filter dialog box.

4 Enter the cell range A11:D11 into the List range box.

5 Change the cell reference in the Criteria range box to B16:C18 to

refl ect the changes you made to the criteria.

6 Click OK.

Excel now displays Stations 0, 1, 2, 4, 5, 6, and 9. Each station has

gas sales < $8,500 or sales of other items < 5 $7,500. See Figure 2-20.

7 To view all stations again, click the Clear button from the Sort &

Filter group on the Data tab.

Figure 2-20
Filtering
data using
an Or
condition

criteria specifying

gas sales < $8500

or

Other sales <= $7500