隨機不重複取資料 依指定格數 (13791)

H2:H16{=IF(ROW(A1)>F$2,"",INDEX(B:B,SMALL(IF((COUNTIF(H$1:H1,B$2:B$99)=0)*(B$2:B$99<>""),ROW($2:$99)),RANDBETWEEN(1,COUNTA(B:B)-ROW(A1)))))

I2:J16=IF($H2="","",VLOOKUP($H2,$B:$D,(B$1=$C$1)+2,))

F7=SUMPRODUCT(COUNTIF(H:H,B2:B16))