title: Excel formula to get ranking position
body: <p>I have a table of people with points. The more points, the higher your position. If you have the same points you are equal first, second etc.</p>
  
  <p>&nbsp; &nbsp;| A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | C<br/>
  1 | <strong>name</strong> &nbsp;  &nbsp;| <strong>position</strong> | <strong>points</strong><br/>
  2 | person1 | 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 10<br/>
  3 | person2 | 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 9<br/>
  4 | person3 | 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 9<br/>
  5 | person4 | 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 9<br/>
  6 | person5 | 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 8<br/>
  7 | person6 | 6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 7</p>
  
  <p>Using an Excel formula, how can I automatically determine the position? I'm currently using an IF statement that works fine for 5 or 6 matching positions, but I can't add 30+ if statements because there's a limit to the formula.</p>
  
  <pre><code>=IF(C7=C2,B2,IF(C7=C3,B2+5,IF(C7=C4,B3+4,....
  </code></pre>
  
  <p>So if the points column is the same as the position above then it's the same position value. If the points are less than above then it drops a position so the previous row position +1. But if the row above that is the same then it's the previous position +2 and so on.</p>