数组方法你应该已经会了,前面类似的问题已经解决了很多。字典更不用说了。
仅给出数组方法。
- Sub aaa()
- Dim arr, brr, i&, j&, r&, s$
- arr = [a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 2 To UBound(arr)
- If arr(i, 2) <> "" Then
- r = r + 1
- brr(r, 1) = arr(i, 2)
- s = arr(i, 2)
- For j = i To UBound(arr)
- If arr(j, 2) = s Then
- brr(r, 2) = brr(r, 2) + arr(j, 3)
- arr(j, 2) = ""
- End If
- Next j
- End If
- Next i
- [e1].Resize(r, 2) = brr
- End Sub
复制代码 |