How do I generate a league table using Excel?
Solution 1:
Start by adding all the distinct names in another column. You'll then create a COUNTIFS formula, one that looks up that name in your results table.
The formula will count the number of times the person has won first place and multiply by 3, PLUS, count the times they won 2nd place and multiply by 2, PLUS count the third place finishes.
Formula for cell G2:
=(COUNTIFS(B:B,F2)*3)+(COUNTIFS(C:C,F2)*2)+(COUNTIFS(D:D,F2))
Drag it down, done. You can then sort columns F and G by G descending for your leaderboard.
