|
- Sub 汇总求平均值()
- Dim ar, br(1 To 100, 1 To 9), cr(1 To 100)
- Dim d As Object
- Dim i As Integer, j As Integer, k As Integer, s As Integer
- Set d = CreateObject("scripting.dictionary")
- ar = Range("a1").CurrentRegion
- For i = 2 To UBound(ar)
- If d.exists(ar(i, 1)) Then
- s = d(ar(i, 1))
- cr(s) = cr(s) + 1
- For j = 2 To 9
- br(s, j) = br(s, j) + ar(i, j)
- Next
- Else
- k = k + 1
- d(ar(i, 1)) = k
- cr(k) = 1
- For j = 1 To 9
- br(k, j) = ar(i, j)
- Next
- End If
- Next
- For i = 1 To k
- For j = 2 To 9
- br(i, j) = br(i, j) / cr(i)
- Next
- Next
- Range("k1").Resize(1, 9) = Range("a1:i1").Value
- Range("k2").Resize(k, 9) = br
- End Sub
复制代码 |
|