SORT & SEQUENCE Functions

Premiumadvanced 15 min5 tasks0/102 pts

SORT returns a sorted copy of a range and SEQUENCE generates a list of numbers. Both spill into the cells below. SORT(array, sort_index, order) takes 1 for ascending (the default) and -1 for descending. SEQUENCE(rows, [columns], [start], [step]) counts for you.

Syntax

SORT(array, [sort_index], [sort_order]) · SEQUENCE(rows, [columns], [start], [step])

FILTER with Multiple Conditions XMATCH and INDEX/XMATCH