Board logo

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

§@ªÌ: PD961A    ®É¶¡: 2010-5-7 11:21     ¼ÐÃD: ½Ð°Ý¦³¤½¦¡¥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ªº[attach]111[/attach]¤½¦¡©Î¤èªk¶Ü?
ÁÂÁÂ!!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 11:26

¦^´_ 1# PD961A


    http://gb.twbts.com/index.php/topic,508.0.html
§@ªÌ: PD961A    ®É¶¡: 2010-5-7 12:13

ª©¥D
©w¸q§¹«á
®M¦^¥h¸ê®Æªí
¤½¦¡¤£¯à¥ÎVLOOKUP
½Ð°Ý­þ¸Ì°µ¿ù?
ÁÂÁÂ![attach]116[/attach]
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 13:41

¦^´_ 4# PD961A


    ¸óªíÅçÃÒ´N¥²¶·¨Ï¥Î©w¸q¦WºÙ
¸ê®Æ½d³ò·|¤£Â_¼W¥[´N­n¨Ï¥ÎÅܰʩʪº½d³ò©w¸q
vlookupªº¨Ï¥Î­n²M·¡¦U°Ñ¼Æªº¨Ï¥Î(°Ñ¦Òexcel»¡©ú)
[attach]120[/attach]
§@ªÌ: PD961A    ®É¶¡: 2010-5-7 14:38

¦^´_ 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!!
ÁÂÁÂ!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 14:59

¥»©«³Ì«á¥Ñ 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
§@ªÌ: PD961A    ®É¶¡: 2010-5-7 15:23

¦^´_ 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)
ÁÂÁÂ!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 15:32

ª`·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³ò
§@ªÌ: PD961A    ®É¶¡: 2010-5-7 15:38

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

ÁÂÁÂ!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 15:53

¤£¸ó¤u§@ªíª½±µ¼g¤½¦¡¶i¥h´N¦æ°Õ!
§@ªÌ: PD961A    ®É¶¡: 2010-5-7 16:10

¦^´_ 10# Hsieh


    ªO¥D
±z¤Ó¥i·R¤F§a!!!
¨º´N¦^¨ì§Ú°Ýªº­ìÂI°Õ!
¸ó¤u§@ªí¤~·|¥Î¨ì©w¸q¦WºÙ
¬JµM¤£¸ó¤u§@ªí
·íµM¬Oª½±µ¼g´NOK°Õ!
¥u¬O³æ¤@¤u§@ªí­Y­n¦h¨ä¥LªF¦è
´N·|Åܪº«Ü­â¶Ã
©Ò¥H¤~·|
·Q
¦pªG¥i¥H¤À¦h­Ó¤u§@ªí..¦ý¬O¥i¥H¶×¾ã¨ì¤@±i¤u§@ªí§Y¥i....

¦ý¬O¥i¯à·|Åܱo½ÆÂø¦h¤F
¤]³\¨ì³Ì«á°®¯Ü¼gVB¤ñ¸û§Ö!!!

ÁÂÁª©¥D!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-7 23:09

¦^´_ 11# PD961A


    ¦Ñ¤FÁÙ¥i·R¨º¯uªº¤£¿ù
°ÝÃDªº¸Ñ¨M¤èªk©¹©¹¤£¥u¤@ºØ
§Ú­Ì¦Û¤v¤£ª¾¹Dªº¤£¥Nªí´N¨S¦³
EXCEL¥»¨­´N¦³¨Ç¥ý¤Ñ­­¨î³o´N¬O³W«h
´N¹³ÅçÃÒ¨Ó·½­n¸óªí¨Ï¥Î´N­n¥Î©w¸q¦WºÙ
³o¬O¥Lªº­­¨î
§A´N­n¿í¦u§_«h¥L´N¿ùµ¹§A¬Ý
·íµM§A·|VBA¤]¥i¥H¥ÎVBA¸Ñ¨M
¦ý¤@¯ë¨Ó»¡
°ò¥»¾Þ§@¯à°µ´N¥Î°ò¥»¾Þ§@
OFFICE¥»¨­ªº¥\¯à¤w¸g«Ü±j¤j¤F
ªá¿ú¶R¨Óªº¥\¯à©ñµÛ¤£¥Î¨º°Z¤£Á«¤j¤F
¦A¨Ó¬O¨Ï¥Î¤½¦¡¨Ó¹F¨ì­n¨D
¦]¬°³o¨Ç¨ç¼Æ¤]¬O¿ú¶Rªº
¦A¨Ó¦Ò¼{¥ÎVBA
¦]¬°§Aªºµ{¦¡²¦³º¤]¬O¦b°µ³o¦P¼Ëªº¨Æ±¡
§@ªÌ: PD961A    ®É¶¡: 2010-5-8 21:24

¦^´_ 12# Hsieh


    ª©¥D
±z»¡ªº¬O¨S¿ù
EXCEL¥»¨­¤½¦¡´N«Ü±j¤j
¦ý¬O®Ñ¥»¤Wªº¤º®e³£¬O¤j·§´£¤@¤U
°£«D¥¿¦¡¤W¹L½Ò(ÁÙ­nÅ¥ªºÀ´)§_«h¿ú³£¬O¥Õªá
©Î¬O¦³¨ì¨t²Î³Â»¶¥h..¥h·j´M¤j·§¬Ûªñªºµ{¦¡¤º®e
µM«á¦A®M¶i»Ý¨Dªº³¡¥÷
¥i¬O³o¬O°w¹ï¦³¤@©w°ò¦ªº¤H¤~¦³¥i¯à°µ±o¨ìªº
¨ä¥L¤H¤j·§³£·Qª½±µ¥á°ÝÃD¤W¨Ó½Ðª©¥D¸Ñ´N¦n¤F...
¦Ó¥B¨t²Î¸Ì­±¦³¥h¬Ý¹Lªº¤H´N·|ª¾¹D..«Ü¦hEXCEL¤½¦¡¬Oª©¥D¦Û³Ðªº(®Ñ¥»ùجO¨S¦³ªº)
¦Ó¤£¬O½Ò¥»¤W©Î¬O¥ú¬ÝEXCEL°ò¦½g´N¯à¿Ä·|³e³q..
©Ò¥Hª©¥D¤]½Ð¤£­n¤Ó­V¨D§Ú­Ì¯à¹F¨ì±z¤@¥bªº¤ô·Ç
²¦³º¯à¥ÎEXCELªº¤½¦¡´N¸Ñ¨Mªº
´N¹³±z»¡ªº¦ó¥²¥ÎVB....
ÁÂÁÂ!
§@ªÌ: Hsieh    ®É¶¡: 2010-5-8 23:13

¦^´_ 13# PD961A


    ¨ä¥L¤H¤j·§³£·Qª½±µ¥á°ÝÃD¤W¨Ó½Ðª©¥D¸Ñ´N¦n¤F
³o¥y¸Ü§Ú­n´£¿ô¦U¦ì
ª©¥D¨Ã«Dµ´¹ï³£¯à¸Ñ¨M°ÝÃD
ª©¥D¨Ã«D¬OÀ°¦£¸ÑÃDªº
ª©¥D¥u¬O­Ó¦WºÙ¬OÀ°¦£³B²zª©°È
½×¾Â¬O¤j®aªº¶é¦a
­n¤j®a¤@°_Äéµ@¤~·|­_§§ªø¤[
©Ò¥H¨Ó¦¹´N¬O­n¾Ç²ß§Þ¥©
§A»¡«Ü¦h¨ç¼Æ¬Oª©¥D¦Û³Ð
¨ä¹ê¨º³£¬O°ò¥»¨ç¼Æªº²V¦XÀ³¥Î
¥ô¦ó¤H¥u­n¦³¤ß³£¯à°µ¨ìªº
¤£­n»´©¿¤F©Ò¦³¤Hªº¯à¤O
Á٧Ʊæ¥S¥x¤]¯à¬°½×¾ÂºÉ¤@¥÷¤ß¤O
ÁÂÁÂ!
§@ªÌ: PD961A    ®É¶¡: 2010-5-9 17:59

¦^´_ 14# Hsieh


    ª©¥D
±z¤ÓÁ¾µê¤F...

½×¾Â¬O¤j®aªº¶é¦a
­n¤j®a¤@°_Äéµ@¤~·|­_§§ªø¤[

¤£­n»´©¿¤F©Ò¦³¤Hªº¯à¤O
¥ô¦ó¤H¥u­n¦³¤ß³£¯à°µ¨ìªº(³o¥y¸Ü¹ï§Ú­Ì³oºØ¤ô¥­ªº¤H­nªá«Ü¤jªº¤ß¤O¤~¯à¹F¨ì)

Á٧Ʊæ¥S¥x¤]¯à¬°½×¾ÂºÉ¤@¥÷¤ß¤O(¯à¤O¦³­­..¦ý¬OºÉ¤O¦Ó¬°..À³¸Ó»¡¶q¤O¦Ó¬°)
ÁÂÁÂ!
¥t¥~¤]·PÁª©¥D­Ì¨¯­WªºÄéµ@...¦]¬°µo²{§A­Ìªº¦^¤å®É¶¡¤j³¡¤À³£¦b±ß¤W©Î¥b©]
¬Û«H¥Õ¤Ñ³£ÁÙ¦³¦b¤u§@
©Ò¥H¤j®a¨¯­W..¥[ªoÅo!!...­É¥Î¶{ª©¥D»¡ªº¤@¥y¸Ü:¦@«j¤§!~~
§@ªÌ: leiru    ®É¶¡: 2010-8-27 00:24

³o­Ó¤½¦¡¹ï§Ú¨Ó»¡,«Ü¾A¦X¥Î¦b¤u§@¤W...
§@ªÌ: pigchen    ®É¶¡: 2013-3-12 09:43

ÁÂÁ¤j¤jªº«ü±Ð




Åwªï¥úÁ{ ³Â»¶®a±Ú°Q½×ª©ª© (http://forum.twbts.com/)