[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

FILTER

This function allows users to filter a cell range based on the defined criteria. The filter operation can be performed based on a single criterion or multiple criteria.

In order to combine two or more filter conditions, users can use the " * " operator and the "+" operator. The * operator will multiply two sets of conditions in order to join the filter criteria with AND logic [when both the filter conditions have to be TRUE]. The + operator will simply join the two sets of conditions with OR logic [when one filter condition can be TRUE and the other can be FALSE].

Note: FILTER is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

Syntax

FILTER(array, include, [if_empty])

Arguments

FILTER function has the following arguments:

Argument

Description

array

[Required] Specifies the range or array that you want to filter.

include

[Required] Specifies the filter condition expressed using intersecting sub-range and conditional expressions.

if_empty

[Optional] Specifies the optional value that users want to return when the filter result is empty.

If a value is not specified for this parameter, then #CALC! error is thrown.

Examples

FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")