随机生指定15字符 不重複 (9420)

C1:C15 区域数组 {=TEXT(CHAR(RIGHT(SMALL(RANDBETWEEN(ROW(1:15)^0,99)/1%+SMALL({47,64}+ROW(1:10),ROW(1:15)),ROW(1:15)),2)),"0;;10")

另解C1:C15 区域数组 {=INDEX({1;2;3;4;5;6;7;8;9;10;"A";"B";"C";"D";"E"},MOD(SMALL(RANDBETWEEN(ROW(1:15)^0,999)/1%+ROW(1:15),ROW(1:15)),100))

另解C1:C15 区域数组 {=TEXT(DEC2HEX(MOD(SMALL(RANDBETWEEN(1^ROW(1:15),99)/1%+ROW(1:15)-1,ROW(1:15)),100)),"0;;10")

D2:D16 {=INDEX({1;2;3;4;5;6;7;8;9;10;"A";"B";"C";"D";"E"},SMALL(IF(COUNTIF(D$1:D1,{1;2;3;4;5;6;7;8;9;10;"A";"B";"C";"D";"E"})=0,ROW($1:$15)),RANDBETWEEN(1,16-ROW(A1))))

F2:G2=AND(COUNTIF(C:C,ROW(1:10))=1)*AND(COUNTIF(C:C,{"A","B","C","D","E"})=1)