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.

The formula =SORT(A3:B17) uses the default “sort by” and “sort order” settings; thus, the list is sorted in alphabetical order. The syntax for the new SORT function is =SORT(array, [sort_index], [sort ...

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula ...

With INDEX, you select an array, and then tell it a number, and INDEX returns that element. Walter Hickey / BI So here, INDEX gave us the 2nd element of the B2:B9 array, which is New York.

Originally, Excel was not designed to be a real database. ... The syntax for the INDEX function is: INDEX(array, row_num, [column_num]). The array is the range of cells that you’re working with.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().