Is there a way to break ties when you use the Rank function in excel? I have
a spreadsheet that takes scores and ranks them in order 1-10. But if two
people have the same score it shows the same rank for both. Is there a
function to correct this using a specific score? We would use quiz as the
tie breaker.
Column A Column B Column C
Quiz Score Total Score Rank
80 100 2
85 100 2
90 120 1