改成这样试试: Sub test() Dim arr, i%, j%, k%, arrt(0 To 9, 1 To 2) Dim d As Object With Sheets("数据源") arr = .Range("c3:e" & .[c65536].End(3).Row) End With For i = 1 To 3 Set d = CreateObject("Scripting.Dictionary") For j = 1 To UBound(arr) - 1 If CInt(arr(j, i)) = Cells(3, i * 2) Then d(CInt(arr(j + 1, i))) = d(CInt(arr(j + 1, i))) + 1 End If Next For k = 0 To 9 arrt(k, 1) = k arrt(k, 2) = d(k) Next Cells(6, i * 2).Resize(10, 2) = arrt Set d = Nothing Next End Sub
|