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

[µo°Ý] ½Ð°Ý¦³¤½¦¡¥i¥H¸ó¤u§@ªí¿ï¨ú¨ä¥L¤u§@ªí¸ê®Æ¶Ü?

ª`·N¬ÝÅçÃÒ¤º¦p¦ó¤Þ¥Î©w¸q¦WºÙ

2­Ó¤½¦¡©w¸q¤£¦Pªº2­Ó½d³ò
¸U¸U¤£¥i²V²c
­nª¾¹D©w¸q¦WºÙ¬O§_¥¿½T
¥i¦b¦WºÙ¹ï¸Ü®Ø¤º
¿ï¾Ü©w¸q¦WºÙ«á
ÂIÀ»©³¤U¤½¦¡°µ½s¿èª¬ºA
¬Ý²£¥Í°{Ã{ªº½d³ò¬O§_§Aªº´Á«Ý½d³ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


    ªO¥D
'=OFFSET(¼t°ÓÁ`ªí!$A$1,,,COUNTA(¼t°ÓÁ`ªí!$AA),)
¦]¬°³o¦æ¥Î±¼¤½¦¡¦WºÙ©Ò¥H

'=OFFSET(¼t°ÓÁ`ªí!$B$2,,,COUNTA(¼t°ÓÁ`ªí!$BB)-1,3)
´NÅܦ¨B2Ä椽¦¡

¨º¦pªG¨S¦³AÄ檺¤½¦¡
¬O¤£¬O¥i¥H§ï¦¨=OFFSET(¼t°ÓÁ`ªí!$A$2,,,COUNTA(¼t°ÓÁ`ªí!$AA)1,2)
ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-5-7 15:25 ½s¿è

¦^´_ 5# PD961A


    =OFFSET(¼t°ÓÁ`ªí!$B$2,,,COUNTA(¼t°ÓÁ`ªí!$B:$B)-1,3)
³o¬O©w¸q¦WºÙ¨Ó©w¸q¤@­Ó¥iÅܰʽd³ò(¥]§t3Ä檺¸ê®Æªí)
§A­ì¥»©w¸q¦¨3­Ó©T©w½d³ò¦WºÙ
vlookup¬O¦b¸ê®Æªí²Ä1Äæ·j´M©Ò»Ýªº­È
¶Ç¦^¬Û¹ïÄæ¦Cªº­È
©Ò¥H³æÄ檺ªí®æ§ä¦h©ó1Ä檺¸ê®Æ·íµM­^¶¯µL¥ÎªZ¤§¦a
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ½Ð°Ý¦b©w¸q§¹¤§«á³o­Ó¤½¦¡
'=OFFSET(¼t°ÓÁ`ªí!$B$2,,,COUNTA(¼t°ÓÁ`ªí!$BB)-1,3)
¬O°w¹ï³o­Ó¸ê®Æªí©Ò³]­pªº
©Î¬O®M¥Î¨ä¥LÃþ¦ü¸ê®Æ¦³¥Î¨ìVLOOKUP¸ó¸ê®Æªí®É
³£¥iÀ³¥Î?
¨Ò¦p±z²{¦b©Ò­zªº
®t¦b©ó¦WºÙ©w¸q¤£¦P..¦ý¬O¤½¦¡¬OÃþ¦üªº..
¬O³o¼Ëªº·N«ä¶Ü?
±z§Æ±æ§Ú­Ì¯à¦Û¤v¬¡¥Î¬O§a!!
ÁÂÁÂ!

TOP

¦^´_ 4# PD961A


    ¸óªíÅçÃÒ´N¥²¶·¨Ï¥Î©w¸q¦WºÙ
¸ê®Æ½d³ò·|¤£Â_¼W¥[´N­n¨Ï¥ÎÅܰʩʪº½d³ò©w¸q
vlookupªº¨Ï¥Î­n²M·¡¦U°Ñ¼Æªº¨Ï¥Î(°Ñ¦Òexcel»¡©ú)
¸óªíÅçÃÒ.rar (3.04 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¥D
©w¸q§¹«á
®M¦^¥h¸ê®Æªí
¤½¦¡¤£¯à¥ÎVLOOKUP
½Ð°Ý­þ¸Ì°µ¿ù?
ÁÂÁÂ! TEST-2.rar (3.87 KB)

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

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