Two columns of 4-digit numbers and return uni [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello, I need a macro to compare two columns of numbers. And I am totally new at macros. I'll need some detailed instructions please.

I must eliminate the numbers that appear in both columns. These numbers may be listed in different rows though.
And it should leave me with the numbers that occurred only once.

data I should be left with only a right-hand column
42 42 41
40 41 37
39 40 35
38 39
36 38
37
36
35 thanks for any help. K

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
You talk about two columns in the first sentence but there are three columns in the data. Please rephrase your question. Also plese give what the result should be

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!