|
Sub demo()
Set d = CreateObject("scripting.dictionary")
arr = Sheets("Sheet1").[a1].CurrentRegion
For i = 2 To UBound(arr)
If Not d.exists(arr(i, 5)) Then
Set d(arr(i, 5)) = CreateObject("scripting.dictionary")
Set d(arr(i, 5) & "網貸") = CreateObject("scripting.dictionary")
End If
d(arr(i, 5))(arr(i, 3)) = ""
If arr(i, 4) = "網貸" Then d(arr(i, 5) & "網貸")(arr(i, 3)) = ""
Next
With Sheets("Sheet2")
r = .[B65536].End(xlUp).Row
For i = 3 To r
.Cells(i, 5).Value = d(.Cells(i, 2).Value).Count
.Cells(i, 8).Value = d(.Cells(i, 2).Value & "網貸").Count
Next
End With
End Sub
祝順心,南無阿彌陀佛!
|
|