title: Finding unique values between 2 Excel columns
body: <p>I have two simple columns in Excel below</p>
  
  <pre><code>ID       ID1
  123      123
  124      125
  125      126
  126
  </code></pre>
  
  <p>I was able to use the conditional formatting in excel as follow: 
  1. Highlight the 2 columns
  2. Click on the conditional formatting 
  3. New rule
  4. Select format only unique or duplicate values
  5. Select unique under format all:
  6. Select Format and click ok.</p>
  
  <p>I can see that the steps above shows the highlighted value which is 124.</p>
  
  <p>My question is, how can I filter out that 124 value from such a small sample above?</p>
  
  <p>I have a columnA that has 50k records and columnB that has 48k records. I want to see or filter out the 2k records from columnA.</p>