Sub CompteOccurences()
Set mondico = CreateObject("Scripting.Dictionary")
For Each c In Range("A1", [A65000].End(xlUp))
temp = c & "-" & c.Offset(, 1)
mondico(temp) = IIf(mondico.exists(temp), mondico(temp) + 1, 1)
Next c
a = mondico.keys
For i = 0 To UBound(a)
s = Split(a(i), "-")
Cells(i + 1, "I") = s(0)
Cells(i + 1, "J") = s(1) ' enlever si pas nécessaire
Next
[K1].Resize(mondico.Count, 1) = Application.Transpose(mondico.items)
End Sub