Google Sheets filter functions

Filter functions in Google Sheets, explained with live examples.

3 filter functions in Google Sheets — 2 documented in depth so far, the rest indexed below and landing every week.

Documented filter functions

Syntax, examples, and the equivalent — ready now.

FILTERReturns a filtered version of the source range, returning only rows or columns which meet the specified conditions.FilterExcel
SORTSorts the rows of a given array or range by the values in one or more columns.FilterExcel

All Google Sheets filter functions

The full set — deep dives on the way.

SORTN: Returns the first n items in a data set after performing a sort.

More Google Sheets function categories