Microsoft Office Tutorials and References
In Depth Information
Figure 9-16: This real estate listing table is used to demonstrate advanced filtering.
This workbook, named real estate list.xlsx, is available at this book's website.
Setting up a criteria range
Before you can use the advanced filtering feature, you must set up a criteria range, which is a range on a work-
sheet that conforms to certain requirements. The criteria range holds the information that Excel uses to filter the
table. The criteria range must conform to the following specifications:
• It must consist of at least two rows, and the first row must contain some or all of the column names from the
table. An exception to this is when you use computed criteria. Computed criteria can use an empty Header
cell. (See the “Specifying computed criteria” section, later in this chapter.)
• The other rows of the criteria range contain your filtering criteria.