Macro for two columns -- find unique ones

Closed
Report
Posts
2
Registration date
Monday December 14, 2009
Status
Member
Last seen
December 15, 2009
-
Posts
2
Registration date
Monday December 14, 2009
Status
Member
Last seen
December 15, 2009
-
Hello,

I apologize for the poor example.

here are the two columns
42 42
39 40
38 39
36 38
37
36
35

I must eliminate the numbers that appear in both columns.

here is the resultant column (the values that had no match in the other column)
40
37
35

1 reply

Posts
2
Registration date
Monday December 14, 2009
Status
Member
Last seen
December 15, 2009

OK, ***** note: ignore previous messages ** this is the good one --kkgirl

I still haven't sent the right data

first column
42
40
39
37

second column
42
39
38
37
35
32


I must eliminate the numbers that appear in both columns.

here is the resultant column (the values that had no match in the other column)
40
38
35
32