For a tiebreaker question on a quiz, I need a formula that does the following:
- First, create a ranking based on the column total score
- In case of a tie in previous, the team closest to the answer to the tiebreaker question should come first
So I thought to work with a rank formula first and supplement it with a rank formula where (correct answer - their answer to the tiebreaker question) should be as close to zero as possible.
But I still didn't find the correct formula. Can anyone help me?