本帖最后由 duquancai 于 2019-1-18 01:46 编辑
我给你写详细一点吧!!!》》》》》》》》》》》》》》- Sub main()
- Dim c1 As Range, c2 As Range, r1&, r2&, arr(), brr, d As Object
- Set c1 = Range("a:b").Find("*", , , , 1, 2)
- If c1 Is Nothing Then Exit Sub
- r1 = c1.Row
- Set c2 = Range("e:f").Find("*", , , , 1, 2)
- If c2 Is Nothing Then Exit Sub
- r2 = c2.Row
- arr = Range("a1:b" & r1)
- brr = Range("e1:f" & r2)
- Set d = CreateObject("Scripting.Dictionary")
- For i = 1 To r1
- If Not d.exists("'" & arr(i, 1)) Then
- d("'" & arr(i, 1)) = arr(i, 2)
- Else
- d("'" & arr(i, 1)) = d("'" & arr(i, 1)) & "," & arr(i, 2)
- End If
- Next
- For i = 1 To r2
- brr(i, 2) = d("'" & brr(i, 1))
- Next
- Range("e1:f" & r2) = brr
- End Sub
复制代码 |