Page 626 - Excel 2013 All-in-One For Dummies

608 Filtering Data
✦ Above Average: Filters the data list to display only records where the values in the field are greater than the average of the values in this field.
✦ Below Average: Filters the data list to display only records where the values in the field are less than the average of the values in this field.
✦ Custom Filter: Opens the Custom AutoFilter dialog box where you can select your own criteria for more complex AND or OR conditions.
Making it to the Top Ten!
The Top Ten option on the Number Filters option’s submenu enables you to filter out all records except those whose entries in that field are at the top or bottom of the list by a certain number (10 by default) or in a certain top or bottom percent (10 by default). Of course, you can only use the Top Ten item in numerical fields and date fields; this kind of filtering doesn’t make any sense when you’re dealing with entries in a text field.
When you click the Top Ten option on the Number Filters option’s submenu, Excel opens the Top 10 AutoFilter dialog box where you can specify your fil- tering criteria. By default, the Top 10 AutoFilter dialog box is set to filter out all records except those whose entries are among the top ten items in the field by selecting Top in the drop-down list box on the left, 10 in the middle combo box, and Items in the drop-down list box on the right. If you want
to use these default criteria, you simply click OK in the Top 10 AutoFilter dialog box.
Figure 2-2 shows you the sample employee data list after using the Top 10 Items AutoFilter to display only the records with the top ten salaries in the data list.
Figure 2-2:
Using the Top 10 Items AutoFilter
to filter out all records except for those with the top ten salaries.