|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
这样吗?
Sub TEST()
Set d = CreateObject("Scripting.Dictionary")
R = Sheets(1).Range("A65536").End(3).Row
ARR = Sheets(1).Range("A4:I" & R)
For I = 1 To UBound(ARR)
If Not d.EXISTS(ARR(I, 3)) Then
d(ARR(I, 3)) = ""
Set d(ARR(I, 3)) = CreateObject("Scripting.Dictionary")
d(ARR(I, 3))(ARR(I, 9)) = ""
Else
d(ARR(I, 3))(ARR(I, 9)) = ""
End If
Next
With Sheets("Sheet2")
.[A1:B1] = Array("机构名称", "客户数量")
N = 1
For Each d1 In d
N = N + 1
.Cells(N, 1) = d1
.Cells(N, 2) = d(d1).Count
Next
End With
End Sub
|
|