Filter & Sort functions
All 6 functions in this category
FILTERReturns filtered rows from an array based on a boolean criteria array, retaining the original order and all columns.SORTSORT arranges array data in ascending or descending order by a specified column, returning a sorted copy as a dynamic array.SORTBYSORTBY reorders an array based on one or more sort columns, returning rows in the order specified by your criteria—perfect when you need multi-column sorting.GROUPBYGROUPBY groups data by one or more fields and applies an aggregation function, returning a dynamic array table with subtotals and a grand total row.PIVOTBYPIVOTBY creates a dynamic pivot table by grouping source data along rows and columns, then applying an aggregation function.PERCENTOFReturns the percentage that one value or range represents of a total, such as category spending as a percent of total budget.
Also relevant here
These live in another category but come up constantly in Filter & Sort work.