|
代码优化下- Sub 合并同类项修改()
- Dim arr, i&, d, x
- arr = Range("a2:c" & Cells(Rows.Count, 1).End(3).Row)
- Set d = CreateObject("scripting.dictionary")
- For i = 1 To UBound(arr)
- x = arr(i, 2)
- d(x) = d(x) & "-" & arr(i, 1)
- Next
- For i = 1 To UBound(arr)
- x = arr(i, 2)
- If d.exists(x) And i = [b:b].Find(x, lookat:=xlWhole).Row - 1 Then
- arr(i, 3) = Mid(d(x) & ":" & arr(i, 2), 2)
- End If
- Next
- [c2].Resize(UBound(arr), 1) = Application.Index(arr, , 3)
- Columns(3).AutoFit
- End Sub
复制代码 |
评分
-
查看全部评分
|