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. The result is a sorted filtered set that shows the ...

Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate values is easier than it once was. In this article, I’ll show you how to use FILTER() to create a ...