title: Excel creating multiply conditions ranking
body: <p>I am trying to make a conditional ranking in this chart:</p>
  
  <p><a href="https://i.stack.imgur.com/92Mn5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/92Mn5.png" alt="enter image description here"></a>
  On the right you can see the total score and ranking from the <code>Match 1,2,3</code> (sum)
  on line <code>A</code> and <code>C</code> I have a tie score (3 points and both ranked at 2nd place), I'd like to to add a 2nd and 3rd conditions to determinate the final ranking.
  If there is a tie in score (both are in same ranking), then to determine who is 2nd and who is 3rd place I want to use the values from the <code>XX's</code> column first. The higher value will win the 2nd place and in a case there is still a tie (as both are the same value of 0), it will continue and check the value on the <code>X's</code> column and since line <code>C</code> = 27 and line <code>A</code> = 21, line <code>C</code> will be ranked as 2nd place and line <code>A</code> will be ranked as 3rd place.
  Also will like to add an option to continue with 3 condition if there is still a tie.</p>
  
  <p>I am using a simple ranks formula <code>=RANK(AK7,$AK$7:$AK$10)</code> to determine the rank.</p>