How to Sort Data by Column in Excel
- Get link
- X
- Other Apps
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.
- Get link
- X
- Other Apps
Popular posts from this blog
Top international payment gateway transaction fee comparison (2024)
How to Manage Boot Configuration of Windows using CMD
What is Python Syntax and how to use?
Free Source Code and Documentation for Android App, Free for Commercial and non commercial purpose.
- Source Code with Documentation for Android Web shortcut key app Free Download
- Source Code with Documentation for Android VPN App Free Download
- Source Code with Documentation for Android Screen Recorder App Free Download
- Source Code with Documentation for Android Love calculator App Free Download
- Source Code with Documentation for Android Kids Math IQ App Free Download
- Source Code with Documentation for Android Diet Plan App Free Download
- Source Code with Documentation for Android BMI Calculator App Free Download
- Source Code with Documentation for Android Blogger App Free Download (Admin and Client App) Make a blogpost