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

[µo°Ý] Åã¥Ü²Å¦X¤é´Áªº©Ò¦³¸ê®Æ

[µo°Ý] Åã¥Ü²Å¦X¤é´Áªº©Ò¦³¸ê®Æ

1.©ó²Î­pªí¤ºDATE¿é¤J¤é´Á

2.¥Ñ°O¿ýªí¤¤§ì¨ú¸ê®Æ



3.Åã¥Ü¸ê®Æ©ó²Î­pªí¦p½d¨Ò¤¤¤§Åã¥Ü¤è¦¡



³Â·Ð¦U¦ì¥ý¶i¨ó§U

Book1.rar (2.1 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-12-8 14:42 ½s¿è

¶i¶¥¿z¿ï¡A¼Ï¯Ã¤ÀªR³£¥i»´ÃP¨ú±o
­Y­n¤½¦¡¨ú±o
B3°}¦C¤½¦¡
{=IF(COUNTIF(°O¿ýªí!$A:$A,²Î­pªí!$B$1)<COLUMN(A$1),"",OFFSET(°O¿ýªí!$A$1,SMALL(IF(°O¿ýªí!$A$3:$A$11=²Î­pªí!$B$1,ROW($3:$11),""),COLUMN(A$1))-1,ROW($A1)))}
¦V¤U¦V¥k½Æ»s
¨ú±o¸ê®Æ.zip (17.22 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤S¾Ç¨ì¦n¤èªk¤F!!ÁÂÁÂ
excel~ ¾Ç¦n¥L§a

TOP

·PÁ°ÕHsieh
¶W·PÁªº
¤p§Ì§Ë¤F¤@­Ó¤ë¤F
³Q§x¦bif¸òoffset¸Ì¥´Âà
¨S·Q¨ì±z¤@¤U¤l´N¸Ñ¥X¨Ó¤F
¯u¬O°ª¤â°ª¤â¤§°ª°ª¤â¨Óªº....

TOP

°ª¤â¡I
³o¼Ëªº¸Ñªk¯u¬O¥O§Ú¤ÓÅåÆA¤F¡A
§V¤O¾Ç²ß¤¤~
·PÁ½ç±Ð~
¨S¨Æ´N¨Ó³}³}

TOP

¦æ¦C­ì¨Ó¥i¥H¦p¦¹Âà´«,¨ü±Ð¤F,·PÁÂ

TOP

¤£ª¾­Y¬O¨Ï¥ÎVBA¬O§_¦³¸Ñ...

TOP

§Ú¬O¥Î   ¸ê®Æ-->¶i¶¥-->±N¿z¿ïµ²ªG½Æ»s¨ì¨ä¥L¦a¤è   ÁÙÆZ¦n¥Îªº..¦A¥hVBA¿ý¤U¨Ó...¥i¥H¬d§A¬J¦³¸ê®Æ©Ò¦³«ü©wªº±ø¥ó..¨Ò¦p¤é´Á<->¤é´Á...©m¦W....¦^ÂÐ(§¹¦¨)  ¤é´Á¦a¤è­n¯d·N¤@¤U  >¡×2010/11/1        <=2010/11/30  ¤é´Áªº«e­±­n¥[>=    <=  ¥L¤~¬d±o¥X¨Ó...³o­Ó¤èªk«Ü²Â¦ý¬O«Ü¦n¥Î...²¦³ºVBAÁÙ¤£·|..µ¹§A°Ñ¦Ò

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD