1-866-245-5224 sales@keystonelearning.com

Excel 2003: Advanced Filter Using Multiple Criteria

Excel 2003: Advanced Filter Using Multiple Criteria

Filtering your list with multiple criteria really isn’t a whole lot different from using single criteria. Here’s what you need to remember:

     
  • To create an AND criteria, put your criteria on the SAME row
     

     
  • To create an OR criteria, put your criteria on SEPARATE rows

Using the Advanced Filter with Multiple Criteria

     
  1. Create your criteria field in an area well to the right of or below your existing list
     
  2.  
  3. Click anywhere inside your list
     
  4.  
  5. Choose Data: Filter: Advanced Filter… from the Menu bar
     
  6.  
  7. Choose to Filter the list in-place or Copy to another location
     
  8.  
  9. Verify the List range
     
  10.  
  11. Enter the Criteria range
     
  12.  
  13. If you are copying the data to another location, enter the starting cell of the copied list location
     
  14.  
  15. Click OK
     

Clearing Filter Criteria

     
  1. Click anywhere inside a filtered list
     
  2.  
  3. Choose Data: Filter: Show All from the Menu bar