> 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/version-1.52-preview/clearlines-functions/range-functions/filter.md).

# FILTER

Returns a range which is filtered based on a condition.

#### 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:

![](https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/Hg09RHdheLHn5HqnhImA/grafik.png)

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/QYyGHFr3JuPzSupqT8un/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/BI8RgwNDskhQri14FUes/grafik.png" alt=""><figcaption></figcaption></figure>

**Other examples**

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

![](https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/fxbCm135E13qtUMZltMt/grafik.png)

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/hm3GCMP4O5TAxYnGSm3a/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/SgiLRYo5hA1PsqC8vJ03/grafik.png" alt=""><figcaption></figcaption></figure>
