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

[µo°Ý] ¹ï«ü©w¤é¤£§@¥ô¦ó¥[Á`©Î´î¥h

[µo°Ý] ¹ï«ü©w¤é¤£§@¥ô¦ó¥[Á`©Î´î¥h

¥»©«³Ì«á¥Ñ tomtracy ©ó 2016-3-19 15:09 ½s¿è

¦U¦ì«e¶i±z¦n
       §Úªþ¥ó¤¤ ­¶­±1 ¦³§Úªº°ÝÃD §Ú¤£ª¾«ç»ò³B²z¦n  ½Ð¦U¦ì«e¶iÀ°¦£
¤é?¤Ñ­pºâ.rar (13.32 KB)
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-3-19 16:52 ½s¿è

=H1-F3+1-SUMPRODUCT((COUNTIF(F9:G11,F3+ROW(1:999)-1)=1)*(F3+ROW(1:999)-1<=H1))

TOP

ÁÂÁ±z  ¸Ñ¨M¤F
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-3-21 22:29 ½s¿è

=H1-F3+1-FREQUENCY(F8:F20,IF({1,0},H1,F3))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-3-22 14:05 ½s¿è

=H1-F3+1-SUMPRODUCT((F9:F11<=H1)*1)

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD