|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
'你这3列示例根本没用,无法确定规则
'-----------------------------------
'兰索拉唑为什么是3,如果它是3那么1981就是2
'觉得兰索拉唑按2来处理可能性会更大些,还是规则不唯一,按2选1规则处理
'函数整体替换
Function qu5(arr, brr, col)
Dim i, j, n
For i = 1 To UBound(arr, 1) - 1
If arr(i, col) = arr(i + 1, col) And Len(arr(i, col)) > 0 Then
n = n + 1
For j = i + 2 To UBound(arr, 1)
If Len(arr(j, col)) = 0 Then i = j: Exit For
Next
End If
Next
If n >= 3 Then
n = n - 2
ElseIf n = 2 Or n = 1 Then
n = 0
For i = UBound(arr, 1) To 2 Step -1
If arr(i, col) = arr(i - 1, col) And Len(arr(i, col)) > 0 Then Exit For
If Len(arr(i, col)) Then n = n + 1
Next
Else
n = 0
For i = 1 To UBound(arr, 1)
If Len(arr(i, col)) Then n = n + 1
Next
End If
brr(col, 6) = n
End Function |
评分
-
2
查看全部评分
-
|