Filtering
Sean wants to know the names of all the students who have received a mark of less than 80 in English, Math, and Physics and also those who got more than 95 in Chemistry. He makes use of the filtering feature.
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. Microsoft Excel provides two commands for filtering ranges.
1. AutoFilter, which includes filter by selection for simple criteria
2. Advanced Filter, for more complex criteria
Unlike sorting, filtering does not rearrange a range. Filtering temporarily hides rows you do not want displayed. When Excel filters rows, you can edit, format, chart, and print your range subset without rearranging or moving it.
AutoFilter
When you use the AutoFilter command, AutoFilter arrows appear to the right of the column labels in the filtered range.
You use custom AutoFilter to display rows that contain either one value or another. You can also use custom AutoFilter to display rows that meet more than one condition for a column. For example, you might display rows that contain values within a specific range.
Advanced Filter
The Advanced Filter command can filter a range in place like the AutoFilter command, but it does not display drop-down lists for the columns. Instead, you type the criteria of the filter in a separate criteria range above the range. A criteria range allows for more complex criteria to be filtered. A criteria is a set of conditions that limit which records are included in the result set of a query or filter.
