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

[µo°Ý] ¦p¦ó¦b³]¦³¤½¦¡ªºÀx¦s®æ¶ñ¤J¼Æ¦r

Kai Q&amp.rar (7.24 KB)
¦^´_ 13# Hsieh
ª©¥D­þ¸Ì§ï??
§ï§¹ÁÙ¬O¤@¼Ëªü?
¤£ºÞ¬O¦bRAR¸ÑÀ£ÁY«e©Î«á
³£¤£¦æªü?¥i¥H±Ð¤@¤U¶Ü?
    ÁÂÁÂ!

TOP

¤U¸ü®Éªº¹ï¸Ü­n¥ÎÀx¦s
¥¼©R¦W.png
2010-5-8 22:30

ÀɮצWºÙª½±µ§âRARªþÀɦW¤@¨Ö¼g¤J
¥¼©R¦W1.png
2010-5-8 22:30
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  Hsieh
ª©¥D­þ¸Ì§ï??
§ï§¹ÁÙ¬O¤@¼Ëªü?
¤£ºÞ¬O¦bRAR¸ÑÀ£ÁY«e©Î«á
³£¤£¦æªü?¥i¥H±Ð¤@¤U¶Ü?
     ...
PD961A µoªí©ó 2010-5-8 22:12



    ¬Ý¤Fµh­W
§Ú¤w±N¼Ó¥DªºªþÀÉ­«·s©ñ¤W,§A­«·s¦^²Ä¤@©«#1¤U¸ü§a,¤£¥Î¦^©«·PÁÂ
¸ÕÅç«á³ø§i¬ã¨sµ²ªG´N¦n
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

¦^´_ 17# ¦Ñ®L


    ®LªO¥D:
§Úª¾¹D(11¼Ó)HSª©¥Dªº¥i¥H¥Î
¥¦¤w¸g¼g¦n¤F
©Ò¥H¤~·Q­n¬Ý­ìÀÉ
¦]¦¹¤~·|¦³¤p»xª©¥Dªº¨º¬q¸Ü
"¬Ý¤Fµh­W"
¤p»xª©¥Dªº·N«ä¬O
½Ð§Ú¤£¥Î·ÓHSª©¥D¸ÑÄÀ¨BÆJ¥h¸Ñ
¥L¤w¸g­×¥¿¦n­ìÀÉ©ñ¦^1¼Ó...©Ò¥H¬Ý§¹¼g¤ß±o³ø§i!!!¤£¥Î¼g·PÁ¨ç(ÁÙ¬OÁÂÁ¤p»xª©¥D)

¥t¥~ÁÙ¬OÁÂÁÂHSª©¥D¦^ÂÐ
¦]¬°¥»¨Ó´N·Qª¾¹D«ç»ò¸Ñ..±`¹J¨ì³o­Ó°ÝÃD!!ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-5-9 22:07 ½s¿è
¥u¯à¤G¿ï¤@ªºµ²ºc©Ê°ÝÃD

¤½¦¡¼g¦bÀx¦s®æ¸Ì,329ºØ¨ç¼Æ¦A«ç»ò¼Ë¼g,²£¥Íªº³£¬O[­È]
[­È]Àx¦s¦b¨º¸Ì

Àx¦s ...
¦Ñ®L µoªí©ó 2010-5-7 11:20

¥u¯à¤G¿ï¤@ªºµ²ºc©Ê°ÝÃD

®Lª©¥D»¡ªº¬OEXCEL°ò¥»Æ[©À¤½¦¡¼g¦bÀx¦s®æ¸Ì,329ºØ¨ç¼Æ¦A«ç»ò¼Ë¼g,²£¥Íªº³£¬O[­È]
[­È]Àx¦s¦b¨º¸ÌÀx¦s®æª½±µÁä¤J[­È],­ì¦³¤½¦¡«h³Q§R°£µw­n¹H¤Ï¦s¨ú³W«h¯«¥PÃø¸Ñ

1¼Ó¥D¥ÎÅçÃÒ²M³æ¥D­n­n¨Ï¥ÎÃöÁpªí°µVLOKUP()¬d¸ß,ÃöÁpªí¦b¨º¸Ì?¥D¯Á¤Þ¦b¨º¸Ì?§¹¥þ¨S¦³
³oÂIHSª©¥D¤w¸g¦b¥L¼g¦nªºµ{¦¡¸ÌÀ°³o¦ì¤¯¥S..¦b¥kÃä¼g¦nÃöÁp©Ê..©Ò¥H§Æ±æ½Ð³o¦ì¤¯¥S±z¤U¦¸´£°ÝÃD®É¥i§_¥ý¹³®Lª©¥D»¡ªº
ÃöÁpªí¦b¨º¸Ì?¥D¯Á¤Þ¦b¨º¸Ì?§¹¥þ¨S¦³¥ýµy·L·Q¦n..ÁÙ¦n½×¾Â¦³HSª©¥D¯à¤F¸Ñ§Aªº·N«ä.ªá®É¶¡À°±z·Q¦n(¥L·|»¡¥ÕÀY¾v¤S¦h1®Ú..©Ò¥H§Æ±æ±zÅý³o¨Çª©¥D¯à«Ü§Ö¶i¤Jª¬ªp..³o¼Ë¸ÑÃD·|«Ü§Ö³á!)
§_«h¯uªº¤j®a³£¤£¤ÓÀ´±zªº·N«ä!

¥t¥~±NHSª©¥D¼g¦nªºµ{¦¡¬Ý§¹«á..¤£¦n·N«ä§Ú§âVBªº³¡¤À§R±¼..¥¦ÁÙ¬O¯à¿ï¾ÜÃöÁp©Ê
©Ò¥H¤£À´¥L¥u­n±N»Ý­nªº¤â°Ê³¡¥÷¥ÎVLOKUP()¬d¸ß¥h¹B¥Î´N¥i¥H..
³o¸Ì1¼Ó¤¯¥Sªº»Ý¨D¨Ã¨S¦³ÃöÁp¨ì²£«~Ãþ§OABCDEªü?»Ý­n¤â°Êªº¥ÎVLOKUP()¬d¸ß´N°÷¥Î¤F....
ÁÂÁÂ!
[attach]151[/attach]

Kai-1.rar (11.38 KB)

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-5-26 12:44 ½s¿è

¤p»xª©¥D
¤£¦n·N«ä
§Ú±`±`¤W¶ÇÀɮ׳£·|­«½Æ¶Ç¨ì
§R¤S§R¤£±¼..
½Ð°Ý¦b­þ¸Ì§R?
µo©««á
¤~µo²{¶]¥X3­ÓÀÉ®×
¦ý¬OKAI-2¤~¬O¥¿½T
¥t¥~2­Ó­n¦p¦ó§R±¼?§Ú³s¥¦«ç»ò¶]¥X¨Óªº
³£¦³ÂI²ö¦W©_§®?¦]¬°¦b¤W¶Ç®É--µe­±¬O·í±¼ªº
©Ò¥H¤S­«¼g¤@¦¸¦^´_(¤ß±o³ø§i)
µ²ªG­è­è¤W¶Çªºµ{¦¡...³ºµM¤@°_¨q¥X..
ÁÂÁÂ!

TOP

¦^´_ 20# PD961A


    ¤p»xª©¥D
±z§R¿ùÀɮפF
kai-2¤~¬O¥¿½TªºÀÉ®×
kai-1¨º¬O¨S¦³§R±¼hsª©¥DvbaªºÀÉ®×
¦b¤W¶Ç®É·í±¼ªºÀÉ®×
¤£¦n·N«ä!
§Ú­«¶Ç¦n¤F
ÁÂÁÂ! Kai-2.rar (10.39 KB)

TOP

¼Ó¥Dªº·N«ä¤£ª¾¬O§_¦p¦¹
°²³]§â³W®æªí©ñ¦bM1:R8
B7=VLOOKUP($A$7,$M$1R$10,COLUMN(),0)
Hsieh µoªí©ó 2010-5-8 15:17



·PÁ¦U¦ì¤j®vªº°Ñ»P
                    ¥H¤Î  Hsieh ¤j®v,§A¯u¤F¤º¦æ,³o´N¬O§Ú­nªº·N«ä,¦ý§Ú·Q§âvlookupªº¨ç¼Æ§ï¬°INDEX¨ç¼Æ¥i¥H¶Ü

TOP

¦^´_ 22# kai6929


    §Ú¥u¬O´¢¼¯¬d¸ß¤èªk
§A­n§ï¤½¦¡´N·Ó§Ú8#ªº¤èªk¿ý»s¤½¦¡«á
¦A§â§Úµ{¦¡½X¼gªº¤½¦¡¨ú¥N±¼´N¦n
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

If Target = "A" Then [B7:F7] = "" Else [B7:F7].FormulaR1C1 =
"=VLOOKUP(R7C1,R1C13:R10C18,COLUMN(),0)"

½Ð±Ð¤@¤U¤j®v  (R7C1,R1C13:R10C18 ³o¸Ì¬O¤°»ò·N«ä

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD