|
本帖最后由 心正意诚身修 于 2021-10-11 19:59 编辑
- <div class="blockcode"><blockquote>Sub 算平均天数()
- Dim ARR, BRR(), I As Integer, J As Integer, K As Integer, S As Double
- ARR = Range("A2").CurrentRegion
- Range("O2:O65536").ClearContents
- ReDim BRR(1 To 100)
- For I = 2 To UBound(ARR)
- J = 2
- Do While ARR(I, J) <> 0 And J < 12
- S = S + (ARR(I, J + 1) - ARR(I, 14)) * ARR(I, J) / ARR(I, 1)
- J = J + 2
- Loop
- ReDim Preserve BRR(1 To I - 1)
- BRR(I - 1) = Format(S, "0.00")
- S = 0
- Next
- Range("O3").Resize(I - 2) = Application.Transpose(BRR)
- End Sub
复制代码
最近在学习VBA。
做了一个VBA版的。当然。你也可以等其他老师的函数答案
|
|