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.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. ... By including an input value, you can control the number of random names generated.