Page 66 - Excel Data Analysis

04 537547 Ch03.qxd 3/4/03 11:50 AM Page 52

EXCEL DATA ANALYSIS

CREATE AN ADVANCED FILTER

ou can filter your data to include a combination of In the Advanced Filter dialog box, you specify a range of cells
values from multiple columns using the Advanced containing the filter definition in the Criteria range field, and
Y Filter. This filter is more complex than the Custom the cell containing your comparison operator. You also have
AutoFilter, illustrated in the section "Create a Custom the option of placing the filtered records either back in the
Filter," because your filter is no longer limited to one original location or in another location within the same
column of data. Although you can create larger filter worksheet. If you select the former option, Excel hides the
definitions with this feature, you may find the definitions records that do not meet the specified filter criteria. If you
more confusing to use because you create them manually. opt for a new location, Excel copies the data that matches
the filter criteria and places it in the new worksheet location.
Before you apply the Advanced Filter, you must enter a filter
definition in your worksheet. The definition consists of a When you apply the advanced filter definition, Excel
row of headings for the filter definition, as well as the displays all records that match the criteria — even
criteria for the filter. You can place the filter definition in duplicated records. You can select the Unique Records Only
either the same worksheet as the records you want to filter, option to eliminate the duplicate records, but if you do so,
or in another worksheet altogether. Wherever you place it, Excel does not tell you which records are duplicated. If you
you want to enter it in a cell that is not readily visible on the want a total of the number of records that match the
worksheet. criteria, avoid selecting this option.

CREATE AN ADVANCED FILTER

⁄ Type column headings ¤ Type filter definition. ‹ Select a range of cells to › Click Data ➪ Filter ➪
for filter definition in a filter. Advanced Filter.
worksheet.

52