title: Dynamic range for Rank Function
body: <p><a href="http://i.stack.imgur.com/6xcqU.png" rel="nofollow">Data sheet</a>
  Hi,</p>
  
  <p>For given data, rank of "val" is given in Rn column, since there are duplicates entries I want the a function for rank to consider va2 value where val is repetitive. "Output is in Rn2 column which i want from formula". If val is unique it should give its rank from same column entries and when val is repetitive it should give rank based on va2 values.</p>