How to calculate and rank to find winners in excel

[Shen221]

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 participants who completed the quiz with the most accurate answers with the least time taken is to be ranked 1st and is then continued. 

Please refer to this sample excel file with instructions:

https://docs.google.com/file/d/1acJ0Jib3sNGWhu5x0afGEcD7YQrBy9vd/edit?usp=docslist_api&filetype=msex...

If anyone could help me with this it would be very very very helpful! 

Thank you so much! 

[#2]

@Shen221 

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.