隨機 1~15 不重複 + 指定數字 (12411)

C2:C16{=IFERROR(VLOOKUP(B2,E:F,2,),SMALL(IF((COUNTIF(C$1:C1,ROW($1:$15))=0)*(COUNTIF(F:F,ROW($1:$15))=0),ROW($1:$15)),RANDBETWEEN(1,16+SUM(COUNTIF(E:E,B$2:B2))-COUNT(F:F)-ROW($A1))))

H2{=AND(COUNTIF(C:C,ROW(1:15))=1)