FILTER (PQL - xl)

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

  • Library: PQL \ Spreadsheet \ Lookup
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

FILTER(array, include, OPTIONAL if empty)

Function Arguments

Name

Description

Type

Optional

array

Specifies the range or array that you want to filter

StringOrNumber

include

Specifies the filter condition expressed using an intersecting sub-range and conditional expressions

String

if empty

Specifies the optional value that users want to return when the filter result is empty. If value is not specified for this parameter, then #CALC! error is thrown

StringOrNumber

Y

Comments

This function is the same as the Microsoft Excel 'FILTER' function - using the same inputs, logic and outputs.