Please help me modify an exising macro to recognise duplicates

[scripted]

I have two columns of data in column a and b and I am using the following macro to find the difference in each of the columns.

Please Login or Register  to view this content.

This works great but there is a problem and it’s this. If there is a duplicate value in columns a so the data appears twice in column a but only once in columns b the macro does not identify this as a difference.
The data in both columns are alphanumerical in nature e.g.

Column A Column B Column C Column D
A103345 A103345 In A not in B In Column B not in A
A103389 A103389
A103389 A107799
A107799 A109999
A109999

Using the compare macro above I want it to work as above but to also identify that A103389 only appears in column B once but is in column A twice and list this as a difference in column in column C.
I would appreciate if you can just tell me what I need to do as simply as possible as I am pretty poor with Excel if I am honest.

[Sa DQ]

Please Login or Register  to view this content.

[scripted]

Hi. Sa DQ

I can see what the code above is trying to do but unfortunatley I can have approx 2000 individual rows of data to compare some of them will be genuinly duplicated others may even have 3 entries in one column but only 2 in the other and with that many its really difficlut to see where the differences are.

currently I am using a combination of macro's to find differences, the first cleans the macro of additional white spaces so they are not classed by Excel as differences.
The second macro is the one I posted which lists the differences but Excel doesnt understand duplicate entries properly.

I dont mind using more macros as long as it pulls out the information I need without me manually having to pull each difference out. Doing it in this way takes a long time or can do if there are 200 + differences in a list of 2000 rows.

Any further thoughts?
I have attached a copy of the kind of data I need to compare and hopefully you will see what I need to do.