求 Excel 多条件判断 函数或者vba代码

2024-12-03 05:19:18
推荐回答(1个)
回答1:

B1输入数组公式(输入时早镇销按ctrl+shift+enter完旅闷成)
=if(count(find({"你","陆游我","他"},a1)),"有","没有")
向下填充