考卷 隨機取題目 (14459)

G2下拉{=IF(ROW(A1)>E$2,"",INDEX(B:B,SMALL(IF((COUNTIF(G$1:G1,B$2:B$199)=0)*(B$2:B$199<>""),ROW($2:$199),999),RANDBETWEEN(1,COUNTA(B:B)-ROW(A1)))))

按F9即變 固定方式-->圈選G2:G19-->複製-->原處選擇性貼上-->值

H2=IF(G2="","",VLOOKUP(G2,B:C,2,))