Thank you so much! This made it super easy to find unique values!

"Excel_Learner" wrote:

You can highlight the unique values by Conditional Formatting as under:

1. Select both the columns,
2. Click on Conditional Formating under Home Tab
3. Select New Rules and select "Format only Unique and duplicate values"
then select Unique from drop-down box and select formating as you desire.

Hope this will work for you.
rgds...

"ABeezy" wrote:

I have a worksheet with two columns that I need to compare data between. I
need to see what is different between one column and the next. There are
number and letter values in the column and about 180+ rows. The information
is scattered throughout the cells so there is no way to filter and check row
by row.

The columns look like this:

July April
MP123456789 MP555555559
MP987654321 MP666 H1258
MP789456123 MP00000 H89
MP987123654 MP123456789

I need something that would tell me that all of the above values are unique
between the two columns except for MP123456789