FILTER

Returns a range which is filtered based on a condition.

Syntax

FILTER(range; filterCondition; orientation)

• range - the range which is to be filtered - Value type: range

• filterCondition - the condition which is used to filter range - Value type: a row or column range with boolean values

• orientation - the orientation of the filter evaluation - Value type: constant (optional, vertical as default). Possible values are:

  • horizontal - the filterCondition is a row, removing columns from range

  • vertical - the filterCondition is a column, removing rows from range

Remarks

• orientation can only be used as parameter if filterCondition is used as parameter as well.

Examples

In the two selected widgets below, the FILTER function is applied using these three widgets:

Other examples

The two selected widgets below extract rows from the widget "winelist", based on different conditions.