title: Google-spreadsheet formula to get number ranks in column
body: <p>I'm looking for formula/function for google-spreadsheet. Sorry for the title, but let me explain. I have a column with 5 rows of numbers:</p>
  
  <pre><code>2
  5
  9
  7
  4
  </code></pre>
  
  <p>I want to loop through rows and create another column which will tell me rank of each cell. So, for example "2" is the lowest so it gets <strong>1</strong>. "9" is the highest to it gets <strong>5</strong> (highest rank, because there are 5 rows), "7" is second highest, so it gets <strong>4</strong>, etc. So, I want to achieve this:</p>
  
  <pre><code>1
  3
  5
  4
  2
  </code></pre>
  
  <p>So, in other words. For every cell in new column, I need to put value how high relevant number in other column is.
  Can anyone help me with this? I'm using Google spreadsheet. </p>