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

¬d¸ß°ÝÃD

¬d¸ß°ÝÃD

½Ð°Ý¦U¦ì°ª¤â
·Q¯}ÀYÁÙ¬O·Q¤£¥X¨Ó
§Ú·Q§âSheet2¥´¦Ñ¤ý´N·|Åã¥Ü¥Xsheet1¦Ñ¤ýªº¨C¤@µ§¸ê®Æ
¦ý¤£¬O¥Î¿z¿ï£x.¬O­n§Y®Éªº

¿z¿ï.zip (1.62 KB)

¾Ç·|¤F³o¤@¬L¯uªºÁÙÆZ¦n¥Î£{
¦]¬°¥Î°}¦C¸ê®Æ¤Ó¦h·|¶]¤£°Ê

TOP

¦^´_ 13# emma
¬d¸ßºëÆFªº¿ï¶µ³]©w
¥¼©R¦W.png
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 12# Hsieh


    Hsieh ª©¥D±z¦n¡AÁÂÁ±z­@¤ßªº¦^ÂСA¤w¨Ì·Ó±zªº±Ð¾Ç¤è¦¡¸Õ¤F¦n´X¦¸¡A
   ¤£¾å±o¬O¦]¬°ª©¥»°ÝÃD¡AÁÙ¬O¯Ê¤Ö¨ä¥L¤¸¥óªº¦]¯À¡A¨ÃµLªk©M±zªº±Ð¾Ç¥Ü½d¦P¨B¡A
   ©Ò¥X²{ªº°ÝÃDµe­±¦p¤U¡A¯àª¾¹D¬O¤°»ò­ì¦]³y¦¨ªº¶Ü?

2012-01-05_B02.jpg


´Nºâ¬O¥Î±z©Ò¤W¶ÇªºÀɮרӨϥΡA¤]¬O¥X²{¥H¤Uªº¿ù»~µe­±


2012-01-05_A03.jpg

¨ì¬O¬O¬°¤°»ò(©êÀY)


TOP

¦^´_ 11# emma
TEST20120103.rar (6.02 KB)
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2012-1-4 18:12 ½s¿è

¦^´_ 3# Hsieh


    Hsieh ª©¥D¡AÁÂÁ±zªº«ü±Ð¡A
   ¦ý¬O·Q­n½Ð±Ðªº¬O¥i¤£¥i¥H¥Î§Y®É§ó·sªº¤è¦¡?
    ¦]¬°¨C³]©w¤@¦¸·sªº¿z¿ï±ø¥ó«á´N»Ý­n¦A¥h°õ¦æ¤@¦¸¶i¶¥¿z¿ïªº³]©w
   ¤~¯à°µ¿z¿ï...
    ÁÙ¦³¿z¿ïªº½d³ò¥i¥H³]¬°©T©wªº¶Ü?¥u­n¦b³o­Ó½d³ò¿é¤J©Ò·Q­n¿z¿ï
   ªº±ø¥ó¡A´N³Q·|¿z¿ï¥X¨Ó...:L

EXCEL¦³³oºØ¥i¯à©Ê¶Ü?´N¹³http://stock.wespai.com/
³o­Óºô­¶¤@¼Ë¦b·j´M(¬YÀx¦s®æ)¥´¤WÃöÁä¦r«á¡A¤U¤èªºÄæ¦ì¸òµÛÅÜ°Ê¡A
ÁÙ¬O»¡³o­Ó¥u¦³ºô­¶¤~¯à³o»ò°µ>"<?

TOP

¦^´_ 3# Hsieh


    ¯u¬O¶}²´¬É¡AÁÙ¥i³o¼ËÀ³¥Î¡A¨ü±Ð¤F~~

A8=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$1:$B$10=Sheet2!$B$1,ROW($A$1:$A$10),4^8),ROW(A1)))&""

B8=INDEX(Sheet1!C:C,SMALL(IF(Sheet1!$B$1:$B$10=Sheet2!$B$1,ROW($A$1:$A$10),4^8),ROW(B1)))&""

¥H¤W¬°"°}¦C¤½¦¡"¡A¸ê®Æ¤Ó¦h®É¡A¤£«Øij¨Ï¥Î!

TOP

¦^´_ 8# emma

¶i¶¥¿z¿ï±ø¥ó¤£¬O³o»ò¤Uªº
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ emma ©ó 2012-1-3 15:20 ½s¿è

¦U¦ì°ª¤â­Ì¦n¡A½Ð°Ý¦pªG¨Ï¥Î¦¹¤è¦¡¡A¥i¥H³]©w¤G­Ó¥H¤Wªº±ø¥ó¶Ü?
¤§«e¦³¸Õ¹Lª©¥D­Ìªº¤èªk¡A¦ý¤£¾å±o¬O¤£¬O§Ú¤Ö¤F¤°»ò°Ê§@©Î2003ª©¦³¨S¦³¤ä´©³o¼Ëªº¥\¯à¡A
¤£ºÞ§Ú«ç»ò¸Õ´N¬O¸õ¥X¦p¤U¹Ïªº¿ù»~°T®§

§Ú¤]º¡·Q¾Ç²ß¦³Ãö¥i¥H§Y®É¬d¸ßªº¥\¯à¡A¥Ø«e¨Ï¥Îªº¤å¥óÁöµM¦³¥Î¦Û°Ê¿z¿ï¥i¥H¹F¨ì¨Ï¥Î¤Wªº»Ý¨D
¦ýı±o¦b¬d¸ßªº³t«×¤WÁÙ¬O¦³ÂIºC¡A©Ò¥H·Q¸Õ¸Õ¥i¤£¥i¥H±N¦¹§Y®É¬d¸ßÀ³¥Î¨ì¥Ø«eªº¤u§@ªí¤W
½Ð¦U¦ì¤£§[½ç±Ð¡AÁÂÁÂ^^
TEST20120103.rar (2.93 KB)

TOP

¦^´_ 3# Hsieh

¤j¤j¦n
¥Î³o¤èªk¬d¸ß, ¤p§Ì±q¨S¸Õ¹L, ¯u¥O§Ú¨£ÃѼs¤F, ¦ý¦³°ÝÃD·Q½Ð±Ð, ¦b07ª©¤¤¬O§_¥i¦æ, ¦]§Ú¸Õ¹L¤£¦¨¥\, ¦P®É¬d¸ß®É¬O§_¦b¦P¤@Àɮפº, ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD