Finding unique values between 2 Excel columns
<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>