Advanced filters

Hi Carol, Thank you for your post, welcome to the forum, in answer to your question headed Advanced Filters, Filtering a database enables you to find and work with a subset of the data. Filtering displays only the rows that contain a certain value or that meet a set of criteria whilst hiding other rows. Excel provides the AutoFilter and the Advanced Filter commands to filter your data.
AutoFilter meets most needs.
However when you need to use complex criteria to filter a list or copy data elsewhere, use Advanced Filter.
For best results your list should have column labels.
When you require filtering meeting specific needs; for example; a Custom AutoFilter could be used to display records that contain either one value or another. A Custom AutoFilter could also be used to display records that meet more than one condition for a column, such as records that contain values within a specific range (such as values between 25 and 100).
The Advanced Filter command enables you to find rows using more complex criteria, as well as extracting information to a different location (rather than filtering in place), Before using Advanced Filter, you must set up a separate criteria range and enter the criteria required. The resulting filtered information will display in the same format as the original data.
To activate the Advanced Filter command: On the Data ribbon locate the Sort and Filter section, Click Advanced, From the dialog box, select your original data range, your Criteria range and finally the first cell of the range where you wish your filtered data to appear. I know this has been a fairly long answer to your question, but I felt it was necessary to cover the subject. If you are happy with the answer, please click the Resolved Link.
I hope it has helped. best regards Pete.