Download Spreadsheets 2013

Spreadsheets 2013 User Manual
Figure 2.6-13 Filter result
2.6.3 Advanced Filter
The Advanced Filter option allows you to use complex conditions to filter a range. The filter result can be
displayed either in the original worksheet or in a new location. Those rows which don’t meet the criteria
will be hidden.
To specify the conditions of the Advanced Filter function, you have to create the specific Criteria range
first. Mind that the criteria range should be created out of the data range which you want to filter.

Multiple conditions in a single column: if you want to filter the data by conditions of the same
category, you can simply enter the conditions under the header of the category. For example, to filter
the data by the condition “Name is Jane or Flora”. The criteria range and filter result are shown as
below:
Figure 2.6-14 Multiple conditions in a single column

Multiple conditions in a single row: if you want to filter the data by more than two conditions, you
can enter them from the right to the left under the corresponding categories. For example, to filter the
data by the conditions “ Age > 20” and “Occupation is teacher”. See below:
Figure 2.6-15 Multiple conditions in a single row
47