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

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

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

ª©¥D¦n
²{¦b¦³­Ó¸ê®Æªí
¦b¤u§@ªí1(ªí³æ)
¥ÎVLOOKUP¥i¸Ñ¨M¥Î¤½¥q¦W±a¥X¦í§}¤Î¹q¸Ü
¦ý¬O¶·¦b¦P¤@¤u§@ªí­¶­±
½Ð°Ý
­Y¯à¦b¸ê®Æªí¤¤ª½±µ²Ö­p¿é¤J»Ý­nªº¸ê®Æ
¦Ó¤£¦A¤u§@ªí(ªí³æ)¤¤«ùÄò¿é¤J
½Ð°Ý¦³¨ä¥Lªº SHEET1.rar (3.95 KB) ¤½¦¡©Î¤èªk¶Ü?
ÁÂÁÂ!!

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

TOP

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

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

¦^´_ 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

¥»©«³Ì«á¥Ñ 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

¦^´_ 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

ª`·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

¦^´_ 8# Hsieh


    ªO¥D
    ¥»¨ÓÂI¶i¥h°Ï¶ô´N·|°{Ã{³]©wªº½d³ò­Èªü!
±z³]ªº©w¸q¬O¨S¿ùªº
¥u¬O­è­è¨º«Êµo¤å
¬O­n¸Õ¸Õ¦³¨S¦³§Oªº¤è¦¡©Î¤½¦¡
¥i¥H¦b¦P­¶­±¨Ï¥Î
¦Ó¤£¥Î¸ó¤u§@ªí¥Î©w¸q¦WºÙ¥h·j´M

ÁÂÁÂ!

TOP

¤£¸ó¤u§@ªíª½±µ¼g¤½¦¡¶i¥h´N¦æ°Õ!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD