title: Counting combinations of values in table of values excel?
body: <p>I have a table of values with each value in a different cell</p>
  
  <p>e.g. </p>
  
  <pre><code>2   9   12  19  41  45  14  39
  12  14  19  27  39  40  30  44
  6   9   13  15  16  41  7   20
  8   16  14  34  13  44  5   15
  10  11  20  24  27  36  9   41
  </code></pre>
  
  <p>Is there a way to find which pairs of numbers are most common. </p>
  
  <p>i.e. </p>
  
  <p>13 &amp; 15 appear 2 times</p>
  
  <p>14 &amp; 44 appear 2 times</p>
  
  <p>24 &amp; 27 appear 1 time</p>
  
  <p>I was hoping for a formula as the table has over a hundred rows in it so would be time consuming to count manually.</p>