With Sheets("Choix")
Set Plage = .Range("C3", .Cells(.Rows.Count, 3).End(xlUp)) ' notes
For Each c In .Range("F3", .Cells(.Rows.Count, 6).Cells.End(xlUp)) '
If c.Offset(, -5) = "" Then Exit For
c.Offset(, 1) = Format(Application.Rank(c.Offset(, -3), Plage), "000") & "_" & _
c.Value
[Choix!F1] = [Choix_Expos!F1] + 1 m
[Choix!G1] = c.Offset(, 1).Value
Next c