This video covers traditional and new methods of ranking scores including SORT, FILTER, PIVOT TABLES, MAX, LARGE.
The new dynamic arrays formula in Excel are a game-changer.
00:45 MAX, LARGE, INDEX, MATCH
15:45 Pivot Tables
18:45 Dynamic Arrays formula FILTER, SORT