SORTBY() - New Excel 365 Function to Sort Data
Learn Excel's New Function to Sort Data! This is the SORTBY() function for Excel 365 and it allows you to sort a data set using a formula and it is amazing!
The beauty of this new formula for Excel 365 is that it allows you to keep the original data set in place, without making any changes to it, but sort it as many ways as you want using this formula and present the sorted data in a new place on the worksheet. This allows you to be able to view the raw data and sorted data as you wish.
All of this happens with just a single excel function - SORTBY()
In this tutorial you will learn how to do many types of sorts with the SORTBY() function, including:
- basic single column ascending and descending sorting
- multiple field sorting
- returning entire data sets from the sort
- returning specific columns from the original data set
- creating custom sort orders
- using Tables with sorting in Excel
The SORTBY() function is AMAZING!
I hope you enjoy this tutorial
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)