如题所述
=IFERROR("辞退人数 "&COUNTIF($A$2:$A$7,E2)&" 人 关键字:"&LOOKUP(1,0/(FIND({"绩效","劝退","辞退","协商"},$C$2:$C$7)*($A$2:$A$7=E2)),{"绩效","劝退","辞退","协商"}),"")
这样吗?
F2单元格输入并下拉公式=COUNT(0/MMULT((A$2:A$7=E2)*ISNUMBER(FIND({"绩效","劝退","辞退","协商"},C$2:C$7))*1,{1;1;1;1}))