按照不会出现同样型号写了段,看看是否ok吧!{:3512:}- Sub test()
- Dim d As Object
- Dim ar, br(1 To 10000, 1 To 3)
- Dim sr As String
- Dim i As Long, j As Long
- Set d = CreateObject("scripting.dictionary")
- ar = Cells(1, 1).CurrentRegion
- j = 1
- br(j, 1) = "工单单号": br(j, 2) = "工单日期": br(j, 3) = "规格型号"
- For i = 2 To UBound(ar)
- sr = ar(i, 2) & vbTab & ar(i, 3)
- If d.exists(sr) Then
- br(d(sr), 3) = br(d(sr), 3) & "," & ar(i, 6)
- Else
- j = j + 1
- d.Add sr, j
- br(j, 1) = ar(i, 2)
- br(j, 2) = ar(i, 3)
- br(j, 3) = ar(i, 6)
- End If
- Next i
- With Cells(1, 17)
- .Resize(Rows.Count).ClearContents
- .Resize(j, 3) = br
- End With
- End Sub
复制代码
|