|
发表于 2016-9-12 16:55
|
显示全部楼层
本楼为最佳答案
- Sub 计算()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- arr = Sheets(2).[a1].CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2) + arr(i, 3) '产品的总量(销量+库存)
- d1(arr(i, 1)) = i '产品所在的行
- Next
-
- Set d2 = CreateObject("scripting.dictionary")
- brr = Sheets(1).[a1].CurrentRegion
- For i = 2 To UBound(brr)
- x = brr(i, 2) '产品
- If arr(d1(x), 4) = "" Then
- d2(x) = d2(x) + brr(i, 3) '销量累加
- If d2(x) > d(x) * 0.9 Then arr(d1(x), 4) = brr(i, 1) '销量达到总量的90%,提取此日期(提取过一次就不再提取)
- End If
- Next
- [a1].Resize(UBound(arr), 4) = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|