title: Tie breaking using Rank function
body: <p>I have a student's result sheet, where I calculated the total number the student has gained. Next, I want to rank them according to the grand total, and wherever it duplicates, the student getting more number in maths(E9:E58) will be given priority, </p>
  
  <p>How to accomplish it?</p>
  
  <p>I have my grand total from U9 to U58, and maths score in d9 to d58.</p>
  
  <p>I have used this formula: </p>
  
  <pre><code>=Rank(u9,u9:u58,1)
  </code></pre>
  
  <p>I am stuck in how to use the if condition within the rank function.</p>
  
  <p>Please help.</p>
  
  <p>Thanks in advance....</p>