Excel's Advanced Filter allows you to filter data based on specific criteria set in a separate range. Here's how to use it:

1. Define your data and criteria:

- Ensure your data is organized in a table format (recommended for easier filtering).
- In a separate area of your worksheet, create a table with headers matching your data table's column names. This will be your criteria range.
- In each row of the criteria range, specify the filtering conditions for the corresponding column. You can use various operators like:
- Equal to (=)
- Not equal to (<>)
- Greater than (>), Less than (<)
- Greater than or equal to (>=), Less than or equal to (<=)
- Text filters like "Begins with," "Contains," "Ends with," wildcards (* and ?)

2. Access the Advanced Filter:

- Click anywhere within your data table.
- Go to the "Data" tab on the Excel ribbon.
- In the "Sort & Filter" group, click "Advanced" (This might be under a dropdown menu with "Sort" in Excel versions before 2016).

3. Set up the filter options:

- In the "Advanced Filter" dialog box, choose one of the following actions:
- Copy to another location: This will filter your data and copy the resulting rows to a new location you specify.
- Filter the list, in-place: This will filter your data directly within the existing table, hiding rows that don't meet the criteria.

4. Define the ranges:

- List range: Click in the "List range" box and select your entire data table (including headers).
- Criteria range: Click in the "Criteria range" box and select the table containing your custom criteria (including headers).

5. Copy filtered data (optional):

- If you chose "Copy to another location" in step 3, click in the "Copy to" box and select the top-left cell of the destination area where you want the filtered results to appear.

6. Apply the filter:

- Click "OK" to run the advanced filter based on your defined criteria.

Tips:

- You can use multiple rows in the criteria range to define complex filtering logic. Each row will act as a separate filter condition.
- Advanced Filter offers options like "Copy unique records only" within the "Copy to another location" action.

By following these steps, you can leverage Excel's advanced filtering capabilities to extract specific data based on your custom criteria.