FILTER, SORT, UNIQUE, SEQUENCE and the new spill functions that return whole tables. This page lists all 20 of them; each links to a full lesson with an example you can copy and a practice file.
CHOOSECOLSCHOOSECOLS returns only the columns you list, in the order you list them.CHOOSEROWSCHOOSEROWS returns the rows you specify — first, last, or any list of positions.DROPDROP removes rows or columns from the start (positive) or end (negative) of an array — e.g. strip…EXPANDEXPAND pads an array to a given number of rows and columns — handy before VSTACK when pieces…FILTERFILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.GROUPBYGROUPBY groups rows by one or more columns and aggregates values — a live summary table that updates…HSTACKHSTACK joins arrays horizontally — build a small report from separate results in one formula.PIVOTBYPIVOTBY groups by rows and columns at once — regions down, months across — as a formula.RANDARRAYRANDARRAY returns an array of random numbers, optionally whole numbers between limits — instant test data.SEQUENCESEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.SORTSORT returns a sorted copy of a range; the original stays untouched and the result re-sorts as data…SORTBYSORTBY sorts one range by the values in another — even by a column you do not display.TAKETAKE returns the first (or last, with a negative number) rows or columns of an array — perfect…TOCOLTOCOL flattens a 2-D range into a single column, optionally skipping blanks and errors. TOROW does the same…TOROWTOROW flattens a block into a single row, optionally skipping blanks and errors.TRIMRANGETRIMRANGE removes empty rows and columns from the outside of a range, so formulas can point at whole…UNIQUEUNIQUE returns the distinct values of a range, updating automatically as data changes.VSTACKVSTACK appends ranges one below another — combine monthly sheets or regional lists without copy-paste.WRAPCOLSWRAPCOLS takes a long list and wraps it into columns of a fixed height — printable labels, seating…WRAPROWSWRAPROWS reshapes a single column into rows of a fixed width — e.g. a pasted list where every…