|
发表于 2014-2-28 11:16
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, d, d2, i&, j&, x, y, w
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- [b:b].ClearContents
- arr = Range("g1").CurrentRegion
- For j = 1 To UBound(arr, 2)
- For i = 2 To UBound(arr)
- x = Replace(arr(1, j), "对应", "")
- If arr(i, j) <> "" Then d(x) = d(x) & "," & arr(i, j)
- Next
- Next
- w = Split([a1])
- For i = 0 To UBound(w)
- y = Split(d(w(i)), ",")
- For j = 1 To UBound(y)
- d2(y(j)) = ""
- Next
- Next
- Range("b1").Resize(d2.Count) = Application.Transpose(d2.keys)
- End Sub
复制代码 |
|