Advanced Filters

Hi Sarah,

Thank you for your question and welcome to the forum.

It sounds like most of the steps are correct. I have outlined below the steps needed.

1. When you name the data list range you must include the headings.

2. Create a Crtiteria table by copying the headings to another part of the spreadsheet.

3. Put the relevant criteria under each heading using the other rows below if needed as OR criteria.

4. Click into the main data list and open the Advanced filter box.

5. Type the name of the range in the List Range box.

6. Click into the Criteria Range box and highlight the headings and the row or rows of criteria.

The important thing about advanced filtering is you must include the headings in both the list and criteria range.

I hope this answers your questions.

Regards

Simon