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

[µo°Ý] ½Ð°Ý­n¥Î­þºØ¨ç¼Æ¥i¥H¦P®É¿z¿ï¶µ¥Ø¡C¨D°ª¤â

¦^´_ 9# keovin790916


    ¬Ý±oÃú·Ù·Ù¡A§¹¥þ¤£ª¾¹D¼Ó¥D·Q­nªº¸ê®Æ¬O¬Æ»ò?
¦b¨D¸Ñ¤u§@ªí¤º¡A¬O¨C­Ó¤é´Á¤À°Ï©ñ¸m¸ê®Æ
¦Ó´ú¸Õ¤u§@ªíªºªí®æ¤º¦³¤é´Á¡B³æ¦ì¡B«~¶µ¤T­Ó
¨C­Ó«~¶µ¦³13­ÓÄæ¦ì­n¹ïÀ³
½Ð§â·Q­nµ²ªG¤â¤u¶ñ¤J¨Ã§â¥²¶·¨Ï¥Î¤½¦¡ªºÄæ¦ì®Ø¿ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# Hsieh


   


¨D¸Ñ0502.rar (7.24 KB)


½Ð±Ð¤@¤U³o¨Ï¥Î­þºØ¨ç¼Æ¡C   

·PÁÂ

TOP

¦^´_ 12# keovin790916

D3=INDEX(¨D¸Ñ!A:Q,MATCH(´ú¸Õ!B3,¨D¸Ñ!A:A,0),MATCH(´ú¸Õ!C2,¨D¸Ñ!$2:$2,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦pªG¥Î©p¨ººØ¡A§Ú©³¤U¦³­«½Æªº¶µ¥Ø·|¤£·|¿z¿ï¿ù»~¡C

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-5-2 21:03 ½s¿è

¦^´_ 14# keovin790916

³o¬O§A®Ú¥»¨S§â¸ê®Æµ²ºc¥æ¥N²M·¡
¥H¨D¸Ñ¤u§@ªí¨Ó»¡¡A¨C¼Ë«~¶µ¦b¬Y¤é¤¤¥X²{¬O§_¥i¯à­«½Æ?
¦pªG¤£·|¡A¦Ó¬O¦bAÄæ¥X²{­«½Æ«~¶µ¡A¨º´N­n«ü©w­þ¤@¤Ñ¸Ó«~¶µ¹ï·Óªº¼Æ­È
¬JµM§A»¡¬O¿z¿ï³o¨Ç¸ê®Æ
¨º½Ð°Ý§A¿z¿ïªº·Ç«h¨ì©³¬O­þ¨Ç?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 15# Hsieh


   
·PÁ¶W¯Åª©¥D¡A ¨Ï¥Î±z¨ººØ¤è¦¡´NOK¤F

=INDEX(¨D¸Ñ!A:Q,MATCH(´ú¸Õ!G3,¨D¸Ñ!A:A,0),MATCH(´ú¸Õ!H2,¨D¸Ñ!$2:$2,0))

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD