Forum Discussion
How to calculate and rank to find winners in excel
Dear All, Hope you’re well. I’m looking for a formula to calculate and find winners and rank them to create a leaderboard. Here the time taken to complete the quiz plays a big role. The pa...
Perhaps in E2:
=RANK(C2,$C$2:$C$8,1)+RANK(D2,$D$2:$D$8)
Format E2 as General, then fill down.
In F2:
=RANK(E2,$E$2:$E$8)
Fill down.