|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 处理()
- Dim Arr, Brr, drow%, i%, j%, d
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("评分表")
- drow = .Range("a65536").End(3).Row
- Arr = .Range("a2:d" & drow)
- End With
- With Worksheets("九宫格")
- Brr = .Range("a1:d4")
- For i = 1 To UBound(Arr)
- If Arr(i, 3) < 60 Then
- Arr(i, 4) = "60以下"
- ElseIf Arr(i, 3) >= 60 And Arr(i, 3) <= 80 Then
- Arr(i, 4) = "60-80"
- Else
- Arr(i, 4) = "81-100"
- End If
- If Not d.exists(Arr(i, 2) & Arr(i, 4)) Then
- d(Arr(i, 2) & Arr(i, 4)) = Arr(i, 1)
- Else
- d(Arr(i, 2) & Arr(i, 4)) = d(Arr(i, 2) & Arr(i, 4)) & "," & Arr(i, 1)
- End If
- Next
- ' MsgBox 1
- For i = 2 To UBound(Brr)
- For j = 2 To UBound(Brr, 2)
- Brr(i, j) = d(Brr(i, 1) & Brr(1, j))
- Next
- Next
- .Range("a1").Resize(UBound(Brr), UBound(Brr, 2)) = Brr
- End With
- End Sub
复制代码 |
|