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

[µo°Ý] ¦p¦ó¦X¨ÖÄæ¦C¸ê®Æ

[µo°Ý] ¦p¦ó¦X¨ÖÄæ¦C¸ê®Æ

test.rar (1.41 KB)

½Ð°Ý¤@¤U¡A­n¦p¦ó±N¸ê®Æ¦X¨ÖÅܦ¨¤@­Ó¦r¦ê
¦p¡G¤ý¤j©ú10/110
      ¤ý¤j©ú10/630


ÁÂÁÂ

test.rar (8.48 KB)

TOP

´¡¤J©w¸q¦WºÙx
°Ñ·Ó¨ì¤½¦¡=SMALL(IF(Sheet1!$B$2:$G$7<>"",ROW(Sheet1!$B$2:$G$7)*10+COLUMN(Sheet1!$B$2:$G$7)),ROW(Sheet1!A1))
H2=IF(COUNTA($B$2:$G$7)<ROW(A1),"",INDIRECT("R"&INT(x/10)&"C1",0))
I2=IF(ROW(A1)<=COUNTA($B$2:$G$7),TEXT(INDIRECT("R1C"&MOD(x,10),0),"m/d")&INDIRECT("R"&INT(x/10)&"C"&MOD(x,10),0),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# yuras


    ¥Î CONCATENATE  ¥i¥H¦X¨Ö¸ê®Æ.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD