|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
学习一下字典,打扰了
Sub test()
arr = [a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 2 To UBound(arr)
If Not d.exists(arr(i, 1)) Then
m = m + 1
brr(m, 1) = arr(i, 1)
brr(m, 2) = arr(i, 3) - arr(i, 2)
d(arr(i, 1)) = m
Else
r = d(arr(i, 1))
brr(r, 2) = brr(r, 2) + (arr(i, 3) - arr(i, 2))
End If
Next
[f10].CurrentRegion.Offset(1).ClearContents
[f11].Resize(m, 2) = brr
End Sub
|
评分
-
2
查看全部评分
-
|