Cross Checking to columns of figures, complicated by duplications

[simdod]

Hello

I’m new to this and hope you may be able to help.

I regularly get two columns of figures which I want to import into columns B and C in a worksheet. The goal is to end up with both columns the same. I therefore need to identify the differences between the columns. The problem is that the figures are not unique so they can appear several times. For instance if 150 appears 5 times in column B but only four times in column C I need to know that there is one un-matched example in column B. I can then investigate to see if I have to remove it from B or add it to C.

There could be single figures entered in one column only.

Ideally the problem figures would appear in columns A and D so as to make identifying them easy.

If the figures were unique I could do it, but it is the fact that they are potentially multiple which is causing me the problem.

I’d be very grateful for any help or advice. If possible I’d rather it was only solved by using formulas and not VBA – but if it has to be that way then so be it.

Many thanks

 

[mole999]

Please note I had to remove your blocking code which display improperly on the site