C2=IF(B2="","",RAND())
E2{=IF(ROW(A1)>A$2,"",OFFSET(B$1,RIGHT(SMALL(IFERROR(RANK(C$2:C$99,C:C),99)/1%+ROW($1:$98),ROW(A1)),2),))
F2{=IF(ROW(A1)>A$2,"",INDEX(B:B,SMALL(IF((COUNTIF(F$1:F1,B$2:B$99)=0)*(B$2:B$99<>""),ROW($2:$99)),RANDBETWEEN(1,COUNTA(B:B)-ROW(A1)))))
留言
張貼留言