=SI(GRANDE.VALEUR(NB.SI(C4:D13;C4:D13);MAX(NB.SI(C4:D13;C4:D13)+1))=MAX(NB.SI(C4:D13;C4:D13));"doublons";INDEX(A1:D13;
ENT(MIN(SI(MAX(NB.SI(C4:D13;C4:D13))=NB.SI(C4:D13;C4:D13);LIGNE(C4:D13)+COLONNE(C4:D13)/100000)));
ARRONDI(100000*MOD(MIN(SI(MAX(NB.SI(C4:D13;C4:D13))=NB.SI(C4:D13;C4:D13);LIGNE(C4:D13)+COLONNE(C4:D13)/100000));1);0)))
Function Maxi(r As Range)
Dim d As Object
Set d = CreateObject("Scripting.dictionary")
For Each r In r
d(r.Value) = d(r.Value) + 1
Next
Maxi = Application.Max(d.items) 'fréquence max
Maxi = Application.Match(Maxi, d.items, 0) 'rang dans la liste
Maxi = Application.Index(d.keys, Maxi) 'Nom
End Function
Function Maxi(r As Range)
Dim d As Object, n&
Set d = CreateObject("Scripting.dictionary")
For Each r In r
d(r.Value) = d(r.Value) + 1
Next
n = Application.Max(d.items) 'fréquence max
Maxi = Application.Match(n, d.items, 0) 'rang dans la liste
Maxi = Application.Index(d.keys, Maxi) & " " & n 'Nom + n
End Function