title: Truly unique ranking (while ignoring empty cells)
body: <p>I am using the following formulae for a truly unique ranking of values: <a href="http://support2.microsoft.com/kb/152567/en-us" rel="nofollow">How to Rank Duplicate Values Sequentially</a>. </p>
  
  <p>(As you may or may not be aware the other option (see ##) can produce erroneous results!)</p>
  
  <p>However, there is a problem: I would like to ignore empty cells! Currently, empty cells are counted as having the value zero.</p>
  
  <p>How do I need to change the formulae in <a href="http://support2.microsoft.com/kb/152567/en-us" rel="nofollow">1</a> to ignore empty cells and to return no value at all? Is that even possible with an array formula?</p>
  
  <p>I avoid VBA as I need to keep this dynamic.</p>
  
  <p>Thank you in advance for any hints!</p>
  
  <p>pascal</p>
  
  <p>(##): =RANK(A2,$A$2:$A$10)+COUNTIF($A$2:A2,A2)-1</p>