|
楼主 |
发表于 2011-10-10 16:54
|
显示全部楼层
回复 Benol 的帖子
Sub insert_row()
Dim i%
For i = 2 To 22
Cells(i, 3) = Evaluate("SUMPRODUCT((A$2:A$22=A2)*(B$2:B$22=B2))")
Next
End Sub
经验证不对,只显示a2,b2对应的结果3
Sub insert_row()
Dim i%
For i = 2 To 22
Cells(i, 3) = Application.SumProduct(Range("A2:A22") = Cells(i, 1)) * (Range("B2:B22") = Cells(i, 2))
Next
End Sub
经验证是报错,报的什么由于我电脑上是韩文版的,看不到
|
|