1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| Sub quinté()
Dim i As Integer
Dim j As Integer
Dim pos1 As Integer
Dim pos2 As Integer
Dim pos3 As Integer
Dim pos4 As Integer
Dim pos5 As Integer
Dim cel1 As Range
Dim cel2 As Range
For Each cel1 In Worksheets("Résultat").Range("A1", Range("A65356").End(xlUp))
i = 0
pos1 = 10
pos2 = 0
pos3 = 0
pos4 = 0
pos5 = 0
For Each cel2 In Range(cel1, cel1.Offset(0, 7))
i = i + 1
If cel2.Value = cel1.Offset(0, 11).Value Then
cel1.Offset(0, 20).Value = "Gagnant"
pos1 = i
ElseIf cel2.Value = cel1.Offset(0, 12).Value Then
cel1.Offset(0, 21).Value = "Placé"
pos2 = i
ElseIf cel2.Value = cel1.Offset(0, 13).Value Then
cel1.Offset(0, 22).Value = "Placé"
pos3 = i
ElseIf cel2.Value = cel1.Offset(0, 14).Value Then
pos4 = i
ElseIf cel2.Value = cel1.Offset(0, 15).Value Then
pos5 = i
End If
Next
If pos1 < pos2 And pos2 < pos3 Then cel1.Offset(0, 23).Value = "gagnant tiercé ordre"
If cel1.Offset(0, 20) <> vide And cel1.Offset(0, 21) <> vide And cel1.Offset(0, 22) <> vide Then cel1.Offset(0, 24) = "gagnant désordre"
If cel1.Offset(0, 23) <> vide And pos3 < pos4 Then cel1.Offset(0, 25).Value = "gagnant quarté ordre"
If cel1.Offset(0, 24) <> vide And pos4 <> 0 Then cel1.Offset(0, 26) = "gagnant quarté désordre"
If cel1.Offset(0, 25) <> vide And pos4 < pos5 Then cel1.Offset(0, 27).Value = "gagnant quinté ordre"
If cel1.Offset(0, 26) <> vide And pos5 <> 0 Then cel1.Offset(0, 28).Value = "gagnant quinté désordre"
For Each cel2 In Range(cel1.Offset(0, 20), cel1.Offset(0, 28))
If cel2 = vide Then cel2.Value = "perdu"
Next
Next
End Sub |
Partager