The SORTBY Function in Excel: A Comprehensive Guide
The SORTBY function in Excel is a powerful tool for sorting data. With SORTBY, you can quickly and easily sort your data based on the values from another range or array. This can be especially useful if you need to keep track of changes to your data, as SORTBY will automatically update the sorted copy of the data whenever the source values change. In this blog post, we will take a closer look at how the SORTBY function works, and explore some of its potential applications. Let’s get started!
What Does The SORTBY Function Do?
As we mentioned above, SORTBY allows you to sort your data based on the values from another range or array. This can be a useful way to keep track of changes to your data, as SORTBY will automatically update the sorted copy of the data whenever the source values change.
SORTBY can also be used to sort data that is not part of the source data, which can be helpful if you need to keep track of certain values that are not included in the original data set. This is different from the SORT function which requires a contiguous data set.
Where To Find It?
Option 1:
You can find the SORTBY function in the Formulas tab of Excel under Lookup & Reference
Option 2:
You can use Formula Builder to walk you through the formula step by step.
Option 3:
You can manually type the formula into any cell.
The SORTBY Formula
=SORTBY (array, by_array, [sort_order], [array/order], …)
- array (required) – Range or array to sort
- by_array (required) – Range or array to sort by
- sort_order (optional) – Sort order. 1 = ascending (default), -1 = descending
- array/order (optional) – Additional array and sort order pairs.
Let’s Take a Look at an Example
Excel Workbook
Coming Soon
Example
Coming Soon
Tips and Tricks
Did I get a #VALUE error?
This likely means that you entered incompatible dimensions. Check the dimensions on each of you fields to make sure they line up.
Let’s Recap
The SORTBY function in Excel is a powerful tool for sorting data. With SORTBY, you can quickly and easily sort your data based on the values from another range or array. This can be especially useful if you need to keep track of changes to your data, as SORTBY will automatically update the sorted copy of the data. I hope this article has helped you better understand how the SORTBY function works, and how it can be used to sort your data. Thank you for reading!
Have any questions? Are there other topics you would like us to cover? Leave a comment below and let us know! Make sure to subscribe to our Newsletter