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

[µo°Ý] ½Ð°Ý¶W³sµ²Àx¦s®æ¦p¦ó§ì¨ú?

[µo°Ý] ½Ð°Ý¶W³sµ²Àx¦s®æ¦p¦ó§ì¨ú?

¥»©«³Ì«á¥Ñ ´Ñ»y³¾»ï ©ó 2011-5-23 13:08 ½s¿è

´ú¸Õ.rar (4.05 KB) ¶W³sµ².JPG
¦p¼ÐÃD½Ð°Ý¶W³sµ²Àx¦s®æ¦p¦ó§ì¨ú?
¥H¤W¹Ï¨Ó»¡:c1~c5¬O¦³¥]§t¶W³sµ²ªºÀx¦s®æ!
§Ú·Q­na1=c1¦ý¬O¥X¨Óªº«o¥u¦³­È¡A¨S¦³¶W³sµ²ªº¤º®e!
½Ð°Ý­n³]©w¦óºØ¨ç¼Æ¡A¤~·|¨Ïa1¦³c12ªº¶W³sµ²¤º®e&¤å¦r!

¸É¥R¦p§¨±aÀɮפ¤¤º®e¡A¦p¦ó¨Ï¥ÎVLOOKUP«á¡A¨ÏA10¦³C10ªº¶W³sµ²¤º®e!

¥»©«³Ì«á¥Ñ 317 ©ó 2011-5-22 19:03 ½s¿è

¥u­n´_»sc1¶K¦ba1«Kµ¥©óc1...¨ä¥LÀx¦s¦ì¸m¥Î¬Û¦P­ì²z..
¹Ï¤ù1.png

TOP

¦^´_ 2# 317


    ¦ý¬O§Ú·Q­n¦pªG§Ú¸ò§ïc1®Éa1ªº­È¤]·|§óµÛ§ï

TOP

¦^´_ 3# ´Ñ»y³¾»ï


    §A©Òµoªº­ì袩´N¥i¥H逹¨ì§Aªº­n¨D¤F,A1¿é¤J=C1 .
    ¥u­nC1ªº­È§ïÅÜ,A1§Y·|¸òµÛÅÜ.
   ©Ò¿×¶W³sµ²¬O§A«öA1¤Wªº¤å¦r§Y¥i¸õ¨ì¥L©Ò¶W³sµ²ªºÀx¦s®æ
  ¨Ò¦p¦bA1°µ¶W³sµ²¨ìsheet3ªºB20,¥u­n§A¦bsheet1A1
«ö¤@¤U§Y·|¸õ¨ìsheet3ªºB20

TOP

¦^´_ 4# ANGELA


    ³o­Ó§Úª¾¹D!¦ý¬O§Ú·Q­nªº¬Oa1¥i¥H³sµ²¨ìc1ªºÀÉ®×!¡A¦pªG©óc1§ó§ï¶W³sµ²¸ô®|¡Aa1¤]·|¸òµÛ§ï!

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-5-23 09:45 ½s¿è

¦^´_ 5# ´Ñ»y³¾»ï

¼Ó¥D
A1 =  C1  ³o­Ó¥NªíµÛ¬O   C1ªº­È (¤£¥]§tÃC¦â) = A1
³q¦P¹D²z  ¸ÓÀx¦s®æ¤º©Ò¦³Åܧó ¤]·|¸òµÛÅÜ°Ê  
¤£µM ±z¥i¥H¸ÕµÛ ¦bCÄæ¦ì¤W  ¥kÁä½Æ»s   µM«á©ó AÄæ¦ì¤W  ¥kÁä ¿ï¾Ü©Ê¶K¤W ¿ï¾Ü¶K¤W³sµ²

TOP

§A­nªº¬O³o­Ó¶Ü?
=INDIRECT(C1&"!A1")

TOP

¦^´_ 7# ANGELA


    ·PÁ§Aªº¦^ÂÐ~¤£¹L³o­Ó¤£¬O§Ú»Ý­nªº!
§Ú·Q­nªº¬OA1=C1®É!A1¤]¦³C1ªº¶W³sµ²!·N«ä´N¬O·í§ÚÂIÀ»A1®É!¥X²{ªº¬OÂIÀ»C1ªºÀÉ®×!
·í§Ú§ó§ïC1ªº¤å¦r©ÎªÌ¶W³sµ²®É¡AA1¤]·|¸òµÛ§ïÅÜ!
¦ý¬O§Ú¦bA1¿é¤J=C1®É¡A¥¦¥u¦³C1ªº¤å¦r¡A«o¨S¦³¶W³sµ²¤º®e!

TOP

¦^´_ 6# mark15jill


    ¦ý¬O³o¼Ë¥u¬O¸ò¦bA1¿é¤J=C1·N«ä¤@¼Ë!
A1¨Ã¨S¦³C1ªº¶W³sµ²¤º®e¡A¥u¦³C1ªº¤å¦r¦Ó¤w

TOP

¦^´_ 9# ´Ñ»y³¾»ï

ÁöµM¤£¤Ó²M·¡±z­nªº¬O ÀRºAªºÁpµ² ÁÙ¬O °ÊºAªº
¦³¸ÕµÛ°µ¤F¤@­Ó²©öªº¼Ë¥» ±z¬Ý¬O§_¬°±z·Q­nªº §Ú¬O¥Î¥¨¶°§@ªº
¦]¬°¶È¨â­ÓÀÉ®×´ú¸Õ ©Ò¥H°µ±o«Ü²³æ
¦pªG¬O±z­nªº¸Ü §Ú¦A¼W³]¥\¯à..

´ú¸Õ-¼Ë¥».rar (10.12 KB)

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD