|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
'逻辑没法看,按中文逻辑你的示例也有问题,,,
Option Explicit
Sub test()
Dim arr, i, s
arr = [e2:i7]
For i = 2 To UBound(arr, 1)
s = vbNullString
If arr(i, 2) = "X" Then s = s & "," & "1" '选存在的A
If arr(i, 2) = "X" Or arr(i, 3) = "X" Then s = s & "," & "2" '选 存在A 或者B
If arr(i, 2) <> "X" Or arr(i, 3) = "X" Then s = s & "," & "3" '选 不是A 的 或者 存在 B的
If arr(i, 2) = "X" And arr(i, 3) = "X" And arr(i, 4) = "X" Then s = s & "," & "4" '选 A和 B 和C 同时存在的
If Not (arr(i, 2) = "X" And arr(i, 3) = "X" And arr(i, 4) = "X") Then s = s & "," & "5" '选不是(A和B 和C )同时存在的
If arr(i, 2) = "X" And arr(i, 3) = "X" Or arr(i, 5) = "X" Then s = s & "," & "6" '选(A和B)同时存在 或者 存在D的
If arr(i, 2) = "X" And arr(i, 3) = "X" And arr(i, 4) = "X" And arr(i, 5) = "X" Then s = s & "," & "7" '选 A,B,C,D 同时存在的
Debug.Print arr(i, 1) & ":{" & Mid(s, 2) & "}"
Next
End Sub |
评分
-
1
查看全部评分
-
|