|
发表于 2011-11-10 17:13
|
显示全部楼层
本楼为最佳答案
本帖最后由 liuguansky 于 2011-11-10 17:14 编辑
nancy66317 发表于 2011-11-10 12:43
这是一个加了数据的表
依沟通后结果及附件:
- Function Mb(Rn As Range, RnX As Range, Optional k As Boolean = False) As Variant
- Application.Volatile
- Dim m, i As Byte, t As Long, s$
- With CreateObject("vbscript.regexp")
- .Global = True
- .Pattern = "(^|[,;])(\d+)"
- s = Mid(Rn.Value, 6)
- If .test(s) Then
- For Each m In .Execute(s)
- i = i + 1: t = CLng(m.submatches(1))
- If t >= RnX.Value * 0.0001 Then
- 100
- If k Then
- Mb = Format(RnX.Value / t / 10000, "0.00%")
- Else
- Mb = "目标" & i
- End If
- Exit Function
- End If
- Next
- If Len(Mb) = 0 Then GoTo 100
- End If
- End With
- End Function
复制代码
表格公式同上。
返利目标(3).rar
(9.51 KB, 下载次数: 28)
|
|