microsoft-excel-training - Filtering

Hi Sinead,

To use the Advacned Filter, you must set aside a Criteria Table either on the same or different worksheet.

• 1. Click on your data table
  
• 2. DATA menu > FILTER > ADVANCED FILTER
  
• 3. Confirm list range as your data table range
  
• 4. Set Criteria Range as the criteria table (incl. headings)
  
• 5. Press OK