title: RANK only working with reference? Weighted rank
body: <p>The RANK function does not work when the array to search in is not a reference.
  For example</p>
  
  <pre><code>RANK(Number,A10:A20)
  </code></pre>
  
  <p>works perfectly, but</p>
  
  <pre><code>RANK(Number,{1,2,3})
  </code></pre>
  
  <p>or</p>
  
  <pre><code>RANK(Number,A10:A20*10+B10:B20)
  </code></pre>
  
  <p>does not.</p>
  
  <p>Why do the above not work?<br>
  How can I get weighted rank of a number without using excess cells?</p>