吃素的小胖墩 发表于 2021-9-22 16:39:00

一个计数填空的公式,谢谢大佬

一个计数填空的公式,谢谢大佬

呆傻子 发表于 2021-10-3 08:02:13

=IF(ISERR(FIND(","&B$1&",",","&$A2&",")),"",B$1)

右拉下拉,可区分张三/张三丰

渭原车夫 发表于 2021-11-9 09:28:51

=IF(COUNT(FIND(","&B$1&",",","&ASC($A2)&",")),B$1,"")

机器布衣 发表于 2021-11-23 09:57:42

谢谢大佬的帮助!

馭風者 发表于 2021-12-11 18:13:02

谢谢大佬的帮助!
页: [1]
查看完整版本: 一个计数填空的公式,谢谢大佬