27962| 12
|
[求助] find函数查找值为多个 |
发表于 2013-12-26 16:59
|
显示全部楼层
| ||
发表于 2013-12-26 17:15
|
显示全部楼层
| ||
| |
| |
发表于 2013-12-27 11:23
|
显示全部楼层
| |
| |
发表于 2013-12-27 15:31
|
显示全部楼层
| |
点评
此时,COUNT(FIND($B$14:$B$16,C14))只有两种情况,=0或<>0。
=IF(COUNT(FIND($B$14:$B$16,C14)),"包含","不包含") 相当于=IF(COUNT(FIND($B$14:$B$16,C14))<>0,"包含","不包含")
| ||
发表于 2013-12-28 10:29
|
显示全部楼层
| ||
GMT+8, 2024-9-27 22:17 , Processed in 0.042311 second(s), 14 queries , Gzip On, MemCache On.
Powered by Discuz! X3.4
© 1999-2023 Wooffice Inc.
沪公网安备 31011702000001号 沪ICP备11019229号-2
本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任! 本站特聘法律顾问:李志群律师