Returns a range which is filtered based on a condition.


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


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


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.