|
本帖最后由 hhaa999 于 2014-4-13 14:08 编辑
统计数量
- Sub t()
- Dim arr(), i&, d As Object, s$, rng As Range
- arr = Range("A1").CurrentRegion.Value
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- s = Left(arr(i, 1), 4) & arr(i, 2)
- d(s) = d(s) + 1
- Next
- For Each rng In Range("G2:H4")
- rng = d(Cells(rng.Row, "F") & Left(Cells(1, rng.Column), 1))
- Next
- End Sub
复制代码
|
|