Microsoft Office Tutorials and References
In Depth Information
Managing Large Amounts of Data
Follow the instructions from the previous
section “Choosing Text Comparison Filters.”
Reviewing Other Filter Options
Still need more filter options? Excel has plenty of
others. You can filter comparison by numbers. For
example, you can show the customers who have
purchased more than 1,000 units but less than
2,000 units. Filtering by the top ten allows you to
show the 10 best (or the 10 worst) territories. Or,
you can use filters to display only the employees
with the above average work ratings.
2. Select the And or the Or option.
3. From the drop-down menu, select a second
4. Enter the second comparison filter value.
Figure 11-35 shows an example.
5. Click OK to display the filtered records.
Click the filter arrow by which you want to filter
and then choose one of the following:
Filter for Numbers: Click the filter arrow
for the numeric column by which you want
to filter data, and then choose Number
Filters. A submenu of comparison filters
appears. Some of the choices include
Equals, Does not Equal, Greater Than,
Greater Than or Equal To, Less Than, Less
Than or Equal To, and Between (see Figure
11-36). Select the comparison filter you
want to use and Excel displays the Custom
AutoFilter dialog box. Enter your filter
criteria and then click OK.
Choosing a comparison filter.
If you need to locate cells that share some of
the characters you entered but not others,
you can use a wildcard character. Entering
one or more question marks finds single
characters and entering an asterisk finds any
number of characters. For example, if you
enter Bos???, you would find Boston, Bosnia,
Bosart, and Boshel—any word that begins
with Bos but has only six characters.