|
- Sub test()
- Dim i As Long, j As Long
- Dim arr, brr()
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- arr = Range("c4:c" & Range("c65536").End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- j = d(arr(i, 1))
- brr(j, 1) = brr(j, 1) + 1
- Else
- d(arr(i, 1)) = i
- brr(i, 1) = 1
- End If
- Next
- Range("d4:d65536").ClearContents
- Range("d4").Resize(UBound(brr), 1) = brr
- End Sub
复制代码 |
|