Creating a list of just unique values

Hi all, I am using Excel 2010. I have 2 columns that I want to compare data against each other, and I would like to make a list that returns JUST the unique values. I have roughly 65,000 lines of data, and in each column I might have 4 unique values, I would like to see these values without having to sift through 65,000 lines.

Any thoughts?

Thanks for the welcome! I am aware of that function, but what that does is removes duplicates and writes a list with all the data, I just want to see which results when comparing each column come back unique.

attached is a file that is a basic example of what I want to see. The unique value from column A when compared to column B is 16, and the unique value of column B when compared to column A is 15.

Try this :
Select both A and B
Home->Conditional Formatting->Highlight Cells Rules->Duplicate Values.

Select Unique values from drop down, so that Unique values from both the cells are highlighted.

Unfortunately that wouldnt work either as there is 65,000 lines of data to search through to find maybe 4 unique values. It would be a long process to look through all that to find just 4 cells that arent highlighted.

CF Washout Answer 2.xls

If you set the MarvinP's conditional formatting to unique, and apply a filter, you could filter by color for each column

hmm that might do the trick, only issue is that one column may have more values than the other, so somewhere down the list column A wont match column B, so as soon as you find your first FALSE value, everything after that will be false...

Maybe using a countif formula formula that searches an entire column based on a value of the other column, and returns the value as true or false.

Solved! So you do a Countif, Range is the entire column A, criteria is B2, copy the formula down, then sort numerically, the 0s will come to the top!

Thanks for the help, cant believe I didn't see this!

CF Washout Answer 3.xls