Simone
复制A列粘贴到F列，删除重复值
在G2:L2中分别输入或郑链复制粘贴下列公式
=COUNTIFS($A:$A,$F2,$B:$B,"<>",$C:$C,"",$D:$D,"")
=COUNTIFS($A:$A,$F2,$B:$B,"",$C:$C,"<>",$D:$D,"")
=COUNTIFS($A:$A,$F2,$B:$B,"",$C:$C,"",$D:$D,"<肆陵>")
=COUNTIFS($A:$A,$F2,$B:$B,"<>",$C:$C,"",$D:$D,"<>")
=COUNTIFS($A:$A,$F2,$B:$B,"",$C:$C,"<>",$D:$D,"<>")
=COUNTIFS($A:$A,$F2,$B:$B,"<>",$C:$C,"<>"裂丛戚,$D:$D,"<>")
选择G2:L2，下拉填充
