title: How to output the most common value and the number of occurrences of that value in spreadsheet?
body: <p>There is a column <code>Values</code> with a number of <code>Strings</code>, then show below the most common value and the number of occurrences of that value (i.e. mode of <code>Strings</code>).  Here's an example.</p>
  
  <pre><code>+--------+
  | Values |
  +--------+
  |   AA   |
  +--------+
  |   BB   |
  +--------+
  |   AA   |
  +--------+
  |   AA   |
  +--------+
  |   GG   |
  +--------+
  |   DD   |
  +--------+
  |   DD   |
  +--------+
  |        |
  +-----------------+--------+
  |   Most Common   |   AA   |
  +-----------------+--------+
  | Number of times |   03   |
  +-----------------+--------+
  </code></pre>
  
  <p>This will be done in Google Spreadsheets!
  Any tips?</p>