隨機不重複取值 (11470)

B2下拉 {=IF(ROW(A1)>I$2,"",INDIRECT(TEXT(SMALL(IF(COUNTIF(B$1:B1,D$1:G$8)=0,ROW($1:$8)/1%+{4,5,6,7}),RANDBETWEEN(1,33-ROW(A1))),"!R0C00"),))

I8=SUMPRODUCT(COUNTIF(B:B,D1:G8))