How to Filter Numbers by Multiple Criteria in Excel: 3 Easy Methods

Filtering numbers in Excel is easy when you only need one simple condition. But when you need to filter numeric data by multiple criteria, especially across different columns, the task becomes much less convenient. In this guide, you will learn 3 practical ways to filter numbers by multiple criteria in Excel, from quick built-in filters to a more visual method with Kutools, and finally Excel’s Advanced Filter for users who prefer a built-in but more complex approach.

• Why filter numbers by multiple criteria in Excel
• Method 1: Filter numbers with Excel built-in filters (fast for simple tasks)
• Method 2: Filter numbers by multiple criteria with Kutools Super Filter (faster and easier for complex criteria)
• Method 3: Filter numbers with Excel Advanced Filter (powerful but more complex)
• Excel built-in filters vs. Kutools vs. Advanced Filter
• Frequently asked questions

Why filter numbers by multiple criteria in Excel

Excel’s standard Number Filters work well for simple tasks such as filtering values greater than, less than, or between certain numbers in one column. However, real worksheets often require more than that. You may need to find rows where Sales > 5000 and Profit < 15%, or where Quantity is between 10 and 50 in one column while Discount is above 20% in another. In these cases, basic filtering quickly feels limited.

That is why users often look for better ways to filter numeric data by multiple criteria. Depending on your needs, you can use Excel’s built-in filters for quick tasks, Kutools Super Filter for a more visual and flexible setup, or Excel Advanced Filter when you want a built-in solution for more complex criteria.

Method 1: Filter numbers with Excel built-in filters

Excel’s built-in Number Filters are a practical option when you need to filter numbers within a single column. They can handle conditions such as greater than, less than, between, and even two criteria combined with And or Or.

For example: if your worksheet contains a Sales column and you want to show only rows where the sales amount is greater than 1000 and less than 1200, you can use Excel’s built-in filter with two conditions in the same column.

1. Select any cell in your data range.

2. Go to the Data tab and click Filter.

3. Click the filter drop-down arrow in the Sales column.

4. Choose Number Filters > Custom Filter.

5. In the Custom AutoFilter dialog box, set the first condition to is greater than 1000, select And, then set the second condition to is less than 1200. Click OK.

Result: Excel shows only the rows where the Sales value is greater than 1000 and less than 1200.

Method 2: Filter numbers by multiple criteria with Kutools Super Filter

If you need to filter numbers by multiple criteria more easily, Kutools for Excel’s Super Filter is a more practical option for most users. Instead of working with one column at a time or setting up a separate criteria range, you can build your filtering logic visually in a side pane.

This is especially useful when you need to handle more advanced numeric conditions, such as:

• Sales > 5000 and Profit < 15%
• Quantity between 10 and 50 and Discount < 10%
• (Sales > 5000 and Profit < 15%) or (Discount > 20% and Quantity < 30)

For example: if you want to show rows where Sales > 5000 and Profit < 15%, or where Discount > 20% and Quantity < 30, Super Filter makes this grouped multi-column filtering much easier to build and adjust.

1. Click Kutools Plus > Super Filter.

2. In the Super Filter pane, please do the following:

1. Check the Specified range option and select the range that you want to filter.
2. In the Relationship drop down list, choose the OR relationship.
3. Create multiple criteria as you need. And you can click Add Filter to add more new condition group.
   • Create the first condition group with And: set Sales > 5000 and Profit < 15.
   • Add another condition group and set it to And: Discount > 20 and Quantity < 30.
4. Click Filter to filter the data.
   

Result: Only the rows that match either of the two numeric condition groups are displayed.

Method 3: Filter numbers with Excel Advanced Filter

Excel’s Advanced Filter is a built-in option for filtering numbers by multiple criteria across columns. It can handle more complex logic than standard Number Filters, including multiple fields and And / Or relationships. However, unlike Kutools Super Filter, it requires a separate criteria range, which makes the setup less intuitive.

For example: you may want to show rows where Sales > 5500 and Profit < 15%, or where Discount > 25% and Quantity < 30. Advanced Filter can do this, but you first need to build the criteria layout manually in the worksheet.

1. In a blank area of the worksheet, create a criteria range.

1. Enter the same column headers used in your source data, such as Sales, Profit, Discount, and Quantity.
2. Under those headers, enter your criteria. Put conditions on the same row for And logic, and on different rows for Or logic.
   

2. Click any cell in your source data, then go to the Data tab and click Advanced.

3. In the Advanced Filter dialog box,

1. Choose Filter the list, in place or Copy to another location as Action .
2. Set the List range to your source data range.
3. Set the Criteria range to the cells containing your manually created criteria.
4. Click OK.
   

Result: Excel filters the rows based on the criteria range you created.

Excel built-in filters vs. Kutools vs. Advanced Filter

If you only need quick filtering in one column, Excel’s built-in filters are enough. If you want a built-in method for more complex criteria, Advanced Filter can do the job. But if you need a faster and more visual way to handle multi-column numeric rules, grouped logic, and repeated filtering tasks, Kutools Super Filter is usually the more practical choice.

Frequently asked questions

Can Excel filter numbers by multiple criteria without Kutools?

Yes. You can use Excel’s built-in filters for simple number conditions, and Excel Advanced Filter for more complex multiple criteria. However, Advanced Filter needs a separate criteria range and is not as visual or convenient as Kutools Super Filter.

What is the easiest way to filter numbers by multiple criteria in Excel?

For most users, Kutools Super Filter is easier because it lets you build multiple conditions visually instead of manually creating a criteria range.

Can I filter numbers across multiple columns in Excel?

Yes. Both Kutools Super Filter and Excel Advanced Filter can handle multiple criteria across different columns. Excel’s basic Number Filters are more suitable for simpler filtering in one column at a time.

When should I use Excel Advanced Filter instead of normal filters?

You should use Advanced Filter when you need more complex filtering logic, such as multiple conditions across columns or mixed AND / OR logic, and you want to stay within Excel’s built-in tools.

Is Kutools Super Filter only for numbers?

No. Super Filter can also work with other types of conditions, but it becomes especially useful when your numeric filtering rules are too complex for Excel’s normal Number Filters to handle conveniently.