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 ...

Stay tuned There are several new dynamic array functions and over the next few months, we’ll cover several of them. Next up, we’ll be using SEQUENCE () to return the top n values in a data set.