|
本帖最后由 sry660 于 2015-12-4 18:49 编辑
- Sub 修改grf老师的代码()
- arr = Sheet2.[a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 6)
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- x = arr(i, 2) & arr(i, 3) & arr(i, 4) '年级+项目+赛别为key
- If Not d.exists(x) Then
- n = n + 1
- d(x) = n
- brr(n, 1) = n
- brr(n, 2) = arr(i, 2)
- brr(n, 3) = arr(i, 3)
- brr(n, 4) = arr(i, 4)
- brr(n, 5) = 1
- Else
- p = d(x)
- brr(p, 5) = brr(p, 5) + 1
- End If
- For j = 1 To UBound(brr)
- If brr(j, 5) < 6 Then
- brr(j, 6) = 1
- ElseIf brr(j, 5) < 12 Then
- brr(j, 6) = 2
- ElseIf brr(j, 5) < 18 Then
- brr(j, 6) = 3
- Else
- brr(j, 6) = 4
- End If
- Next
- Next
- Sheet1.[a2:f500].ClearContents
- Sheet1.[a2].Resize(n, 6) = brr
- End Sub
复制代码 |
|