title: Ranking in Excel with multiple criteria
body: <p>For example, I need to create a merit list of few student based on total marks (column <code>C</code>), then higher marks in math (column <code>B</code>) - </p>
  
  <pre><code>A        B  C   D
  -------------------------
  Student1 80 220 1
  Student2 88 180 3
  Student3 90 180 2
  </code></pre>
  
  <p>Expected merit position is given in column <code>D</code>. </p>
  
  <p>I can use <code>RANK</code> function but I can only do that for one column (total number). If total number of multiple student is equal, I could not find any solution of this. </p>