|
- Sub 结果()
- Dim ARR, BRR(), I As Integer, K As Integer, T As Byte, S As Long
- I = Range("C11").End(xlDown).Row
- ARR = Range("C11:C" & I)
- ReDim BRR(1 To I - 10, 1 To 1)
- For K = 1 To I - 10
- If ARR(K, 1) > 1 Then
- T = T + 1
- BRR(K, 1) = 2 * T
- S = 0
- ElseIf ARR(K, 1) = 1 Then
- S = S - 1
- BRR(K, 1) = 2 * S
- T = 0
- ElseIf ARR(K, 1) = 0 Then
- BRR(K, 1) = "#N/A"
- End If
- Next
- Range("E11").Resize(K - 1, 1) = BRR
- End Sub
复制代码 |
评分
-
查看全部评分
|