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
