Dynamic Array Functions

FILTER pulls out matching rows from a table based on a condition. Unlike VLOOKUP (which returns one value), FILTER can return entire rows and multiple matches — all in one formula.

Generates an array of random numbers.

Generates a sequence of numbers in an array.

Sorts a range or array (spills the result).

Sorts an array using other arrays as keys.

Returns unique values (spills the result).

Modern lookup that returns a position (MATCH replacement).