FILTER

Filters lists of data one column at a time. Only one list can be filtered on any one sheet at a time.

Syntax

FILTER(field_num, criteria1, operation, criteria2)

FILTER?(field_num, criteria1, operation, criteria2)

Field_num is the number of the field that you want to filter. Fields are numbered from left to right starting with 1.

Criteria1 is a text string specifying criteria for filtering a list, such as ">2". If you want to include all items in the list, omit this argument.

Operation is a number that specifies how you want criteria2 used with criteria1:

Number Operation Used

1 AND

2 OR

Criteria2 is a text string specifying criteria for filtering a list, such as ">2". If you include this argument, operation is required.

Remarks

If you omit all arguments, FILTER toggles the display of filter arrows.

Related Functions

FILTER.ADVANCED Lets you set options for filtering a list

List of Command-Equivalent Functions