|
如果仅仅是统计人数,用公式就行了- Sub Macro1()
- Dim arr, brr, d, i&, zf$$
- Set d = CreateObject("scripting.dictionary")
- arr = Range("a1").CurrentRegion
- brr = Sheets("数据表").Range("a1").CurrentRegion
- For i = 2 To UBound(brr)
- zf = brr(i, 4) & "," & brr(i, 6)
- d(zf) = d(zf) + 1
- Next
- For i = 3 To UBound(arr)
- zf = arr(i, 2) & "," & arr(i, 3)
- arr(i, 4) = d(zf)
- Next
- Range("d1").Resize(UBound(arr)) = Application.Index(arr, 0, 4)
- End Sub
复制代码 |
|