|
Function mth(lookup_value As Range, range_lookup As Range)
Dim A(), j%, k%, s, v
v = lookup_value.Value
A = range_lookup.Value
If UBound(A) > 1 Then mth = "Error: Can only choose one line.": Exit Function
If v <= 0 Then mth = 0: Exit Function
'1)从左端开始,求连续空格的个数
For j = 1 To UBound(A, 2)
If A(1, j) = "" Then k = k + 1 Else Exit For
Next j
'2)从第一个非空位置开始,直到右端
For j = 1 + k To UBound(A, 2)
s = s + A(1, j)
If s > v Then Exit For
Next j
'3)如果满足查找条件,那么函数值 = 计数位置(j)- 减去连续空格个数(k);否则返回0
If s > v Then mth = j - k Else mth = 0
End Function
市场预测与分析2.rar
(828.02 KB, 下载次数: 2)
|
|