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

When you enter a dynamic array formula in one cell, Excel automatically populates the adjacent cells needed to display all the results. You’ll know it’s working when you see a blue border around this ...

Although not very performant, Bubble Sort, Selection Sort, and Insertion Sort are all simple algorithms for sorting a one-dimensional array. Each works well enough for shorter arrays.

To see how SORT () works, let’s use it to return a sorted data set of the example data set (Figure A). First, you need to copy the column headers to another area of the sheet, or even another sheet.