刮刮樂中獎額 依輸入張數 (12345)

E2:G17=IF(ROW(A1)>$C$5,"",IF(ROW(A1)>SUM($C$2:$C$4),RIGHT(MAX(IF(COUNTIF($D2:D2,$B$2:$B$4)<2,RANDBETWEEN({1;1;1},9)*10^8+$B$2:$B$4)),8)*1,LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET($C$1,,,{1,2,3})),$B$2:$B$4)))

三格非同數 格式化E2:G17=COUNTIF($E2:$G2,$E2)<3