201804061141随机抽取無标记 (4275)

E2=INDEX(B:B,SMALL(IF(C2:C11<>"/",ROW(B2:B11)),RANDBETWEEN(1,10-SUM(N(C2:C11="/")))))

F2:F11{=IFERROR(INDEX(B:B,SMALL(IF((C$2:C$11<>"/")*(COUNTIF(F$1:F1,B$2:B$11)=0),ROW(B$2:B$11)),RANDBETWEEN(1,11-SUM(N(C$2:C$11="/"))-ROW(A1)))),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite