Excel中A1.B1.C1.D1.E1是1-16的随机数怎么写公式是F1为十六个数除去A1.B1.C1.D1.E1剩余的数
å设A1ï¼E1æ ¼å¼å¦å¾ï¼åF1è¾å ¥
=TEXT(SUM(LARGE((COUNTIF(A1:E1,ROW($1:$16))=0)*ROW($1:$16),ROW($6:$11))*10^(2*ROW($1:$6)-2)),REPT("00 ",6))&TEXT(SUM(LARGE((COUNTIF(A1:E1,ROW($1:$16))=0)*ROW($1:$16),ROW($1:$5))*10^(2*ROW($1:$5)-2)),REPT("00 ",4)&"00")æãCTRL+SHIFT+å车ãåï¼å³å¯å¾å°å©ä¸çæ°å
å¦æä¸è¿°å ¬å¼ä¸å¥½ç解ï¼ç´æ¥ç¨ä¸é¢çå ¬å¼ä¹æ¯ä¸æ ·çï¼ï¼æ®éå ¬å¼ï¼
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 ",TEXT(A1,"00 "),),TEXT(B1,"00 "),),TEXT(C1,"00 "),),TEXT(D1,"00 "),),TEXT(E1,"00 "),)