- Sub test()
- Dim arr, i&, j&
- i = Cells(Rows.Count, 1).End(3).Row
- arr = Cells(1, 1).Resize(i, 6)
- For j = 2 To UBound(arr)
- If arr(j, 3) >= arr(j, 4) And arr(j, 4) >= arr(j, 5) Then
- arr(j, 6) = "成绩单向"
- ElseIf arr(j, 3) <= arr(j, 4) And arr(j, 4) <= arr(j, 5) Then
- arr(j, 6) = "成绩单向"
- Else
- arr(j, 6) = "成绩波动"
- End If
- Next
- Cells(1, 1).Resize(i, 6) = arr
- End Sub
复制代码 |