The AutoFilter feature in Excel allows you to select only one specific value. However, you may at times want to search for records that meet multiple criteria. For instance, you may want to list products that are greater than $20 or display only dates that fall between a specific date range. Using the Custom AutoFilter dialog box, you can create complex criteria using comparison operators such as:
- Equals/does not equal
- Is greater than/is less than
- Is greater than or equal to
- Is less than or equal to
- Begins with/does not begin with
- Ends with/does not end with
- Contains/does not contain
You can also combine multiple criteria for a single column by using the logical operator AND or the logical operator OR. For example, you may wish to display products that are greater than $20 and less and $50.
To Create a Custom Filter
- Activate any cell in your list area.
- Click the arrow next to the field name to which you want to apply a filter.
- Point to the Filter type (Text Filters, Number Filters, Date Filters) to display a menu of comparison operators
Point to the Filter type and choose Custom Filter.
- Click the leftmost combo box and choose the desired comparison operator from the list.
- Click the rightmost combo box and type in your criteria.
- To enter multiple criteria, click the AND or the OR radio button and repeat steps 4 and 5 for the next row.
- Click OK when finished.
- Using Conditional Formatting in Excel 2007
- Using AutoFilter in Excel 2007
- Using Search Folders in Outlook 2010
- Create a Parameter Query in Access
- Using Conditional Formatting based on Top/Bottom Values in Excel 2007
- Prompting for Dates in a Parameter Query in Access
- Create a Custom PowerPoint Presentation