草寫個vba, 能用則用:
Sub TEST()
Dim Arr, xD, i&, T1$, T2$, R&, N&
Sheets("Sheet2").UsedRange.Offset(1, 0).EntireRow.Delete
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([B1], Cells(Rows.Count, 5).End(3))
For i = 2 To UBound(Arr)
T1 = Arr(i, 1): T2 = Arr(i, 4)
If T1 = "" Or T2 = "" Then GoTo 101
If Val(xD(T1 & T2)) = 1 Then GoTo 101
R = xD(T2): xD(T1 & T2) = 1
If R = 0 Then
N = N + 1: xD(T2) = N
Arr(N, 1) = N: Arr(N, 2) = T2: Arr(N, 3) = T1: GoTo 101
End If
Arr(R, 3) = Arr(R, 3) & Chr(10) & T1
101: Next i
With [Sheet2!A2:C2].Resize(N): .Value = Arr: Application.Goto .Item(1): End With
End Sub
Xl0000148.rar
(11.23 KB, 下载次数: 2)
|