|
本帖最后由 xdragon 于 2013-9-25 10:31 编辑
- Sub test()
- On Error Resume Next
- Dim name As New Collection, arr(), brr(), i, j, n
- arr = Range("A1").CurrentRegion
- For i = 1 To UBound(arr)
- name.Add arr(i, 1), arr(i, 1)
- Next
- ReDim brr(1 To name.Count, 1 To 2)
- For Each n In name
- j = j + 1
- brr(j, 1) = n
- For i = 1 To UBound(arr)
- If brr(j, 1) = arr(i, 1) Then brr(j, 2) = brr(j, 2) & arr(i, 2) & "、"
- Next
- brr(j, 2) = Left(brr(j, 2), Len(brr(j, 2)) - 1)
- Next
- Range("D1:E" & UBound(brr)) = brr
- End Sub
复制代码 VBA做的。。。 |
评分
-
查看全部评分
|