How to Match Multiple Criteria in Excel 2007

With the Microsoft Office Excel 2007 program, you can add a table of data into a spreadsheet and then filter the data to appear in a way that meets your criteria. Using the "Sort and Filter" features, you can establish criteria, such as text criteria or numbers. You can make only data with the same name appear listed together, or make sure only numbers less than a certain value are shown. Using the "Custom AutoFilter" dialog box, you can also match multiple criteria to keep two fields in the same row.

Instructions

1. Open the Microsoft Excel 2007 file on your computer that contains the data you want to filter and match multiple criteria.

2. Select any cell within your table and then click the "Home" tab. Click the "Sort and Filter" option from the "Editing" group.

3. Click the "Filter" option and then select the down arrow next to the column for which you want to match multiple criteria.

4. Click the "Text Filters" option and then click the "Custom Filter" option. The "Custom AutoFilter" dialog box will then appear.

5. Select criteria for the filter in the top drop-down box. Click the "And" option to match to conditions and then select the second criteria from the drop-down list.

6. Click "OK" and the criteria you selected will be matched and filtered.

References

• University of Wisconsin-Eau Claire: Microsoft Excel 2007 Filtering Your Table
• Microsoft Office: Filter by Using Advanced Criteria
• University of Wisconsin-Eau Claire: Microsoft Outlook 2007 Establishing Criteria Calendar Working with Holidays