Microsoft Office Tutorials and References
In Depth Information
Exploring Special Filters
Table 8-1 Custom AutoFilter Options for Values
Filter
Sample Criteria
Records Displayed
Equals
3.25
Students with a GPA equal to 3.25
Does Not Equal
4.00
Students with a GPA not equal to 4.00, including
any students above or below 4.00
Greater Than
4.00
Students with a GPA higher than 4.00
Greater Than or Equal To
3.50
Students with a GPA of 3.50 or higher
Less Than
3.50
Students with a GPA lower than 3.50
Less Than or Equal To
3.50
Students with a GPA of 3.50 or lower
Between
3.00 and 4.00
Students with a GPA of 3.00, 4.00, and those in
between
Top 10
Students with the highest (Top) or lowest (Bottom)
GPA
Above Average
Students with a GPA higher than the average GPA
for the database as a whole
Below Average
Students with a GPA lower than the average GPA
for the database as a whole
Filtering by Date
Excel provides two types of date filters: common
and dynamic. Common filters use the same sort
of comparison filters as the number filters do
(for example, Equal To, Greater Than). Regardless
of the date on which you perform the filter, your
filtered results will look the same. For instance,
if there are three records that are equal to
January 10 today, there will be three records
equal to January 10 tomorrow (provided no one
changes your data).
3. Enter your specific criteria in the resulting
dialog box (see Figure 8-17) and click OK to
apply the filter.
Figure 8-17
Each numbered filter can be further
customized in a dialog box.
 
Search JabSto ::




Custom Search