title: Create a Rank based on the Frame Played and Won
body: <p>I have been trying to create a Rank based on the Frame played and Won. All i got is the Rank formula from the Google.</p>
  <pre><code>=RANK(D2,$D$2:$D$18)
  </code></pre>
  <p>But i want a fair Ranks if player has played 1 frame and won 1 then its ranks will be next from the player who played 3 frames and won 3.</p>
  <p>I have attached a picture with Ranks Result and The Result I want.</p>
  <p>Your help will be appreciated.</p>
  <p>[<img src="https://i.stack.imgur.com/lpgxH.png" alt="enter image description here" /><a href="https://i.stack.imgur.com/lpgxH.png" rel="nofollow noreferrer">2</a></p>