Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 57

Excel opens the Custom AutoFilter dialog box. From this dialog box

you can specify the criteria used to fi lter the values in the data list.

3 Type 8500 in the input box as shown in Figure 2-17.

Figure 2-16
Filtering
data values

Autofill drop-down arrows

Figure 2-17
Creating a
filter for
gas sales
less than
$8,500