> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/filter.md).

# FILTER

#### Syntax <a href="#syntax.20" id="syntax.20"></a>

**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, <mark style="color:red;">vertical</mark> as default).* Possible values are:
  * *<mark style="color:red;">horizontal</mark>* - the *filterCondition* is a row, removing columns from *range*
  * *<mark style="color:red;">vertical</mark>* - the *filterCondition* is a column, removing rows from *range*

#### Remarks <a href="#remarks.17" id="remarks.17"></a>

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

#### Examples <a href="#examples.2" id="examples.2"></a>

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

![](/files/as1D12mNwrbDqINMflrW)

<figure><img src="/files/RRoQMqu5fzVe7JSA19UI" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/rEgnKExiySYHfmMHK70e" alt=""><figcaption></figcaption></figure>

**Other examples**

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

![](/files/iqlOnOnxPcyMxTcjlcix)

<figure><img src="/files/lJBWDhMk3IV2xrJZNppz" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/HplVwdJbn2H2LK4Bt0gm" alt=""><figcaption></figcaption></figure>