title: Counting duplicates in Excel
body: <p>I have a list of postcodes that includes duplicates. I would like to find out how many instances of each postcode there are. </p>
  
  <p>For example I would like this:</p>
  
  <pre><code>GL15
  GL15
  GL15
  GL16
  GL17
  GL17
  GL17
  </code></pre>
  
  <p>...to become this:</p>
  
  <pre><code>GL15 3
  GL15 3
  GL15 3
  GL16 1
  GL17 2
  GL17 2
  </code></pre>
  
  <p>...or ideally this:</p>
  
  <pre><code>GL15 3
  GL16 1
  GL17 3
  </code></pre>
  
  <p>Thanks!</p>