我有一个清单:
"2","3","4","5","6","7","8","9","A","K","J","Q","T"
然后我有细胞:
6s 3d 3c yes (2)
6s 3s 2d no
6s 3s 2s no
2s 2d 2c yes (3)
.....
我想检查单元格 A6(此处为 6s 3d 3c)是否包含来自上述列表的至少 2 次相同字符,如果有一对或三个字符则返回“是”。我使用列表是因为我不想在这里计算 s。
有什么想法吗?非常感谢