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

½Ð°Ý¦p¦ó­pºâ¨C­Ó¤H¯Z§O¦¸¼Æ?

½Ð°Ý¦p¦ó­pºâ¨C­Ó¤H¯Z§O¦¸¼Æ?

¦U¦ì¦n

¦]»Ý­n²Î­p¨C­Ó¤H¤W¯Z¯Z§O¦¸¼Æ
¦pªþ¥ó»¡©ú
¦]¬°¸Õ¤F´X­Ó¨ç¼Æ³£·d¤£©w¡A¥u¦n½Ð±Ð¦U°Ý«e½ú

¸ß°Ý­pºâ¨C­Ó¤H¯Z§O¦¸¼Æ.rar (6.76 KB)

mmap

«u §Ú¤§PC   .RAR µLªk¶}   .ZIP ¤~¥i¶} .....
ù

TOP

¦^´_ 1# mmap


    ¤j¤j¡A½Ð°Ý¤H¤u­pºâªºµ²ªG¬°¦ó¡H¥i§_¨q¥X¨Ó¬Ý¤@¤U¡C
    ¬Ý¤£¤ÓÀ´³o­Óªí¡A¤£ª¾¸Ó¦p¦óÀ°¥L¤U¤½¦¡¡C

TOP

§Æ±æ¨D±oªþ¥ó¶À¦âmark³¡¤À

¸ß°Ý­pºâ¨C­Ó¤H¯Z§O¦¸¼Æ1.rar (7.03 KB)

mmap

TOP

¦^´_ 4# mmap


    b8=SUMPRODUCT(((¯Z§O²M³æ!$A$2:$A$11=B$2)+(¯Z§O²M³æ!$A$2:$A$11=B$3)+(¯Z§O²M³æ!$A$2:$A$11=B$4)+(¯Z§O²M³æ!$A$2:$A$11=B$5)+(¯Z§O²M³æ!$A$2:$A$11=B$6)+(¯Z§O²M³æ!$A$2:$A$11=B$7))*(¯Z§O²M³æ!$B$2:$B$11=$A8))

   ©¹¥k©¹¤U½Æ»s§Y¥i¡A¦pªG·QÅý¤½¦¡¬Ý°_¨Ó¤£­n¨º»ò¤S¯ä¤Sªø¡A¥i¥H§â¯Z§O²M³æ¸Ìªºa2:a11¤Îb2:b11¤À§O©w¸q¦WºÙ¡A´N¤£¥ÎÅã¥Ü¡y¯Z§O²M³æ!$A$2:$A$11¡z¨º»òªø¤F

TOP

B8=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(F$7:F7)

TOP

«D±`·PÁ¤j¤j¨ó§U~~^^
mmap

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2015-1-1 22:05 ½s¿è

½Ð°Ý¤j¤j
B8=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(F$7:F7)
©¹¤U½Æ»s­È«o¬O¿ù»~
¬O§_¦³­n¯S§Oª`·Nªº©O?
mmap

TOP

À³¬O=SUMPRODUCT((MATCH(B$2:B$7,¯Z§O²M³æ!$A$2:$A$11,)<=ROW(A1)*3)*1)-SUM(B$7:B7)

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD