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

[µo°Ý] ½Ð°Ý¦pªG­n­pºâªñ¤Gµ§¸ê®Æ,¤½¦¡­n¦p¦ó¼g??

[µo°Ý] ½Ð°Ý¦pªG­n­pºâªñ¤Gµ§¸ê®Æ,¤½¦¡­n¦p¦ó¼g??


test.rar (7.85 KB)

½Ð±Ð¦U¦ì¥ý¶i

1.¦pªG§Ú­n­pºâ¬Y¶µ­¹§÷³Ìªñ2µ§(¥i¦Û¦æ¶ñ¤Jµ§¼Æ)ªºÁ`©M
2.¥i¥H¤£¨Ì·Ó¤é´Á,¥u§PÂ_­¹§÷,¨ú¨ä³Ì«á2µ§ªºÁ`©M¶Ü?
ªì¾Çexcel¤£¤ÓÀ´,­Y¦³ªí¹F¤£²M¤§³B©|½Ð¨£½Ì..·P®¦..^^

¦^´_ 1# chiyochao


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

TOP

·PÁÂHsieh¤jªº¸Ñµª
Åý§Ú§ó¥[©ú¥Õ¤½¦¡ªº¹B¥Î¤è¦¡ ^^
¦³Ãö³Ì«á¤@­Ó°ÝÃD..¥i¯à§Ú¼gªº¤ÓÅ¢²Î..©çÁÂ

³Ì«á¤@­Ó°ÝÃD..¬O³Ìªñ(2)µ§½Þ¦×(¥i¥Ñ²M³æ¿ï¨ú)ªºÁ`©M  ^^

·PÁ±zªº¼ö¤ß..^^
±zªº¸Ñµª´f§Ú¨}¦h..^^

TOP

¦^´_ 3# chiyochao


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

TOP

¥»©«³Ì«á¥Ñ chiyochao ©ó 2011-1-30 12:47 ½s¿è

Hsieh¤j,¹ê¦b¤Ó¨ØªA±z¤F..^^
¬Q¤Ñ§Ú¤@ª½«ä¦Ò­n¦p¦ó¹B¥Î§Aªº¤½¦¡¨Ó¦Û¦æ¸Ñ¶},¥i¬O´N¬O°µ¤£¥X¨Ó..(«ü¹B¥Î2¼Óªº¸Ñµª)
­è¤~¸ÕµÛ·Ó§Aªº¤è¦¡..ªGµM´N¦¨¤F..ÁöµMÁ٬ݤ£¤ÓÀ´,¦ý¯à°÷¹B§@´N¹ê¦b¤Ó·PÁ¤F..(«ü¹B¥Î4¼Óªº¸Ñµª)
§Ú·|§ä®ÑÁA¸Ñ¦¹¤½¦¡ªº²[·N..¦A¦¸·PÁ±zªº¦^ÂÐ..^^

TOP

­è¤~µo²{¤@­Ó°ÝÃD..¦pªGG10ªº¼Æ¦r¤j©ó­¹§÷ªºµ§¼Æ·|¥X²{¿ù»~..
§Ú¸ÕµÛ¥ÎIF¨Ó°µ±ø¥ó§PÂ_..¤£¹L³o¤½¦¡¹ï§Ú¨Ó»¡¤ÓÃø¤F,¸Õ¤F¦n¤[³£¤£¦¨¥\..
¥i¥H¦A½Ð±Ð±z¶Ü?  ·P®¦..^^

TOP

=IF((G10=0)+(G10>COUNTIF(C:C,G11)),"",SUMPRODUCT((OFFSET(y,,-1)=G11)*y))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ±zªº¦^ÂÐ..
§Ú·Q°ÝÃD¬O¤£¬O¥X¦b©w¸q"y"
±z¦b7¼Óªº¤½¦¡,¦pªG¦¨¥ß´N·|¥X¨ÓªÅ¥Õ,
¤£¹L§Ú¬O§Æ±æ´Nºâg10¤j©ó¬Y¶µ­¹§÷ªºµ§¼Æ,¤´µM¥i¥H­pºâ¥XÁ`ÃB ^^

TOP

¦^´_ 8# chiyochao


    y©w¸q¤½¦¡
=OFFSET(Sheet1!$D$1,IF(ISERROR(LARGE(IF(x=Sheet1!$G$11,ROW(x),""),Sheet1!$G$10)),COUNTIF(Sheet1!$C:$C,Sheet1!$G$11),LARGE(IF(x=Sheet1!$G$11,ROW(x),""),Sheet1!$G$10)-1),,COUNTA(x),)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¤jªº¦^À³..²×©ó¥i¥H¨Ï¥Î¤F..^^
¦¹¥~·Q½Ð°Ý±z,¥«­±¤W¦³¨S¦³¨º¤@¥»®Ñ¬O±zı±o¹ï©ó¾Ç²ßexcel¨ç¼Æªº¹B¥Î¦³À°§Uªº??
¹³Ãþ³oÃþªº¤½¦¡,³æ¿W¬ÝÁÙ¥i¥H,²Õ¦X°_¨Ó´N¦³ÂIÃú·Ù·Ù..
¦A¦¸·PÁÂ..¯¬±z¤Ñ¤Ñ³£¦³¬ü¦nªº¨Æµo¥Í..^^

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD