发布时间:2019-07-29 23:14:24
=IF(COUNTIF(C:C,A2)=0,"非毕业班","毕业班"),注意countif函数中的区域要么为整列要么区域绝对引用
=IF(COUNTIF(D:D,A2),"","非")&"毕业班"
=IF(A2=C2,"毕业班","非毕业班") A2就是姓名列 C2指定毕业班姓名列
=IFNA(IF(MATCH(A2,$D$2:$D$6,),"毕业班",),"非毕业班")
c2=if(countif($d$2:$d$6,a2)=1,"毕业班","非毕业班")
下拉