D2:E2 下拉 {=IFERROR(INDEX($A:$A,SMALL(IF((COUNTIF($B:$B,$A$2:$A$99)-(A$1=$A$1))*(COUNTIF(D$1:D2,$A$2:$A$99)=0)*($A$2:$A$99>0),ROW($2:$99)),RANDBETWEEN(1,SUM(COUNT(A:A)-COUNT(B:B))-ROW(A2)+1))),"")
G2:H2=AND(COUNTIF($A:$A,D2:D11)*(D2:D11<>"")=N((0&D2:D11)*1>0))
留言
張貼留言