Filord was designed to save your (we mean Your) time and effort on Excel® tasks. Find unique and duplicate values, reverse order of rows, get subtotals and more. Free installation, seven built in functions, no learning and skills required – get the result by
Download Version 1.0 free of charge. (1.5 Mb)
Multi-Filter
This function allows you to filter a range of data using two criteria. Specify conditions for each of two columns, that's it. Please see the example below.
Example:
Price: not more than $100
Standard: not less than 585
Initial table:
| A | B | C | |
| 1 | Price $ | Standard | |
| 2 | 80 | 475 | |
| 3 | 95 | 585 | |
| 4 | 150 | 585 | |
| 5 | 100 | 990 | |
| 6 | 100 | 500 |
Output table:
| A | B | C | |
| 1 | Price | Standard | |
| 2 | 95 | 585 | |
| 3 | 100 | 990 | |
| 4 | |||
| 5 | |||
| 6 |
learn more
We want you to find this page by the following keywords:
multiple filter in Excel, excel autofilter multiple, advanced filter excel, multiple conditions if, two conditions excel
how it works:
load file(s)
open Function Wizard
choose Multi-Filter function
specify file number
specify selection criteria for first and for second column
press Run button to get the results
load file(s)
open Function Wizard
choose Multi-Filter function
specify file number
specify selection criteria for first and for second column
press Run button to get the results
