SORT vs SORTBY in Excel

Video • 11 minutes

Learning Objectives

Learn how to use the SORT and SORTBY functions in Excel to organise data dynamically. Discover how to apply these functions to sort by multiple criteria, update your sorted data automatically, and output your results anywhere in your workbook. Gain insights into the differences between SORT and SORTBY, and enhance your data management skills with these powerful tools available in Excel 365 and Excel 2021.

Lesson Description

Discover the power of Excel's dynamic array functions, SORT and SORTBY, for efficient data arrangement in Excel 365 and 2021. Learn to easily sort by multiple criteria and keep data organized with minimal effort.

‍

Return Multiple Columns with VLOOKUP