本帖最后由 france723 于 2017-6-11 00:34 编辑
- Sub aaa()
- Dim y, ar, i, n, j, p, m
- n = 1
- y = Range("a65536").End(3).Row
- m = y
- ReDim ar(1 To y - 3343 + 1, 1 To 3)
- For i = 3343 To y
- ar(n, 1) = Cells(i, 1).Row
- ar(n, 2) = Val(Cells(i, 1))
- ar(n, 3) = Val(Cells(i, 2))
- n = n + 1
- Next i
- For j = 1 To UBound(ar)
- For p = 1 To UBound(ar)
- If ar(j, 2) = ar(p, 3) Then
- Cells(m, 4) = ar(j, 1)
- Cells(m, 5) = ar(j, 2)
- m = m - 1
- End If
- Next p
- Next j
- End Sub
复制代码
|