JavaScript’s arrays can hold heterogeneous types, change size on the fly, and readily insert or remove elements. Traditional methods like slice, splice, and push/pop do this by operating on the ...

SORT()’s array argument is the entire FILTER() function. The sort_index value of 2 sorts by the Value column, the second column in array. The sort_index value is -1, which applies a descending sort.

Here’s a simple example explaining how the new SORT array function works. Columns A and B in the screenshot below (cells A3:B17) contain unsorted sales data by state. To sort these data using a ...