|
发表于 2017-7-8 17:23
|
显示全部楼层
本楼为最佳答案
- Sub QE()
- Dim ar, br
- Dim i As Long, j As Long, k As Long, sum
- Dim rg As Range
- ar = Range("b1:c" & Cells(Rows.Count, 2).End(xlUp).Row)
- Set rg = Range("e1:g" & Cells(Rows.Count, 5).End(xlUp).Row)
- br = rg
- For i = 2 To UBound(br)
- k = 1
- sum = 0
- For j = 2 To UBound(ar)
- If br(i, 1) = ar(j, 1) Then
- br(i, 2) = k
- k = k + 1
- sum = sum + ar(j, 2)
- End If
- Next j
- br(i, 3) = sum
- Next i
- rg = br
- Set rg = Nothing
- End Sub
复制代码
大哥,順便把總和也一起補上
雖然晚了回復
|
评分
-
查看全部评分
|