Finding out the difference between two sets of codes -repetitive codes and interchanged

Hi All,

Hope you are doing well!...I am trying to understand difference between the set of codes -Code1 and Code2 columns...Addedcode is which is there in Code2 but is not there in Code1 ,Deletedcode is which is there in Code1 but not there in Code2.... Also if the same codes are arranged in different order in code 1 and code 2 then there is no difference - the added code and deleted code column will be blank... Can you please help me... Attached the sheet...


Thanks,
Arun

UDF
Use in cell like
For Excel version with spill functionality.
=AddDel(A2,B2)
the copy down

For non spill version
=AddDel($A2,$B2,COLUMN(A1))
copy to the right + down

Please Login or Register  to view this content.

@ Jindon: This works!!!..Really appreciate your help!..