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

[µo°Ý] ¦p¦ó³z¹LEXCEL¨ç¼Æ¨Ì·Ó­Ó¤H¡u¨Æ¯f°²¡v¤Àªù§OÃþ²Î­p®É¼Æ

[µo°Ý] ¦p¦ó³z¹LEXCEL¨ç¼Æ¨Ì·Ó­Ó¤H¡u¨Æ¯f°²¡v¤Àªù§OÃþ²Î­p®É¼Æ

¦U¦ì¤j®a¦n:
·Q¸ß°Ý¦p¦ó³z¹LEXCEL¨ç¼Æ¨Ì·Ó­Ó¤H¡u¨Æ¯f°²¡v¤Àªù§OÃþ²Î­p®É¼Æ¡A°w¹ïªþ¥ó¹ÏÀɳ¡¥÷¶i¤@¨B§ó¸ÔºÉªº°ÝÃD»¡©ú¡A
¨Ò¦p:EXCEL¹ÏÀɤ¤ªºE11¨Æ°²®É¼Æ§Æ±æ³z¹L¨ç¼Æ±NC6:AF6³o­Ó½d³òªº¨Æ°²®É¼Æ¬D¥X¨Ó²Î­p¡F¥tG11¯f°²®É¼Æ¥ç§Æ±æ³z¹L¨ç¼Æ±NC6:AF6³o­Ó½d³òªº¯f°²®É¼Æ¬D¥X¨Ó²Î­p¡C

½Ð¦U¦ìÀ°À°¦£¡AÁÂÁ¡I

¥X¯Ê¶Ô½d¥».jpg (79.67 KB)

¥X¯Ê¶Ô½d¥».jpg

¦^´_ 1# virus


    «ÜÄꪺ¤èªk

·s¼WMicrosoft Office Excel ¤u§@ªí.zip (10.85 KB)

TOP

¦]²{¦b¤§Åv­­¥¼¹F¼Ð·Ç¡A¬G¥¼¯à¸Ô¨£ªþ¥ó¤§¤º®eª«¡A¦ýÁÙ¬OÁÂÁ¡A·PÁÂ!!

TOP

¦^´_ 3# virus


D11=SUMPRODUCT(($B$6:$B$7=$B11)*($C$6:$AF$7=LOOKUP(2,1/($D$9:D$9<>""),$D$9:D$9)))
E11=SUMIF(INDEX($C$6:$AF$7,MATCH($B11,$B$6:$B$7,0),),LOOKUP(2,1/($D$9:D$9<>""),$D$9:D$9),INDEX($D$6:$AF$7,MATCH($B11,$B$6:$B$7,0),))
  D11:E11¦V¤U¦V¥k½Æ»s
   ¨Æ¯f°².rar (11.04 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    H¤jªº¤èªk¯u¬O²¼ä¦³¤O
    ¾Ç°_¨Ó¥Î
    ·PÁ¤À¨É

TOP

·PÁÂH¤j¤jªº´£¨Ñ¤èªk
¸g¨Ï¥Î«áE11¨ç¼Æ¤´µLªk²Î­p®É¼Æ
·Q¸ß°Ý¬O§_¦]Àx¦s®æ®æ¦¡ªº¼Æ­È³]©w¦³Ãö«Y©O??
½Ð¦U¦ìÀ°¦£¡AÁÂÁÂ

TOP

¦^´_ 6# virus

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

TOP

§V¤O¦^´_²Ö¿n¿n¤À¡A¦n¤É¨ì¤¤¾Ç¥Í¤U¸üÀÉ®×¼W¶i¾Ç²ß³t«×¡C

TOP

H¶W¯Å¤j¤j
§Ú·ÓµÛ¤è¦¡Áä¤J¨ç¼Æ
¦ý¼Æ¦r§e²{¨Ì¬O0
¬GÀH¤åªþ¤W¹Ï¤ùÀÉ
½Ð¤j¤jÀ°À°¦£
¥ý¦b¦¹·PÁ±z

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-9-29 18:32 ½s¿è

¦^´_ 9# virus


    ªþÀɤW¨Ó¬Ý¬Ý
±q¹Ï¤ù¬Ý¨ÓÀ³¸Ó¬O¼Æ­ÈªºÀx¦s®æ³Q¦s¦¨¤å¦r
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD