ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¥H§Ç¸¹·í¦Cªº¥kÃä­È¡A§@²Õ¦X¦Cªí¡C

[µo°Ý] ¥H§Ç¸¹·í¦Cªº¥kÃä­È¡A§@²Õ¦X¦Cªí¡C

´ú¸ÕÀÉ ²Õ¦X¦Cªí.rar (3.66 KB)




¤å¦r»¡©ú¡J
·íAÄæ§Ç¸¹=$J$1®É¡A«h¥H·í¦CBÄæ¡JHÄ椤ªº¬Y1­Ó­È»P¨ä¥¦ªº6­Ó¤§¥ô1­Ó­È¬°¤@­Ó²Õ¦X¡A
¦A±N¨ä2­Ó­È¬°1²Õªº¦U²Õ¦X(1*6*7¦@42²Õ)¦Cªí©óK2¡JL49¡C
   
½Ð¥Ñ¥ª(BÄæ)¦Ü¥k(HÄæ)¿ï¾Ü²Õ¦X¡A¥B¦b¨C6­Ó²Õ¦X¤§«á¡AªÅ1¦C§@°Ï¹j¡C
EX¡J¦p¹Ï¤ù

½Ð±Ð¡J
K2ªº¤½¦¡À³¦p¦ó½s¼g?
ÁÂÁ¡I

K2:
=IF(MOD(ROW(A1),7),INDEX(B:H,J$1+1,INT(ROW(A7)/7)),"")

L2:
=IF(MOD(ROW(A1),7),INDEX(B:H,J$1+1,MID(SUBSTITUTE(1234567,INT(ROW(A7)/7),),MOD(ROW(A1),7),1)),"")

TOP

¦^´_ 2# ­ã´£³¡ªL
·PÁ±z¦A¦¸¼ö¤ßªº«ü¾É¡C
´ú¸Õ«á¸Û¦p»Ý¨D!·P®¦!

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD