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

½Ð±Ð·|ªº¤j¤j¸Ó·|¦p±a¤J¸ê®Æ

½Ð±Ð·|ªº¤j¤j¸Ó·|¦p±a¤J¸ê®Æ

½Ð±Ð·|ªº¤j¤j¸Ó·|¦p±a¤J¸ê®Æ
¨Ï¥Î¤½¦¡§â¼Æ¾Ú¸Ìªº¦~¤ë¸ê®Æ±a¤J·J¾ã¤u§@­¶¸Ì

²Î­p.zip (7.32 KB)

¦^´_ 1# koala2099

Àx¦s®æ®æ¦¡¥²¶·²Î¤@
1.¥ý±N¼Æ¾Ú¤u§@ªíAÄæ¨Ï¥Î¸ê®Æ­åªR¥\¯àÂন¤å¦r«¬ºA
2.¦]¬°·J¾ã¤u§@ªíªº¤ë¥÷§A¬O¥[¤W³æ¤Þ¸¹¤~¯à¿é¤J¦¨0¶}ÀYªº¼Æ¦r¡A­Y¨Ï¥Î&³s±µ¦r¦ê·|¦h¥X³æ¤Þ¸¹
©Ò¥H·j´Mª½­n¨Ï¥Î¼Æ­È¹Bºâ«áÂন¤å¦r¡A¤~¯à¤ñ¹ï
·J¾ã¤u§@ªíC4¤½¦¡
=VLOOKUP(TEXT(C$3*100+$B4,"0"),¼Æ¾Ú!$A:$F,INT((COLUMN(A$1)-1)/2)+2,0)
¦V¥k¦V¤U½Æ»s

    ²Î­p.rar (7.29 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# koala2099

C4=VLOOKUP(C$3&$B4,¼Æ¾Ú!$A$1:$F$9,ROUNDUP(COLUMN()/2,0),0)
    ²Î­p.rar (7.17 KB)

TOP

¦^´_ 2# Hsieh

¤u§@¤W¸I¨ì¶}ÀY¬°"0"(¦p¿é¤J¦æ°Ê¹q¸Ü)³£¨Ï¥Î³æ¤Þ¸¹
­ì¨Ó¬O³o»ò¤@¦^¨Æ¥[¤F³æ¤Þ¸¹ªºÃö«Y
¸Õ¤F¦n¤[´o³U·U¨Ó·U¹y¡A¥u¦n¤W¨Ó¨D±Ð¤F~
«D±`ÁÂÁª©¥D¦³±z¯u¦n^^

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD