Sub Mediane()
For i = 5 To 21
Worksheets("Feuil1").Cells(i, 37).Formula = "=MEDIAN(C" & i & ",E" & i & ",G" & i & ",I" & i & ",K" & i & ",M" & i & ",O" & i & ",Q" & i & ",S" & i & ",U" & i & ",W" & i & ",Y" & i & ",AA" & i & ",AC" & i & ",AE" & i & ",AG" & i & ",AI" & i & ")"
Next
End Sub