如何按照部门对离职人员原因进行多个关键字统计呀（出现其中1个，就不对剩下关键字进行统计）？

Question

如题所述

Answer 1

=IFERROR("辞退人数 "&COUNTIF($A$2:$A$7,E2)&" 人 关键字："&LOOKUP(1,0/(FIND({"绩效","劝退","辞退","协商"},$C$2:$C$7)*($A$2:$A$7=E2)),{"绩效","劝退","辞退","协商"}),"")

这样吗？

Answer 2

F2单元格输入并下拉公式=COUNT(0/MMULT((A$2:A$7=E2)*ISNUMBER(FIND({"绩效","劝退","辞退","协商"},C$2:C$7))*1,{1;1;1;1}))