Match identical numbers in two columns and display unmatched results

Hi all,

Please help me with this problem. Ive been searching answers for couple days. Unfortunately, none of formula or macro works.

I have two columns with hundreds of identical data and i need to match in column A with an identical data in column B.

The tricky thing is there are many identical data. Each identical data needs to match with another identical data in column B and then, remove matched data.

So, i need to display whats left unmatched in column A and in column B.Match Identical Data.xlsx

Here is an example:

Column A

100
200
300
400
100


Column B

400
200
300
100
500


Ending results should be showing unmatched "Column A: 100" & "column B:500"

I also attached a excel if it helps.

Thanks so much if you guys can help me with this one!!!

Thanks Bsalv for fast responding. After I run the macro, excel only display text "column 1" and "column 2", nothing else. Should I do anything before I run this macro?

Originally Posted by bsalv

Please Login or Register  to view this content.

Hi MarvinP,

I also thought the OP example was wrong but then I reread it carefully and convinced myself the expect result made sense

The key in OP is to "clear the two cells in col A & B" when a match is found. This would leave 500 in Col B and the second instance of 100 in Col A, by the time you get to the second 100 in col A there will not be a match in col b

Having said that I haven't done any work on how I might solve the problem, initial thought was a loop down both cols but I suspect that might be a bit slow if there are lots of entries to process.

Might have a play later in the evening if there hasn't been a solution posted by then

jmac

hi currycai,

if your data start from cells(31) in cols A and B (as in your download file),
does running this macro give what you want?

Please Login or Register  to view this content.