|
Set d = CreateObject("scripting.dictionary")
r = Range("h" & Rows.Count).End(xlUp).Row
arr = Range("w5:ay" & r)
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 1 To UBound(arr)
If Not d.Exists(s) Then
m = m + 1
d(s) = m
brr(m, 1) = s
brr(m, 2) = 1
brr(m, 3) = arr(i, 1)
Else
brr(d(s), 2) = brr(d(s), 2) + 1
brr(d(s), 3) = brr(d(s), 3) + arr(i, 1)
End If
Next
For i = 1 To m
n = n + 1
brr(i, 1) = n
brr(i, 2) = brr(i, 2) & "a"
brr(i, 3) = brr(i, 3) & "b"
Next
想用datagrid来显示brr(i, 1) brr(i, 2) brr(i, 3) 3列数据,这代码怎么修改?
|
|