macro for two columns -- find unique ones Closed

Question

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

kkgirl · Answer

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

Macro for two columns -- find unique ones

1 response

Similar discussions

Subscribe To Our Newsletter!