Formula/macro to match data between two columns

[Redwine01]

Hi guys,

I am new here. I am currently working on a project in the office where we need to do some audits. Part of that audit is to match id numbers between two columns and report.

I have added an example worksheet. In the example worksheet what we need to do is match column A and column B. If anything that is present in column A does not present in column B we need to note that number in column C. If the number is present in column B however not in column A then we need to put it in column D.

Currently we are doing this manually but i was thinking if there is any macro or formula i can use to automate the process so all we have to do is to enter the number in column A and B so that excel can auto calculate which number is present where and auto populate column C and D.

Any help is appreciated.

[BadlySpelledBuoy]

Hi and welcome
One method using a macro.

Please Login or Register  to view this content.

See attached.

BSB

[Pete_UK]

You can use these formulae in the cells stated:

C2: =IF(COUNTIF(B:B,A2)=0,A2,"")

D2: =IF(COUNTIF(A:A,B2)=0,B2,"")

Copy down as required. A number in either column indicates that it is not present in the other column, whereas a blank indicates that it is.

Hope this helps.

Pete

[Redwine01]

Thanks a lot guys. Will test it out thanks