二數據不重複 提取 (11936)

E2:F11(=INDEX(B:B,MIN(IF(COUNTIFS($E$1:$E1,$B$2:$B$21,$F$1:$F1,$C$2:$C$21)=0,ROW($2:$21),99)))&""

G2:G11=IF(E2="","",COUNTIFS(B:B,E2,C:C,F2))



留言