Do you wonder how to get Olympic medal table style sorting in Excel? In this fun & short video, let me show you two ways to sort the medal table.
1) using custom sort order
2) using the SORTBY function

Here is a sample file if you need one.
https://chandoo.org/wp/wp-content/uploads/2021/08/olympic-medal-sorting.xlsx

Excel formula to sort by multiple levels (Older versions):
https://chandoo.org/wp/sorting-values-in-olympic-medal-table-style/

Watch these next…

Top 10 AWESOME things you can do in Excel – https://youtu.be/W1QhTQCasb4
Introduction to new Excel formulas (SORTBY, FILTER and more) – https://youtu.be/ONaS7IMKJPM

Go Kiwis & Go India…

#Olympics #ExcelTips