用VB统计重复时间的个数

saghj

。。。。。。。。。。。。。。。。。。。

680926

=IF(COUNTIF(G:G,G2)<2,"",COUNTIF(G:G,G2))

Sub 统计日期时间的重复个数()
Dim arr
Dim i As Integer, m, k, endrow
Dim d As Object
Dim brr()
Set d = CreateObject("scripting.dictionary")
arr = Range("g1", Range("g65536").End(xlUp))
endrow = UBound(arr)
ReDim brr(1 To endrow)
For i = 2 To UBound(arr)
    d(arr(i, 1)) = d(arr(i, 1)) + 1
Next
For k = 2 To UBound(arr)
    m = d(arr(k, 1))
    If m < 2 Then
        brr(k) = ""
    Else
        brr(k) = m
    End If
Next
[t1].Resize(UBound(arr), 1) = Application.Transpose(brr)
End Sub

zhangcheng6688

Sub test()
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
   If arr(i, 7) <> "" Then
      If Not d.exists(arr(i, 7)) Then
         d(arr(i, 7)) = 1
      Else
         d(arr(i, 7)) = d(arr(i, 7)) + 1
      End If
   End If
Next
For i = 2 To UBound(arr)
   If d(arr(i, 7)) > 1 Then
      arr(i, 19) = d.Item(arr(i, 7))
   Else
      arr(i, 19) = ""
   End If
Next
[a1].CurrentRegion = arr
End Sub