In this video, we see three examples of the SORT and SORTBY functions automatically sorting formula results.

These functions are incredibly useful. Excel has been crying out for these sort formulas for years.

The examples in this video go from basic to complex.

Download the Excel file to practise - https://www.computergaga.com/_excel/f...

Here are the timings of the video.
00:00 - Introduction
01:04 - Automatically sort a distinct list
03:47 - SORT function to order a filtered list
07:00 - SORT formula to sort by multiple columns
10:08 - SORTBY function example

New to these dynamic arrays formulas? Watch this -    • Dynamic Array Formulas in Excel - 8 T...  

Excel FILTER Function - Is this the Best Excel Function? -    • Excel FILTER Function - Is this the B...  

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1