CLASS OBJECTIVE
Apply Sorting and Filters with multiple criteria, to achieve greater precision in the organization and location of the information.
HOW TO ESTABLISH MORE THAN ONE SORTING CRITERIA
When sorting a table it is possible to use more than one criteria to arrange the records. This is very common when the data in a table is constantly repeating.
A very common example is the ordering of a school list, in which surnames are the main criteria but some of these are obviously repeated, such as García or Hernández. In these cases, a second sort criteria is used to rearrange the records that met the first criteria.
We can see another example in the following image, in which the first ordering criteria is the group, but to improve it, age was used as the second criteria and height as the third.
To add sorting criteria you will use the button marked in red.
HOW TO ESTABLISH MORE THAN ONE FILTER CRITERIA
Doing this means that we can filter a filtered table, we simply will not remove the first one.
In these cases, each time we filter the table we will have fewer records on the screen, so the filter can be used to locate information.
To show the entire table again you should deactivate ALL the filters.
FILTER BY CONDITION
There will be times when the list of items of a filter will not be enough. For this we’ll use the “Filter by Condition” option, which offers you the possibility to program the filter.
For example, we can filter by asking for the content of cells, for a word contained in them. We can also filter by asking for numerical ranges, such as "greater or less than".
