隨機 重排數據(有重複) (9892)

C2:C16区域数组公式{=INDEX(B:B,RIGHT(SMALL(RANDBETWEEN(ROW(1:15)^0,999)/1%+ROW(2:16),ROW(1:15)),2))

区域数组公式 :公式下C2-->ENTER-->圈選C2:C16-->游標放公式上-->shift+ctrl+enter三鍵一起按-->按F9就變

E2{=AND(COUNTIF(B:B,{"A","B","C","D","E"})=COUNTIF(C:C,{"A","B","C","D","E"}))