隨機取全部非空白不重複 (9295)

 

E2 下拉 {=IFERROR(INDIRECT(TEXT(SMALL(IF((A$1:C$15<>"")*(COUNTIF(E$1:E1,A$1:C$15)=0),ROW($1:$15)*100+{1,2,3}),RANDBETWEEN(1,COUNTA(A:C)+1-ROW(A1))),"!r0c00"),),"")