|
Sub 找出B列的重复值() '每组都有的,因为B列中有很多组数据
Dim Arr, i&, Myr&, n&, Arr1(), r&, Arr2()
Dim d, k, t, ks, js, j&
Set d = CreateObject("Scripting.Dictionary")
[C:C].ClearContents
Myr = Cells(Rows.Count, 2).End(xlUp).Row
Arr = Range("B1:B" & Myr)
For i = 1 To UBound(Arr)
If Arr(i, 1) = "期间" Then
n = n + 1
ReDim Preserve Arr1(1 To n)
Arr1(n) = i
End If
Next
For i = 1 To n
If i <> n Then
js = Arr1(i + 1) - 1
Else
js = UBound(Arr)
End If
ks = Arr1(i) + 1
For j = ks To js
If Arr(j, 1) <> "" Then
d(Arr(j, 1)) = d(Arr(j, 1)) + 1
End If
Next
Next
k = d.keys: t = d.items
ReDim Preserve Arr2(1 To Cells(Rows.Count, 2).End(3).Row, 1 To 1)
For i = 0 To UBound(k)
If t(i) = n Then
r = r + 1
Arr2(r, 1) = k(i)
End If
Next
[C1] = "期间"
[C2].Resize(r, 1) = Arr2
End Sub
|
评分
-
查看全部评分
|