FILTER Function in Google Sheets

Filter a range of data based on specified conditions using the FILTER function.

FILTER Function

The FILTER function in Google Sheets returns an array that meets the specified conditions.

Syntax

FILTER(range, condition1, [condition2])
  • range: The range of cells to filter. This is a required parameter.
  • condition1: The condition that must be met in the first column. This is a required parameter.
  • condition2: (Optional) Additional conditions that can be applied to subsequent columns.

Examples

  1. Basic Filtering

Filter the range A1:B10 to show rows where the value in column A is greater than 50:

=FILTER(A1:B10, A1:A10 > 50)

This will return the rows that meet the condition.

Notes

  • The function returns an array, so the result will expand to the cells below the formula.
  • If no rows meet the conditions, the function will return an error.
  • SORT: Sort a range based on one or more criteria.
  • UNIQUE: Remove duplicates from a range.