ªð¦^¦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)

¦^´_ 1# sheau-lan
¤½¦¡§Ú¥u½Æ»s¤F¤@¦Ê®æ,
­Y§AÁٻݭn¼W¥[®æ¼Æ½Ð¦Û¦æ°Ñ·Ó¤º®eÅܧ󤽦¡«á¦A½Æ»s.
¿z¿ï-ans.zip (8.2 KB)
³]­p­ì²z:
1. ¦bµ²ªGÄ楪Ãä·s¼W¨âÄæ.
2. A Äæ ¤ñ¹ï ¸ê®Æ°Ï¸Ó¦C¤H¦W»P D1 ¬O§_¬Û¦P, ­Y¬Û¦P«h°O¿ý¸Ó¦C¦C¸¹, §_«h­È¬°¸Ó¦C¦C¸¹¥[ 5000 (¬G¦Ó³Ì¦h¥i¿z¿ï¥X²Å¦X±ø¥óªº 4999 ¦C¸ê®Æ)
3. BÄæ «h§Q¥Î SMALL ¨Ì§Ç¦C¥X­È§C©ó 5000 ªº¦C¸¹ (§Y²Å¦X¿z¿ï±ø¥óªº¸ê®Æ¦C¸¹)
4. ¨Ì¾Ú BÄæ ªº¦C¸¹³z¹L INDIRECT »P CONCATENATE ±a¥X¹ê»Ú»Ý­n¨q¥Xªº¸ê®Æ
5. ³Ì«á§Q¥Î "³]©w®æ¦¡¤Æªº±ø¥ó" ±N¦³¸ê®ÆªºÀx¦s®æ¥[¤W®Ø½u§Y¥i¥X²{·Q­nªºµ²ªG.

TOP

¦^´_ 1# sheau-lan


    °Ñ¼Æ¸ê®Æ¬d¸ß
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÙ¥i¥H¥uÅã¥Ü³¡¥÷Äæ¦ì
a.gif

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-11-5 01:26 ½s¿è

¿z¿ï.rar (6.29 KB)

¥Î¶i¶¥¿z¿ï:
©w¸qDATA1¬° SHEETªº¸ê®Æ±a¤J¶i¶¥¿z¿ï
´N§@ªº¥X¨Ó¡A¦ý¤ÓºC¡AÀH«K¿ý­Ó¥¨¶°ÂI´N¤è«K¦h¤F

TOP

Hsieh¤j
¬°Ô£§Ú·Ó§A£x¤èªkµª®×¬O¥X²{£{
¤£¹L¦W¦r£x¦a¤è¬°Ô£¨S¤U©Ô¬O¿ï³æ®º...

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

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

¦^´_ 8# emma

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

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

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD