1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
For g = 9 To 300
While Cells(g, 3) <> ""
Cells(g, e + 2).Formula = "=Min(" & Range(Cells(g, 5), Cells(g, e - 1)).Address & ")"
Cells(g, e + 3).Formula = "=Max(" & Range(Cells(g, 5), Cells(g, e - 1)).Address & ")"
If Cells(g, e).Value <> 0 And Cells(g, e).Value <> "" And Cells(g, e + 3).Value <> 0 Then
Cells(g, e + 5).Value = (Cells(g, e + 3).Value) / (Cells(g, e).Value)
Cells(g, e + 3).Formula = "=INDEX(" & Range(Cells(8, 5), Cells(8, e - 1)) & ":" & Range(Cells(g, 5), Cells(g, e - 1)) & ",1," & "MATCH(" & Cells(g, e + 3).Value & "," & Range(Cells(g, 5), Cells(g, e - 1)) & ",0))"
End If
g = g + 1
Wend
Next |
Partager