Page 8 / 20
Filtering means that a condition is set for the data and only rows that meet the condition are displayed and processed. However, the other, “unfiltered" data remain in the workbook, and can be retrieved by removing the filtering or changing the condition.
The data can be filtered by several columns.
Filtering also automatically updates the values in the sum row and is therefore handy for retrieving individual key figures.
Guide
Saving and filtering
Filters are saved when the workbook is saved. In this exercise, the idea is to leave the filters in place.
However, if a workbook has several users, it is not always clear to everyone that the table has been filtered. Sometimes it happens that the filters in the table are left on and the next user does not notice. He may then think that rows that have been filtered out are not in the table at all. It is always worth considering whether it would be wise to remove filters from the table after using them.
The table has been filtered to show only Sally Reeves’s sales of products priced $500 – $1,000 .
Model:
Task: Filter to show only sales by seller Reeves
Let’s first look at sales by just one seller. Only Sally Reeves’s sales are filtered to be displayed. We can now look at Reeves’s sales figures in the summary row.
Model:
Task: Add the condition that the price must be between 500 and 1,000
In the Price column, a filter is added to limit the price to the range from 500 to 1,000 .
Mallitaulukon sarakkeiden Sukunimi ja Hinta vieressä on pienet suodatinnapit Nice
Various filters
If you click on Text Filters Number Filters Date Filters
Number Filters Greater Than Or Equal To
#### Text filters
#### Number filters
#### Date filters
Tekstisuodattimet-valikko
Numerosuodattimet-valikko, joka on hieman isompi kuin tekstisuodattimet
Päivämääräsuodattimet-valikko, joka on suurin
Info: Removing a single filter
Kuvassa poistetaan suodatus myyjä-sarakkeesta Filtering based on a column can be removed by clicking on the filter button of the column and selecting Clear Filter From …
Info: Removing all filters
Kuvassa poistetaan suodatus kaikista sarakkeista All filters in a table can be removed in one go by clicking on the Clear Sort & Filter Data
Question: How can I see iwhether a table has filters turned on?
Kuvassa huomataan, että sarakeotsikoiden vieressä on suodatinikonit, ja vasemmalla rivinumerot etenevät '471, 472, 480, 483, 488, 489', eli tietoja suodatetaan When filtering is enabled in a table, the row numbers are blue.
Small funnel icons are displayed on the filter buttons that are in use in the filtering.
By now, you have a very good understanding of how to use tables. You can use them to format, sort and filter the appearance of your data. In addition, you can view a wide range of summaries of the data. Let's look at one more feature of tables: the slicers.
Are you ready?