Advanced Filtering in Excel allows you to filter data based on complex criteria using logical operators like "OR" and "AND". Here's how:

1. Setting Up Criteria:

- You'll need to define your criteria in a separate area of your worksheet. This is typically a few rows above your data table.
- In the first column of your criteria range, enter the header names matching your data table columns.

2. Using OR Logic:

- To find rows where either condition is met, use the OR operator.
- In the corresponding cells under the desired column headers, enter your criteria for the OR condition.
- For example, you might want to filter for rows where the product category is "Electronics" OR the price is greater than $100.
- You can use text like "Electronics" or formulas like ">100" (without quotes) depending on your criteria.

3. Using AND Logic:

- To find rows where both conditions are met, use the AND operator.
- Same Column: If both conditions apply to the same column, enter them in the same cell separated by a space. For instance, "Fruits Vegetables" would filter for items that are both fruits and vegetables (unlikely scenario, but demonstrates the format).
- Different Columns: If conditions apply to different columns, enter them in separate rows under their respective column headers. Excel will automatically perform an AND operation when using multiple rows for filtering.

4. Applying the Filter:

- With your criteria defined, select your data table.
- Go to the "Data" tab and click "Advanced" in the "Sort & Filter" group.
- Choose "Copy to another location" if you want to filter the data to a new location or "Filter the list, in-place" to modify the existing data table.
- Define the "List range" as your data table.
- Define the "Criteria range" as the area containing your criteria with OR or AND logic.
- Click "OK" to apply the filter.

By using "OR" and "AND" logic in your criteria range, you can significantly refine your filtering process and find specific data sets that meet your complex requirements.