隨機取所以不重複 數據可增減 (12771)

C2 下拉{IFERROR(INDEX(B:B,SMALL(IF(COUNTIF(C$1:C1,B$2:B$99)=0,ROW($2:$99)),RANDBETWEEN(1,COUNTA(B:B)-ROW(A1)))),"")



留言