|
本帖最后由 YESS95 于 2012-6-6 11:52 编辑
来下载作业,十六字。
Sub aa() '作业代码写在该模块
Dim i As Integer
Dim arr()
Dim obj
Dim str As String
With Sheet1
str = .[g1].Value
arr = .Range(.[a2], .Cells(Rows.Count, "c").End(xlUp)).Value
Set obj = CreateObject("scripting.dictionary")
For i = 1 To UBound(arr, 1)
If str = "全部" Then
obj(arr(i, 1)) = arr(i, 3) + obj(arr(i, 1))
ElseIf arr(i, 2) = str Then obj(arr(i, 1)) = arr(i, 3) + obj(arr(i, 1))
End If
Next i
.[f3:g15].ClearContents
.[f3].Resize(obj.Count, 1) = WorksheetFunction.Transpose(obj.keys)
.[g3].Resize(obj.Count, 1) = WorksheetFunction.Transpose(obj.items)
End With
End Sub
|
评分
-
查看全部评分
|