title: Duplicate Match Count in MS Excel
body: <p>I am new to MS Excel. I stuck in one problem,
  following is the detail description.
  I want to find matching rows(cells) from 6 columns and give count in the last column. I have one <code>Key Column</code> and six <code>Haystack</code> columns to search for. If a key found in any of the haystack column then increment last <code>Count</code> column (in front of respective <code>Key Column</code>) by +1 and so on. 
  For e.g:</p>
  
  <pre><code>Heystack 1   Heystack 2   Heystack 3   Heystack 4   Heystack 5   Heystack 6   Key Column   Count Column
  A            D            E            C            F            G            A            2
  K            E            A            F            W            Z            E            2
  C            Q            R            T            N            B            B            1
  </code></pre>
  
  <p>Kindly let me know if i can use any formula for <code>Count Column</code>
  Thanks in Advance</p>