Column A has players and there are 3 rounds of a game. Columns B to D contain the points achieved by the players.
The challenge is to determine the rank of these players on the basis of sum of points in various rounds without a helper column. 1 would mean the highest rank.
Column E contains result expected.
In case of a tie, the name first occurring would have higher rank. Shine and Kevin both have 10 points total. Since Shine comes first, hence it has higher rank.
The workbook related to this challenge can be downloaded from Challenge 71 – Determine Rank
The solution to this problem will be published after a month i.e. on 10-Jul.