Application.ScreenUpdating = False
With Sheets("Classement")
.Rows("2:301").Delete Shift:=xlUp
.Range("B2:B301").Value = Sheets("RECAP").Range("A3:A303").Value
.Range("C2:C301").Value = Sheets("RECAP").Range("B3:B303").Value
.Range("A1:C301").Sort Key1:=.Range("C2"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
.Range("A2").FormulaR1C1 = "=ROW(RC[2])-1"
.Range("A3").FormulaR1C1 = "=IF(RC[2]=R[-1]C[2],R[-1]C,ROW(RC[2])-1)"
.Range("A3").AutoFill Destination:=.Range("A3:A301"), Type:=xlFillDefault
With .Range("A2:A301")
.Value = .Value
End With
.Range("C2:C301").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End With