SORTBY function in Excel (with 6 examples) | Sorting without a single click | Excel Off The Grid.

Опубликовано: 05 Ноябрь 2024
на канале: Excel Off The Grid
14,595
239

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Download the example file:★
https://exceloffthegrid.com/sortby-fu...


★ About this video ★
The SORTBY function was announced by Microsoft in September 2018 and is one of Excel’s new dynamic array functions. SORTBY makes use of the changes made to the calculation engine, enabling a single formula to spill calculations into multiple cells.

SORTBY allows us to sort a range or array based on the values in a corresponding range or array. Through 6 examples, you will learn how to master this new function.


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel #ExcelOffTheGrid