Macro for two columns -- find unique ones

Closed
kkgirl Posts 2 Registration date Monday December 14, 2009 Status Member Last seen December 15, 2009 - Dec 15, 2009 at 09:09 AM
kkgirl Posts 2 Registration date Monday December 14, 2009 Status Member Last seen December 15, 2009 - Dec 15, 2009 at 09:21 AM
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 response

kkgirl Posts 2 Registration date Monday December 14, 2009 Status Member Last seen December 15, 2009
Dec 15, 2009 at 09:21 AM
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
0