Microsoft Office Tutorials and References
In Depth Information
Filter for Above or Below Average
Values: Click Number Filters and choose
Above Average or Below Average to filter by
numbers that meet either condition. In
Figure 11-38, only the records with Ratings
above the total average appear.
Filtering for number types.
Filtering for average values.
Filter for Top or Bottom Numbers: Click
Number Filters and choose Top 10. In
Figure 11-37, you see the Top 10 AutoFilter
dialog box. Select whether you want the
Top (highest) or Bottom (lowest) values and,
in the second option, select the number of
items you want to see (from 1 to 500). In
the third option, select whether you want
to filter the items by their names or by their
percentiles. For example, choose to list the
top 10 customers per their sales dollars, or
list the top 10% of your customer base.
Click OK. Excel displays the records that
match your criteria.
Filtering by Date or Time
Another filter option is to filter by date or time. By
default, dates in the database are grouped by years,
months, and days, in that order. Excel includes two
types of date filters: Common and Dynamic.
Common filters are those based on comparison
operators such as Equal To, Greater Than, Less
Than, or Between. Dynamic filters are those for
which the criteria can change when you reapply
the filter. They include Today, Tomorrow, Next
Month, Last Year, and Year-to-Date. Look at the
steps needed to filter by a date or a time:
Click the filter arrow for the date column by
which you want to filter data and choose
Date Filters (see Figure 11-39).
Filtering for top or bottom values.