[µo°Ý] ¨D±Ð:¼Æ¦r²V¦X­^¤å±Æ¦Cªº°ÝÃD

sujane0701

¤p§Ì§@·~¤W³Ìªñ²£¥Í¤@­Ó»Ý¨D,»Ý­n±q00000¶}©l±Æ¦C¨ìZZZZZ
°²³]A1=00000 A2=00001 A3=00002....¨ì00009,±µµÛ¤U¤@Ä涷Åܦ¨0000E 0000F 0000G...0000Z ¥H¦¹Ãþ±À¨ì0009Z 000E0 000E1...
ªþ¥[»Ý¨D:¤U¦C´X­Ó­^¤å¦r¥À¤£¦C¤J±Æ¦C A B C D I O L
¤p§Ì­ì¥»¥Î ¤u¨ã-¿ï¶µ-¦Û­q²M³æ ªº¤è¦¡,¥Î«Ü²Â©åªº¤è¦¡¸Ñ¨M,¦ý¬O¤H¤u§@·~¶q¥Ö¤j¥B®e©ö¥X¿ù
½Ð±Ð¦U¦ì¤j¤j¬O§_¦³¦nªº¤è¦¡¥i¥H¸Ñ¨M³oºØ©_©Ç°ÝÃD©O?

sujane0701

¦^´_ 1# sujane0701


    ¥Ø«e´«¤F¤@­Ó²Â¤èªk¸Ñ¨M,­º¥ý±N¥½¤T½X¤À¦¨B,C,D¤TÄæ,°t¦X¤u¨ã-¿ï¶µ-¦Û­q²M³æªº¤è¦¡¨Ì³W«h¦n,µM«á³æ¿W±N«e2½X³]¸m¦bE1Äæ
,³Ì«á¦bA1Ä楴¤W=$E$1&B1&C1&D1 ¦A©¹¤U«þ¨©...«Ü²Â©åªº¤èªk
¦pªG¦³¤j¤jª¾¹D§ó¤è«Kªº¥´ªk/§@ªk,·Ð½Ð½ç±Ð~¤£³Ó·P¿E!

ML089

¦^´_ 1# sujane0701

1. =LOOKUP(MOD(INT((ROW()-1)/29^4),29),ROW($1:$29)-1,MID("0123456789EFGHJKMNPQRSTUVWXYZ",ROW($1:$29),1))
   
2. &LOOKUP(MOD(INT((ROW()-1)/29^3),29),ROW($1:$29)-1,MID("0123456789EFGHJKMNPQRSTUVWXYZ",ROW($1:$29),1))
   
3. &LOOKUP(MOD(INT((ROW()-1)/29^2),29),ROW($1:$29)-1,MID("0123456789EFGHJKMNPQRSTUVWXYZ",ROW($1:$29),1))
   
4. &LOOKUP(MOD(INT((ROW()-1)/29^1),29),ROW($1:$29)-1,MID("0123456789EFGHJKMNPQRSTUVWXYZ",ROW($1:$29),1))
   
5. &LOOKUP(MOD(INT((ROW()-1)/29^0),29),ROW($1:$29)-1,MID("0123456789EFGHJKMNPQRSTUVWXYZ",ROW($1:$29),1))

½Æ»s¥N½X

A1¤½¦¡¤U©Ô

hcm19522

=MID("0123456789EFGHJKMNPQRSTUVWXYZ",MOD(INT((ROW(A1)-1)/29^4),29)+1,1)&MID("0123456789EFGHJKMNPQRSTUVWXYZ",MOD(INT((ROW(A1)-1)/29^3),29)+1,1)&MID("0123456789EFGHJKMNPQRSTUVWXYZ",MOD(INT((ROW(A1)-1)/29^2),29)+1,1)&MID("0123456789EFGHJKMNPQRSTUVWXYZ",MOD(INT((ROW(A1)-1)/29),29)+1,1)&MID("0123456789EFGHJKMNPQRSTUVWXYZ",MOD(ROW(A1)-1,29)+1,1)