How to quickly rank a league table in Excel?
www.extendoffice.com › documents › excelFor instance, there is a league table shown as below, now follow the steps one by one to rank the teams. 1. Firstly, calculate the total point of each team. As a winner gets three points, select a cell, I2, and type this formula =C2*3+D2 (C2 contains the times of winning, D2 is the draw), drag fill handle down to the cells you need to apply this formula.