Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

Now, it is time to use the advanced filter in Excel to filter the data. First, click any cell on your original dataset, click the “Data” tab, and click the “Advanced” button.

I’ll show you how to use Excel’s Advanced Filter feature to return a filtered set based on two columns of criteria. Then, I’ll show you how to limit the filtered set to only those two columns.

The Excel AutoFilter feature allows you to narrow your data based on certain criteria and extract records that match those criteria. To turn on a filter, select the cells with data that you want to ...

In Excel 2003, choose Filter from the Data menu and then select Advanced Filter. The feature defaults to filtering in-place; don’t change that option for this example.

You can ask Excel to filter or sort data by clicking on the Filter funnel under the Data tab. If you want to filter data by more than one criteria, choose the Advanced Filter option.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.