Microsoft Office Tutorials and References
In Depth Information
When you point to Text Filters and then click Custom Filter, you can define a rule that Excel
uses to decide which rows to show after the filter is applied. For instance, you can create a
rule that determines that only days with package volumes of less than 100,000 should be
shown in your worksheet. With those results in front of you, you might be able to
determine whether the weather or another factor resulted in slower business on those days.
Excel indicates that a column has a filter applied by changing the appearance of the
column’s filter arrow to include an icon that looks like a funnel. After you finish examining
your data by using a filter, you can remove the filter by clicking the column’s filter arrow
and then clicking Clear Filter. To turn off filtering entirely and remove the filter arrows,
display the Home tab and then, in the Editing group, click Sort & Filter and then click Filter.
In this exercise, you’ll filter worksheet data by using a series of AutoFilter commands,
create a filter showing the five days with the highest delivery exception counts in a
month, create a search filter, and create a custom filter.
SET UP You need the PackageExceptions_start workbook located in your
Chapter05 practice file folder to complete this exercise. Start Excel, open the
PackageExceptions_start workbook, and save it as PackageExceptions . Then follow
1. On the ByRoute worksheet, click any cell in the cell range B2:F27 .