Sub essai()
Dim Tab_Datas
Set Tab_Datas = CreateObject("scripting.dictionary")
' date,nbligne,nbanomalie
With Feuil1
l = 2
While .Cells(l, 1) <> ""
cle = Trim(.Cells(l, 1))
d1 = .Cells(l, 6)
tmp1 = 0
If .Cells(l, 7) = "O" Then tmp1 = 1
If Tab_Datas.exists(cle) = False Then
Tab_Datas(cle) = Array(d1, 1, tmp1)
Else
tmp = Tab_Datas(cle)
tmp(0) = d1
tmp(1) = tmp(1) + 1
tmp(2) = tmp(2) + tmp1
Tab_Datas(cle) = tmp
End If
l = l + 1
Wend
End With
'====================================
' ecriture resultat
'====================================
Feuil2.Select
l = 2
For Each cle In Tab_Datas
Cells(l, 1) = cle
tmp = Tab_Datas(cle)
Cells(l, 2) = tmp(0)
Cells(l, 3) = tmp(1)
Cells(l, 4) = tmp(2)
l = l + 1
Next
End Sub