Sub test()
Dim i, j, k, myr, arr
Set myr = Range("a:a").Find("输出", lookat:=xlWhole)
If myr Is Nothing Then MsgBox "未找到_输出_所在!": Exit Sub
arr = [a1].CurrentRegion
For i = myr.Row + 1 To myr.End(xlDown).Row
For j = 2 To UBound(arr)
If arr(j, 1) = Cells(i, 1) Then
For k = 2 To UBound(arr, 2)
If Not Cells(i, k) Like "*" & arr(j, k) & "*" Then
If Cells(i, k) = "" Then
Cells(i, k) = arr(j, k)
Else
Cells(i, k) = Cells(i, k) & "|" & arr(j, k)
End If
End If
Next k
End If
Next
Next
End Sub
最近搞这个,来贴吧就少了