title: How to find the matches between two columns in Excel sheet?
body: <p>In Microsoft Excel 2010, I have an excel sheet that has two columns Z and AG. Z has 11400 rows and AG has 3000 rows. I want to find the matches between both of them in a new column. So how to do that? 
  I tried the following formula:</p>
  
  <pre><code>=IF(MAX(COUNTIF($AG$2:$AG$114000,$Z$2:$Z$114000))&gt;1,"Duplicate","Nope")
  </code></pre>
  
  <p>But it did not work correctly with me because it gave me "Nope" for all the rows, however i have many matches between both of them. </p>
  
  <p><strong>So could you please help me with this?</strong></p>