|
发表于 2013-8-23 17:31
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim A(), B(), d, i&, j&, s&
A = Sheets(1).Range("a1").CurrentRegion.Value
ReDim B(1 To UBound(A), 1 To UBound(A, 2))
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(A)
d(A(i, 4)) = d(A(i, 4)) + 1
Next i
For i = 2 To UBound(A)
If d(A(i, 4)) > 1 Then
s = s + 1
For j = 1 To UBound(A, 2)
B(s, j) = A(i, j)
Next j
End If
Next i
With Sheets(2)
.Range("a2:g65536").Clear
.Range("d:e").NumberFormatLocal = "000000"
.Range("a2").Resize(s, UBound(B, 2)) = B
End With
End Sub |
评分
-
查看全部评分
|