compare values from 2 columns and display the unique values in other column

hello all

let say i have 3 columns

column a is the new entry , column b is the data , and column c is the result

column b is my database actually , column a is the new entry , that i want to compare to column a

so the result will appear in column c

column a is new entry , it have , 14 , MARY , JOHN , 20

column B is my datalist , it have , JOHN , BOB, 14 ,12

so i need the column c showed MARY and 20

untitled1.jpg

thanks in advance

Using some old code I had this should work more or less... I must admit I did not try a re-write to condense the 2 functions it calls, which I changed slightly a while back but for which I can't take credit.

Please Login or Register  to view this content.

@ JOHN: OK OK.... mine is overly complicated for the application, I get it....
lol just kidding around eh! Nice solution

@ John in this case I just had some code lying around to compare arrays (based on recordset data originally, not spreadsheets), your solution is much simpler and presumably better suited to this situation, I like it!

@John I believe what the OP wants is both unique in A and unique in B, all listed in C

Originally Posted by JOHN H. DAVIS

? That's what the current code does. If you want the opposite then:

Please Login or Register  to view this content.

thanks again sir

but when when i run the first code, no 12 and BOB that include in column B doesnt show in column c as result

it only show MARY and 20

what i want to do is the result in colum c show MARY , 20 , 12 and BOB

the first code fulfill my first request without doubt

then i wonder if i want to show all the unduplicated data in column C as my second request, tq