SORTBY() - New Excel 365 Function to Sort Data

Add to Favorites
Author: | Edits: don

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!

New Excel 365 Formulas Course

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

Excel Function: SORTBY()
Excel Version: Excel 365
Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.