D2{=INDEX(C:C,SMALL(IF(ISERROR(MATCH(B$2:B$16&C$2:C$16,B$1:B1&D$1:D1&"",))*(B$2:B$16=B2),ROW($2:$16)),RANDBETWEEN(1,COUNTIF(B:B,B2)-COUNTIF(B$1:B1,B2))))
值 須全不同 {=INDEX(C:C,SMALL(IF((COUNTIF(D$1:D1,$C$2:$C$16)=0)*(B$2:B$16=B2),ROW($2:$16)),RANDBETWEEN(1,COUNTIF(B:B,B2)-COUNTIF(B$1:B1,B2))))
F2{=COUNT(MATCH(B2:B16&C2:C16,B2:B16&D2:D16,))
留言
張貼留言