To filter Excel with multiple conditions, combine criteria such as a date range, a status, and a minimum value so the results show only the rows you need.
This guide explains how to set up those filters with Excel’s built-in tools and the FILTER function, including how AND and OR logic change the result.
What counts as multiple conditions in Excel?
A condition is a rule that a row must satisfy to appear in filtered results.
For example, a sales report might show orders where the region is East and the total is at least $500.
A second example might show orders from East or West.
The first uses AND logic; the second uses OR logic.
Excel’s column filters apply conditions across fields together.
When you filter the Region column to East and the Amount column to values greater than or equal to 500, a row must meet both rules.
Within one column, you can select several values, such as East and West, which acts like OR.
Use Excel’s built-in filters
For a quick interactive filter, organize the data as a table or a range with one header row and no blank rows or columns inside it.
Click a cell in the dataset, then choose Data > Filter.
Excel adds a drop-down arrow to each header.
- Open the drop-down for the first column, such as Region, and select the values to keep.
- Open another column’s drop-down, such as Amount, and choose a number filter like Greater Than Or Equal To.
- Enter the threshold and apply the filter.
Excel displays rows that satisfy the active filters together.
For text, date, and number columns, the filter menu offers different options.
Text filters can match a phrase or prefix; date filters can target ranges such as this month; number filters can compare values or select items above an average.
You can clear one column’s filter without clearing the others.
Apply two conditions within one column
To keep values between 100 and 500 in the same numeric column, select Number Filters > Between and enter both limits.
For a custom combination, use Number Filters > Custom Filter, select the first comparison, and choose And or Or before entering the second comparison.
Use And when both conditions must be true, such as Amount greater than or equal to 100 and less than or equal to 500.
Use Or when either condition is enough, such as Amount less than 100 or greater than 500.
The menu labels and layout can vary slightly between Excel desktop, web, and Mac versions.
Filter with the FILTER function
In Microsoft 365, Excel for the web, and Excel 2021 or later, the FILTER function returns matching rows in a separate area of the worksheet.
It is useful when you want results to update as the source data changes.
Suppose A2:C6 contains Region, Product, and Amount, with headers in row 1.
To return rows where the region is East and the amount is at least 500, enter:
=FILTER(A2:C6,(A2:A6="East")*(C2:C6>=500),"No matches")
The multiplication sign combines the tests as AND: both tests must be true for a row to be included.
In this sample data, a row with East and 650 appears; a row with East and 300 or West and 650 does not.
To return rows where the region is East or West, use addition for OR logic:
=FILTER(A2:C6,(A2:A6="East")+(A2:A6="West"),"No matches")
For a combination of OR within one test and AND with another, group the OR tests with parentheses.
This example returns orders from either East or West when the amount is at least 500:
=FILTER(A2:C6,((A2:A6="East")+(A2:A6="West"))*(C2:C6>=500),"No matches")
The third argument, "No matches", supplies a message when no rows meet the conditions.
If you omit it, FILTER returns a #CALC! error when there are no results.
Keep the destination cells clear because FILTER spills its results into adjacent cells; blocked spill areas can produce a #SPILL! error.
Filter by a date range and another condition
Dates in Excel are stored as serial numbers, so comparisons work when the source cells contain real Excel dates rather than text that only looks like a date.
If A2:A100 contains order dates and C2:C100 contains amounts, return orders from January 2026 with amounts of at least 500:
=FILTER(A2:C100,(A2:A100>=DATE(2026,1,1))*(A2:A100<DATE(2026,2,1))*(C2:C100>=500),"No matches")
This uses an inclusive start and an exclusive end.
That pattern also includes timestamps on January 31, if the cells contain times as well as dates.
Replace the date boundaries to target a different month.
The formula uses commas as argument separators; some regional settings require semicolons instead.
Common problems and compatibility notes
- FILTER returns #VALUE!: The source range and each condition range must have matching row counts.
For example, use A2:C100 with A2:A100, not a criteria range ending on a different row. - Results include unexpected rows: Check whether the condition uses multiplication for AND or addition for OR.
Confirm that numbers are stored as numbers and dates as dates, not text. - Dropdown filters behave oddly: Check for blank headers, merged cells, or blank rows splitting the dataset.
Converting the range to an Excel Table with Ctrl+T can make the data easier to manage as it grows. - FILTER is unavailable: Excel 2019 and earlier do not support the dynamic-array FILTER function.
Use the built-in Data filters, Advanced Filter, or a helper column instead.
For a helper-column approach, add a formula beside the source data that evaluates each row’s conditions, then filter the helper column for TRUE.
For example, if Region is in A and Amount is in C, enter =AND(A2="East",C2>=500) in the first data row and fill it down.
This works in older Excel versions and makes the row-by-row logic visible.