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

²¾°£­«ÂЮÉ, ¦³ªÅ¥Õ­È

²¾°£­«ÂЮÉ, ¦³ªÅ¥Õ­È

¥»©«³Ì«á¥Ñ yc1031 ©ó 2012-6-14 13:36 ½s¿è

²¾°£­«Âбư£ªÅ¥Õ­È.rar (153.52 KB)
·í§ÚªºÅçºâµ²ªG¥X¨Ó®É  §Ú¬O¥ÎVBA±NÅçºâµ²ªG, ½Æ»s¨ì²¾°£­«ÂаÏ, ²¾°£­«ÂЫá, ¦A¶K¸ê®Æ¨ì§Ú­nªºªí®æ

§Úªº°Ê§@¬O
1. ¿ï¨úD2  , µM«á«ö SHIFT + CTRL + ¦V¤UÁä, ¿ï¨ú©Ò¦³¸ê®Æ
2. ¦b²¾°£­«ÂÐÄæ¦ì°Ï¶K¤J­È, ¦A«ö²¾°£­«ÂÐ
3.  §Ú·|¦A¶K¤J­È¨ì¥t¤@­Óªí®æ

¦ý¦b²¾°£­«ÂЮÉ, ¦³¥X²{ªÅ¥Õ®æ, §Ú¸Ó«ç»ò¸Ñ¨M©O?

¦^´_ 1# yc1031


    B4:C4,B19:C19¬°¦ó³£·|³Q¿ï¨ú?
³o°ÝÃD§A¦³·Q¹L¶Ü?
·Ó²z¦pªG¹J¨ìªÅ®æ¡Actrl+shift+¦V¤UÁäÀ³¸Ó¤£·|¿ï¨ú¥þ³¡¸ê®Æ
¦ý¦¹ÄÒ·|¿ï¨ú¨ì²Ä19¦C¡AÅãµM³o¨Ç¬Ý¦üªÅ®æªºÀx¦s®æ¬O¦³¤º®eªº
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


§Úª¾¹D~ §Ú¦³¸ÕµÛ§R¹L«á, ´N¤£·|¦A¿ï¨ú~

¦ý¦]¬°¬O¥Îvba¶]ªº, ¤£ª¾¹D«ç»ò¥h§PÂ_³o¨Ç¬Ý¦üªÅ­È¦ý«o¦³¸ê®ÆªºÄæ¦ì­n«ç»ò§ä¥X¨Ó

§Ú¸Õ¹L¥Î´M§äªÅ­È¤§Ãþªº¤èªk, ¦ý³£¨S¿ìªk¸Ñ¨M~ ½Ð°Ý±z¦³¨ä¥¦¤èªk¥i«Øij¶Ü?   ÁÂÁÂ~

TOP

¦^´_ 3# yc1031

¦pªG¸ê®Æ¤£¯à­«·s±Æ§Ç¡A¥B¤@©w¥Î¤º«Ø²¾°£­«½Æ¥\¯à
¥i¥H¹Á¸ÕDÄ椽¦¡¤£®Õ¥¿¿ù»~
D2=LOOKUP(2,1/($B$2:$B$5001=C2),¤u§@ªí4!$B$2:$B$4000)
µM«á¿ï¨ú¯S®íÀx¦s®æ/¤½¦¡
¤£¤Ä¿ï¿ù»~­È
¦A½Æ»s¶K¤W­È

§_«h´N­n¦Û¤v¥Î°j°é¨Ó¼gVBA¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


¯uªº«ÜÁÂÁ±z!
°ÝÃD¤w¸Ñ¨M¤F~

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD