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)
Filter
This function identifies data in the selected column, which satisfies two specified criteria. The criteria 'greater than', 'less than', 'equals' etc. are used for numeric fields and 'contains sequence' and 'equals' for text fields.
Example:
Price: not more than $100 and not less than $85
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 | 100 | 500 | |
| 5 | |||
| 6 |
learn more
We want you to find this page by the following keywords:
excel data filter, autofilter excel, filter data in excel, how to filter data in excel, access filter data, vba filter data, enable data filter in excel, data filtering, filter table data, filtering an excel database, advanced filter
how it works:
load file(s)
open Function Wizard
choose Filter function
specify file number
select the column for processing
specify selection criteria
press Run button to get the results
load file(s)
open Function Wizard
choose Filter function
specify file number
select the column for processing
specify selection criteria
press Run button to get the results
