|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
学习一下字典,打扰了
Sub test()
lastr = Cells(Rows.Count, "b").End(xlUp).Row
arr = Range("b1:d" & lastr)
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(arr)
If Not d.exists(arr(i, 2)) Then
d(arr(i, 2)) = arr(i, 1) & arr(i, 3)
Else
d(arr(i, 2)) = d(arr(i, 2)) & "+" & arr(i, 1) & arr(i, 3)
arr(i, 2) = vbNullString
End If
Next
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 1 To UBound(arr)
If arr(i, 2) <> "" Then
brr(i, 1) = d(arr(i, 2))
End If
Next
[f1].Resize(UBound(brr), 1) = brr
End Sub |
评分
-
1
查看全部评分
-
|