Download Files:
Start File: https://excelisfun.net/files/EMT1429Start.xlsx
Finished File: https://excelisfun.net/files/EMT1429Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/

See how to rank values in Power Query using an Index, the Group By feature and MIN Function.
This trick comes from Bemint at YouTube. His Channel is here: https://www.youtube.com/channel/UCTcU3eUTF9C1bPnca1YVDCA
Here is a video Bemint made about Ranking in Power Query (it is even set to music): Power Query - Solving rank ties - reaction on Excel Magic Trick 1420 https://www.youtube.com/watch?v=GWjNu1v9sxY


Database Credentials:
Server: pond.highline.edu
Database: boomerang
User: excelisfun
PW: ExcelIsFun!