C2:C21{=IFERROR(LOOKUP(1,0/(B$2:B$21=A2),A$2:A$21),MIN(IF((COUNTIF(C$1:C1,A$2:A$21)=0)*(B$2:B$21=0),A$2:A$21)))
D2:D2{=IFERROR(LOOKUP(1,0/(B$2:B$21=A2),A$2:A$21),SMALL(IF((COUNTIF(D$1:D1,A$2:A$21)=0)*(B$2:B$21=0),A$2:A$21),RANDBETWEEN(1,COUNTA(A:A)-ROW(A1)-COUNT(B:B)+COUNT(VLOOKUP(N(IF({1},D$1:D1)),A:B,2,)))))
F2:G2{=AND(COUNTIF(C:C,$A2:$A21)=1)
留言
張貼留言