Skip to main content

FILTER

Filters a range of data based on specified criteria.

Syntax​

FILTER(range, criteria_range, criteria)

Arguments​

  • range: The range of data to filter.
  • criteria_range: The range containing the criteria to match.
  • criteria: The specific criteria to match.

Example​

FILTER(A1:C10, B1:B10, ">100") → Returns rows from A1:C10 where the value in column B is greater than 100