title: How to count number of matches between two columns in Excel?
body: <p>How to count number of matches between two columns in Excel?</p>
  
  <p>For example if we have:</p>
  
  <pre><code>1 1
  2 1 
  3 2
  4 4
  5 3
  </code></pre>
  
  <p>I need to get either a column like this:</p>
  
  <p>1
  0
  0
  1
  0</p>
  
  <p>and then I can sum the ones in there to get the count of matches.</p>