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

[µo°Ý] ¦p¦ó±N¬Û¦P±ø¥ó±a¤J¦P¤@®æ¨Ã¦Û°Ê´«¦æ

[µo°Ý] ¦p¦ó±N¬Û¦P±ø¥ó±a¤J¦P¤@®æ¨Ã¦Û°Ê´«¦æ

¦p¦ó±N¬Û¦P±ø¥ó±a¤J¦P¤@®æ¨Ã¦Û°Ê´«¦æ
½Ð°Ý»Ý­n¦p¦ó¼g¦¹±ø¥ó¤½¦¡¡A½Ð¨£ªþÀÉ
Book123.rar (1.84 KB)

¦^´_ 1# home1913

excelªº¤å¦r³B²z¯à¤O«Ü®t
«ÜÃø¥Î¤½¦¡±N¦hµ§¸ê®Æ¶ë¨ì¦P¤@­ÓÀx¦s®æ¤º

TOP

¦^´_ 2# Bodhidharma

¨º·Q½Ð°Ý¤@¤UF10Äæ¦ì¸Ìªº¸ê®Æ¦³¿ìªk§ï¦¨F10&F11¨â®æ¨ÓÅã¥Ü¶Ü?

TOP

¦^´_ 3# home1913

¤@¯ë·|©¹¥k©Ô¡A©ñ¦bG10°Õ¡K
¸Õ¸ÕF2°}¦C¤½¦¡(CTRL+SHIFT+ENTERÁä¤J)
  1. =INDEX($B:$B,SMALL(IF($A$1:$A$15=$E2,ROW($1:$15),4^8),COLUMN(A:A)))&""
½Æ»s¥N½X
¤U©Ô¥k©Ô¡A³o¼Ëªº¤l®æ¦¡¥i¤£¥i¥H±µ¨ü

TOP

FÄæ¥ý³]©w¬°¦Û°Ê´«¦æ,¦A¥Î¦Û°Ê´«¦æ²Å¸¹³s±µ
F2=IF(COUNTIF($A$2:$A$15,E2)>1,INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),2)),INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&"")

TOP

¦^´_ 3# home1913

¼Ï¯Ã¤ÀªRªí´N¥i¹F¦¨
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Bodhidharma

·PÁÂ~³o¼Ë¤lªí¥Üok~
¦ý¬O§Ú·Q°Ý¤@¤U4^8  ³o³¡¥÷¬OÔ£·N«ä?

TOP

¦^´_ 5# ANGELA

F2=IF(COUNTIF($A$2:$A$15,E2)>1,INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),2)),INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&"")

·PÁÂ~
·Q½Ð°Ý¬õ¦â³¡¤Àªí¥Ü¬°¦ó?
¦pªG¦³3­Ó¥H¤W¤½¦¡¬O§_Áٻݧó§ï?

TOP

¦^´_ 6# Hsieh

·PÁ´£¨Ñ¤èªk¡I³o³¡¥÷«Ü¤è«K
¦ý§Ú®M¤½¦¡¬O·Q­n°õ¦æ¤@­¶­±¸ê®Æ§Y¥i±a¥X¸Ñµªªº¤è¦¡

TOP

¦^´_ 8# home1913

­ø¡K»¡excel¤å¦r³B²z¯à¤O®t´N¬O³o­Ó·N«äF2=IF(COUNTIF($A$2:$A$15,E2)>1,INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),2)),INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),1))&"")¥u¯à³B²z¦³¨â­Ó­«ÂЪº±¡ªp¡A¦pªG¦³¤T­Ó­«½Æ¡A´NÁÙ­n¦A¥[&CHAR(10)&INDEX(B:B,SMALL(IF($A$2:$A$15=E2,ROW($A$2:$A$15),4^8),3))
¥|­Ó­«½Æ¡B¤­­Ó­«½Æ´N­n¤@ª½¥[¤U¥h¡K(µÒ)

¥t¥~4^8ªº·N«ä¬Oexcel(2003ª©)³Ì«áªº³Ì«á¤@¦C¡A¤@¯ë¨Ó»¡³£·|¬OªÅ®æ
©Ò¥H·í¤£²Å¦X±ø¥óªº®É­Ô¡A¦^¶Ç4^8¡A¥[¤WINDEX(B:B,4^8)´N·|¦^¶ÇB¦æªº¦C«á¤@¦C¡A¤@¯ë¨Ó»¡´N¬OªÅ¥Õ
(¦ý¬OªÅ¥Õ¶Ç¦^·|Åܦ¨0¡A¦]¦¹¾ã­Ó¤½¦¡³Ì«á¥[­Ó""¬O±N¤§Åܦ¨¤å¦r¡AÅã¥Ü¦¨ªÅ¥Õ)

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD