抽獎數指定 須超過1000(含)金額才有抽獎資格 (12742)

E2下拉{=IF(ROW(A1)>G$2,"",INDEX(A:A,SMALL(IF((B$2:B$15>=1000)*(COUNTIF(E$1:E1,A$2:A$15)=0),ROW($2:$15)),RANDBETWEEN(1,COUNTIF(B:B,">=1000")-ROW(A1)+1))))