How to Sort Data by Column in Excel

The SORTBY function in Excel sorts a range or an array based on the values in one or more columns. It takes two arguments: an array or a range, and one or more columns by which to sort the data. The function returns a sorted array or range.

Syntax: SORTBY(array, by_array1, [sort_order1], [by_array2], [sort_order2], ...)

Where:

·        array is the array or range to sort.

·        by_array1 is the array or range by which to sort an array.

·        sort_order1 is the optional sort order for by_array1, either 1 (ascending) or -1 (descending).

·      by_array2 and sort_order2 are optional additional arrays and sort orders to use for sorting if there are ties in by_array1.

Here's an example of how to use the SORTBY function to sort a table of data by two columns:

In this example, the function sorts the range D2:F11 based on the values in the E and F columns, in descending and ascending order respectively.