Microsoft Office Tutorials and References
In Depth Information
Below and Above Average
FIGURE 22.3 Filter by Date
FIGURE 22.4 Filter All Values Above the Average
BELOW AND ABOVE AVERAGE
These are very much self-explanatory: to filter by numbers above the average, click
Above Average; to filter by numbers that are below the average, click Below Average.
The important thing to note is that Excel will calculate by itself the average of your
values list; you do not need to fill in this value anywhere in the sheet. See Figure 22.4.
You may want to reapply/refresh a filter after you make changes in the data.
Click any cell in the range or table, and then click Reapply on the Data ribbon, in the
Sort & Filter group.
FILTER BY COLOR
If you formatted a range of cells manually or by conditional formatting, you can also
filter the data by formatted colors. It is also possible to filter by an icon set created
through a conditional format.