title: How to compare two columns value in excel?
body: <p>I have over 100k rows of data like below:</p>
  
  <pre><code>ALLA,ALLA,"Company1, Inc.","Company1, Inc.",PSA,PSA,1,1,FALSE,FALSE
  BCCO,BCCO,"Company2, Inc.","Company2, Inc.",PSB,PSB,1,1,FALSE,FALSE
  CTTP,CTTP,"Company3, Inc.","Company3, Inc.",PSC,PSC,1,1,FALSE,FALSE
  CMMZ,CMMZ,"Company4, Inc.","Company4, Inc.",PSD,PSD,1,1,FALSE,FALSE
  </code></pre>
  
  <p>I want to know how to figure if data in column 1 is the same as column 2, column 3 as column 4 and so on. How could I do that in excel?</p>
  
  <p>Following Cory's formula, I found that I can compare whole columns using:</p>
  
  <pre><code>=if(A:A=B:B, "yay", "aww")
  </code></pre>
  
  <p>Problem is I have a header in the file:</p>
  
  <pre><code>c - symbol, symbol, c - companyname,    companyname,    c - tradingvenue,   tradingvenue,   c - tierrank,   tierrank,   c - iscaveatemptor, iscaveatemptor          
  </code></pre>
  
  <p>Shouldn't this cause A:A=B:B to be false?</p>