Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set. Advanced Filter in Excel to create a list of unique items, or to extract specific items to a different worksheet. You can also use complex criteria with an Advanced Filter, so it is useful when a simple AutoFilter can’t do what you need.
Here are the steps for setting up your data, and creating an Advanced Filter. — Set up the database — Set up the Criteria Range (optional) — Set up the Extract Range (optional) — Apply the Excel Advanced Filter