- Sub aaa()
- Dim arr, brr, i&, d As Object, r&
- Set d = CreateObject("scripting.dictionary")
- arr = Range("f2:k" & [f65536].End(3).Row)
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If arr(i, 6) = "N" Then
- If Not d.exists(arr(i, 1)) Then
- r = r + 1
- d(arr(i, 1)) = r
- brr(r, 1) = arr(i, 1)
- End If
- brr(d(arr(i, 1)), 2) = brr(d(arr(i, 1)), 2) & "," & arr(i, 5)
- End If
- Next i
- For i = 1 To r
- brr(i, 2) = "'" & Mid(brr(i, 2), 2)
- Next i
- [l2].Resize(r, 2) = brr
- End Sub
复制代码 |