|
vba 写的
Sub kk()
Dim arr(), brr(), dic As Object
Set dic = CreateObject("scripting.dictionary")
irow = Sheet1.Cells(Rows.Count, 1).End(3).Row
arr = Sheet1.Range("a3:c" & irow)
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 1 To UBound(arr)
If arr(i, 3) = 0 And arr(i, 3) <> "" Then
If dic.exists(arr(i, 1)) = False Then
dic(arr(i, 1)) = arr(i, 2)
Else
dic(arr(i, 1)) = dic(arr(i, 1)) & "、" & arr(i, 2)
End If
End If
Next i
For i = 1 To dic.Count
brr(i, 1) = dic.keys()(i - 1)
brr(i, 2) = dic.items()(i - 1)
Next i
Sheet1.Range("e3:f65536").ClearContents
Sheet1.Range("e3").Resize(dic.Count, 2) = brr
End Sub
|
评分
-
查看全部评分
|