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

Function AddDel(txt1 As String, txt2 As String, Optional ref As Long)
    Dim w, x, y, i As Long, ii As Long
    x = Split(txt1, ","): y = Split(txt2, ",")
    For i = 0 To UBound(x)
        For ii = 0 To UBound(y)
            If (y(ii) <> Chr(2)) * (x(i) = y(ii)) Then
                x(i) = Chr(2): y(ii) = Chr(2): Exit For
            End If
        Next
    Next
    x = Filter(x, Chr(2), 0): y = Filter(y, Chr(2), 0)
    If UBound(x) > -1 Then
        x = Join(x, ",")
    Else
        x = vbNullString
    End If
    If UBound(y) > -1 Then
        y = Join(y, ",")
    Else
        y = vbNullString
    End If
    w = Array(y, x)
    If ref Then
        AddDel = w(ref - 1)
    Else
        AddDel = w
    End If
End Function

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