Bonjour.
Voici une façon de comparer la Colonne F avec la colonne E.
Sub tt()
For i = 4 To Range("F" & Rows.Count).End(xlUp).Row
diff = ""
t = Split(Cells(i, "F"), ",")
a = "," & Cells(i, "E") & ","
For j = 0 To UBound(t)
b = InStr(a, "," & t(j) & ",")
If b = 0 Then
diff = diff & "," & t(j)
End If
Next
Cells(i, "H").NumberFormat = "@"
Cells(i, "H") = Mid(diff, 2)
Next
End Sub
Cordialement
Docmarti