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

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó§ì¨ú¦h­«±ø¥óªº¸ê®Æ

[µo°Ý] (¤w¸Ñ¨M)¦p¦ó§ì¨ú¦h­«±ø¥óªº¸ê®Æ

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:22 ½s¿è

§Ú·Q­n¦b¤ÀÃþªº¤u§@ªí§ì¨ú¨Ó·½¤u§@ªíªº¸ê®Æ
¦³¤°»ò¤è¦¡¥i¥H°µ¶Ü
§Úı±o°ÝÃD¦b©ó«p«×
¦pªG«p«×ªº§PÂ_¤è¦¡¥u¦³¤@¦U²Î¤@0.8©ÎªÌ¨ä¥L
À³¸Ó¥i¥H¥Îsumproduct
¥i¬O¤£¤@¼Ë¤§«á§Ú¤£ª¾¹D¸Ó¥Î¤°»ò¤è¦¡§ì¸ê®Æ

°ÝÃD.rar (1.68 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

C2=INDEX(¨Ó·½!C:C,MATCH(A2,¨Ó·½!A:A,0)-(IF(B2<--SUBSTITUTE(LOOKUP(A2,¨Ó·½!A:A,¨Ó·½!B:B),">=",""),1,0)))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¤j¤j¦^ÂÐ
§Ú¦b¬ã¨s¤@¤U§Aªº¤è¦¡
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 2# Hsieh


    ³o¬O§Ú±N¤j¤jªº¸ê®Æ¶K¶i¥h¤§«áªº¸ê®Æ
    ¥i¬O¤£¬O¥þ³¡³£¥i¥H·j´M¨ì¸ê®Æ
     ¬O§Ú¶Kªº¤è¦¡¦³°ÝÃD¶Ü
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

§Ñ¤F¶KÀÉ
ªþ¤WÀÉ®×

°ÝÃD.rar (1.86 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

=INDEX(¨Ó·½!C:C,MATCH(A2,¨Ó·½!A:A,0)-(IF(B2>=(--SUBSTITUTE(LOOKUP(A2,¨Ó·½!A:A,¨Ó·½!B:B),"<","")),0,-1)))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD