- Sub Macro1()
- Dim arr, brr, i&, j%, s&, y&, x&
- arr = Range("b33").CurrentRegion
- x = UBound(arr)
- ReDim brr(1 To x, 1 To UBound(arr, 2) - 1)
- For i = x To 1 Step -1
- s = x + 1 - i: y = i - s
- If y < 1 Then Exit For
- For j = 2 To UBound(arr, 2)
- If arr(i, j) = arr(y, j) Then brr(s, j - 1) = arr(i, j)
- Next
- Next
- Cells(x + 36, 2).Resize(s, UBound(brr, 2)) = brr
- End Sub
复制代码 |