|
求大神指教,在汇总SHeet1数据时,输出时同一单号不同编号的数据在Sheet2中用"、"分割;
但怎样把重复的编号不进行汇总
Sub 合并()
Dim d, d1, arr, k As Integer, m As Long, n As Long, str
Set d = CreateObject("scripting.dictionary")
arr = Sheet1.Range("A1:E" & Sheet1.[A65536].End(xlUp).Row)
With Sheet2
For k = 2 To UBound(arr)
str = arr(k, 1) & "|" & arr(k, 4)
If Not d.exists(str) Then
d(str) = arr(k, 4)
Else
d(str) = d(str) & "、" & arr(k, 4)
End If
Next k
For k = 0 To d.Count - 1
str = Split(d.keys()(k), "|")
n = n + 1
arr(n, 1) = str(0)
arr(n, 2) = d(d.keys()(k))
Next k
Sheet2.Range("A2:K65536").ClearContents
Sheet2.Range("A65536").End(xlUp).Offset(1, 0).Resize(k, 2) = arr
End With
End Sub
合并数据.zip
(17.16 KB, 下载次数: 4)
|
|