Type in Google’s function list
Filter functions
Functions that filter, sort and de-duplicate a range. Google prints 4 Filter function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| FILTER | FILTER(range, condition1, [condition2]) | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. |
| SORT | SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2]) | Sorts the rows of a given array or range by the values in one or more columns. |
| SORTN | SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...) | Returns the first n items in a data set after performing a sort. |
| UNIQUE | UNIQUE(range) | Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.