Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

FILTER Operation

How to use the Filter operation in formulas

Definition

Example

Syntax Guide

Formula In Use

 

Definition

The FILTER operation returns a list of items that achieve certain conditions.

 

Example

FILTER(GT($$ITEM, 2), [1, 2, 3, 4])

Result:
[3, 4]

 

 

Syntax Guide

FILTER(condition, range)

condition - An array formula evaluating to true or false

range - The data to be filtered

 

Formula In Use

FILTER Operation - Formula In Use

 

What's Next