|
Sub kk()
Dim dic As Object, last_row As Long
Set dic = CreateObject("scripting.dictionary")
With Sheet1
last_row = .Cells(Rows.Count, 2).End(3).Row
arr = .Range("B11:F" & last_row).Value
For i = 1 To UBound(arr)
If dic.exists(arr(i, 1)) = False Then
Set dic(arr(i, 1)) = CreateObject("scripting.dictionary")
End If
dic(arr(i, 1))(arr(i, 5)) = ""
Next i
For i = 3 To 7
.Range("E" & i).Value = dic(.Range("c" & i).Value).Count
Next i
End With
Set dic = noting
End Sub
|
|