![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21bb051f8198618845c91d145ed2e738bd4e648?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
G2输入 =INDEX(A:A,MIN(IF((COUNTIFS($G$1:$G1,$A$2:$A$100,$H$1:$H1,$B$2:$B$100,$I$1:$I1,$C$2:$C$100)=0)*($A$2:$A$100=$F$2),ROW($2:$100),200)))&"" 数组公式,先按住CTRL+SHIFT,最后回车,使得编辑栏公式两端出现花括号{ } 公式右拉再下拉到无数据 J2输入 =COUNTIFS($A:$A,$G2,$B:$B,$H2,$C:$C,$I2,$D:$D,J$1) 右拉下拉
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759eebf5af79fbdfb43166d22df58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759eebf5af79fbdfb43166d22df58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759eebf5af79fbdfb43166d22df58?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)