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

½Ð°Ý¦p¦ó§ì¨ú¥t¤@¤u§@ªíªº¦X­p¸ê®Æ

½Ð°Ý¦p¦ó§ì¨ú¥t¤@¤u§@ªíªº¦X­p¸ê®Æ

½Ð°Ý¡G
¢°¡D­qÁʳæ¤u§@ªíªºE22:E30¦p¦ó³]©w¤½¦¡¡H
¨Ò¡G
E22=²£«~¥Ø¿ý!E19
E23=²£«~¥Ø¿ý!E31
E24=²£«~¥Ø¿ý!E42
E25=²£«~¥Ø¿ý!E56
E26=²£«~¥Ø¿ý!E70
E27=²£«~¥Ø¿ý!E80
E28=²£«~¥Ø¿ý!E91
E29=²£«~¥Ø¿ý!E105
E30=²£«~¥Ø¿ý!E115

¥H¤½¦¡³]©w¬°¥D¡A¤£­n¨C­ÓÀx¦s®æ°µ³s±µ

Ch03-04.rar (18.34 KB)

joyce

¦^´_ 1# leiru
¦]¬°¦X­p¦r¼Ë¤£¦P¡A¤S¨S¦³®Æ¸¹¹ï·Óªí¡Aªí®æµL¤@©w®æ¦¡·|³y¦¨§ì¨ú¸ê®Æ§xÂZ
E22°}¦C¤½¦¡
=INDEX(INDIRECT("²£«~¥Ø¿ý!R"&MATCH(SUBSTITUTE(C22,"¦X­p",""),²£«~¥Ø¿ý!B:B,0)&"C5:R65536C5",0),MATCH("¦X­p",SUBSTITUTE(INDIRECT("²£«~¥Ø¿ý!R"&MATCH(SUBSTITUTE(C22,"¦X­p",""),²£«~¥Ø¿ý!B:B,0)&"C2:R65536C2",0)," ",""),0),)
Ch03-04.zip (18.06 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD