# Compare 2 Columns To Find Unmatched Values

Oct 26, 2007Is there a function to compare 2 columns to find all of the values from one column that are not in the other column? Basically my data looks like this:

A........................B.................C

procedure1...........................225-3

........................ 25-1...........22-2

.........................33 .............457

procedure2...........................33-55

.......................35-12...........25-6

.......................12-8.............25-1

procedure3...........................33-89

.....

I have another list of data (just the numbers like columnB) that I want to put in column C and see what is in column C that isn't in column B. The numbers will be arranged in a different order, and there will be data in column B that isn't in column C. What I need to do is find out what is in column C that isn't in column B so that I can go back and define what procedure they fit into (that is a seperate process).