|
- Sub 等级()
- Dim ARR, BRR(), I As Integer, J As Integer, K As Integer, L As Integer, C As Integer, S As Integer
- ARR = Range("A1").CurrentRegion
- I = UBound(ARR)
- ReDim BRR(1 To I - 1)
- Range("D2:D" & I).Clear
- For J = 2 To I
- C = 0
- S = 0
- For K = 2 To I
- If ARR(J, 1) = ARR(K, 1) Then
- C = C + 1
- S = S + ARR(K, 3)
- End If
- Next
- L = L + 1
- If S > 250 And C >= 3 Then
- BRR(L) = "优秀"
- ElseIf S > 250 And C < 3 Then
- BRR(L) = "良好"
- Else
- BRR(L) = "中等"
- End If
- Next
- Range("D2").Resize(L, 1) = Application.Transpose(BRR)
- End Sub
复制代码
我也是个新手。拿来练习一下。感觉这个运行是比较写法应该是比较 慢的。欢迎各位老师指正。 |
|