|
发表于 2014-10-19 22:25
|
显示全部楼层
本楼为最佳答案
Sub aa()
Set d = CreateObject("scripting.dictionary")
arr = Range("a3").CurrentRegion
For i = 2 To UBound(arr)
zf = arr(i, 2) & "," & arr(i, 3)
If Not d.exists(zf) Then
d(zf) = arr(i, 4)
Else
If InStr("," & d(zf) & ",", "," & arr(i, 4) & ",") = 0 Then d(zf) = d(zf) & "," & arr(i, 4)
End If
Next
End Sub
|
|