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

[µo°Ý] ¦³Ãöªí®æ¼Æ¦r¹ïÀ³¤å¦r(¦nÃø~¨D¯«¤H!!)«æ~ÁÂÁÂ

[µo°Ý] ¦³Ãöªí®æ¼Æ¦r¹ïÀ³¤å¦r(¦nÃø~¨D¯«¤H!!)«æ~ÁÂÁÂ

¥»©«³Ì«á¥Ñ qq910057 ©ó 2014-7-10 01:19 ½s¿è

§Ú·|¨D¥X³Ì¤p­È
§Ú·Q­n§â³Ì¤p­È©Ò¹ïÀ³ªº»ù®æ©M¼t°Ó¦WºÙ
¤À§O¦Û°Ê¸õ¨ìF2 ©M G2

½Ð°Ý¦³¿ìªk¶Ü?

¦]¬°¤½¥q¨S¦³«aEXCELµ{¦¡
©Ò¥H¥HGOOGLEªº¸Õºâªí¨Ó°µ~
¦pªG¦³¿ìªk~¦³¤H¯à´£¨Ñ¤èªk¶Ü?«æ~ÁÂÁÂ

µo°Ý.jpg (101.64 KB)

µo°Ý.jpg

§Ú®a¬O2010ªº³nÅé,¤]¬O¥i¥H(¨D¸Ñªk)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-10 08:42 ½s¿è

¦^´_ 1# qq910057
F2=SMALL(B2:E2,1)
G2=INDEX($B$1:$E$1,,SMALL(B2:E2,1))
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# qq910057


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

TOP

¦^´_ 1# qq910057
Sorry!
­×¥¿G2=INDEX($B$1:$E$1,,MATCH(SMALL(B2:E2,1),B2:E2,0))

TOP

¦^´_ 4# Hsieh


    ÁÂÁ§A  :))

TOP

¦^´_ 5# p212


    ÁÂÁ§AªºÀ°¦£ :))À°¤F­Ó¤j¦£

ÁÂÁÂ^__^

TOP

¥»©«³Ì«á¥Ñ qq910057 ©ó 2014-7-11 01:48 ½s¿è

¦^´_ 7# qq910057


    ¤£¦n·N«ä,¦pªGµo¥Í¹³,¹Ï¤ù³o­Óª¬ªp
¸Ó«ç»ò¸Ñ¨M? ¬Q¤ÑÁÙ¸I¨ì³o­Ó°ÝÃD!!

q:¥i¯à¬Y´X¶¡¼t°Ó,µ¹ªº»ù¿ú³£¤@¼Ë,Åܱo¨S¿ìªkÅã¥Ü£»£»£»((±j¸I!?

µo°Ý2.jpg (56.82 KB)

µo°Ý2.jpg

TOP

¦^´_ 8# qq910057

³Ì§C»ù¦³2®a¥H¤W®É¡A§A­n2®a¦WºÙ³£Åã¥Ü¥X¨Ó¶Ü©Î¥uÅã¥Ü²Ä¤@®a?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# qq910057
¨â®a¥H¤W­n¥þ³¡Åã¥Ü¡A¤º«Ø¨ç¼ÆµLªk¹F¦¨
¨Ï¥Î¦Û©w¸q¨ç¼Æ
  1. Function Join_Str(Ar()) As String
  2. For Each a In Ar
  3.   If a <> "" Then Join_Str = IIf(Join_Str = "", a, Join_Str & ";" & a)
  4. Next
  5. End Function
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD