Page 21 - Computer - 7

Knowledge Discovery Subject Enrichment

Filter feature works well if you have headings for your data.

Custom Filtering
Custom Filter helps you filter data based on specific conditions on values in cell range. 2
To apply Custom Filter:

1. Click a cell in the range that you want to
filter.
2. Click the filter control of the column heading
on which you want to specify the filter
condition.
The Filter menu appears.

1

3. Point to the Number Filters or Text Filters option
and select one of the predefined conditions, or
Customised Filter... from the sub-menu that appears.
The Custom Auto-filter dialog box opens.
3
4

4. Under Show rows where, select a filter condition, from the
first list box and specify the desired value in the second list
box.
5. Click the OK button.
Excel filters the selected data as per the specified filter
condition.
5

Knowledge Discovery Subject Enrichment

To filter data on two conditions, enter filter conditions in both sets of boxes, and select:
• the And option, for both conditions to be true.
• the Or option, for either of the conditions to be true.

19