Function reference /Array & filter

Array & filter

Work on whole ranges at once instead of dragging a formula down.

• FILTER

  Returns only the rows of a range that meet one or more conditions.

• QUERY

  Runs a small SQL-like query over a range — select, filter, sort and group in one formula.

• SORT

  Returns a range sorted by one or more of its columns.

• UNIQUE

  Returns each distinct row of a range once, discarding duplicates.