|
Sub Click()
Dim A, B, i, j, k
Application.ScreenUpdating = False
i = Range("a655536").End(xlUp).Row
Range([b31], Range("ad" & i)).ClearContents
A = Range("a1:ad" & i)
For i = 31 To UBound(A)
ReDim B(1 To UBound(A, 2))
For j = 2 To UBound(A, 2)
If Len(A(i - j + 1, 1)) Then B(A(i - j + 1, 1)) = B(A(i - j + 1, 1)) + 1
Next j
For j = 2 To UBound(A, 2)
If Len(A(i - j + 1, 1)) Then
If B(A(i - j + 1, 1)) = 1 Then A(i, j) = A(i - j + 1, 1)
End If
Next j
Next i
[a1].Resize(UBound(A), UBound(A, 2)) = A
Range([b31], Range("ad" & i - 1)).SpecialCells(xlCellTypeBlanks).Delete 1
End Sub
12.rar
(68.25 KB, 下载次数: 3)
|
|