抽獎 (11422)

E2=IF(ROW(A1)>G$2,"",OFFSET(A$1,LOOKUP(RANDBETWEEN(1,SUM(B:B)),SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$99)))+1,ROW($1:$99)),))

D2=IF(E2="","",E2&RANDBETWEEN(1,VLOOKUP(E2,A:B,2,)))