How to calculate and rank to find winners in excel

Copper Contributor

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:


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

Thank you so much! 

1 Reply


Perhaps in E2:


Format E2 as General, then fill down.

In F2:


Fill down.