|
发表于 2015-5-4 16:24
|
显示全部楼层
本楼为最佳答案
- Sub test1()
- nj = [e9] '年级
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("3").[I1].CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1) & arr(i, 2)) = arr(i, 3) '年级+名次的分值
- d(arr(i, 1) & arr(i, 2) & "破") = arr(i, 3) + 7 '年级+名次+破记录的分值
- Next
-
- With Sheets("2")
- .Range("l5:l1000").ClearContents
- r = .[j65536].End(3).Row
- brr = .Range("j4:L" & r)
- For i = 2 To UBound(brr)
- brr(i, 3) = d(nj & brr(i, 1) & brr(i, 2))
- Next
- .[l4].Resize(i - 1) = Application.Index(brr, , 3)
- End With
- End Sub
复制代码 |
|