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

[µo°Ý] ¨ì´Á¤é»Pµ²±b¤é

[µo°Ý] ¨ì´Á¤é»Pµ²±b¤é

½Ð±Ð¨ç¼ÆÃD,¦p¤U:

¤½¥q¦³¤T­Ó±b¤á,°²³]¦³¤G­Ó«ü©w¤é´Á,¦U¬°µ²±b¤é3/20 »P ¨ì´Á¤é3/31,¦p¦óÅý²Å¦X³o¤G­Ó¤é´Áªº®É­Ô,¦U­Ó±b¤á¤À§O¼Ð¥Ü¥Xbalanceªºª÷ÃB?
iÄ欰¨ì´Á¤é,²Å¦X3/31«h¼Ð¥Ü¥Xbalanceªºª÷ÃB,§_«hªÅ¥Õ
jÄ欰µ²±b¤é,²Å¦X3/20«h¼Ð¥Ü¥Xbalanceªºª÷ÃB,§_«hªÅ¥Õ
¸ê®Æ·|¤£Â_¼W¥[,¤£¾A¦X¥Î°}¦C,¸Ó¨Ï¥Î¤°»ò¨ç¼Æ,¥i¥H¹F¨ì­n¨D?

¨ì´Á¤é_µ²±b¤é.zip (10.12 KB)

I2=IF(ISNA(MATCH($M$5,$D2,0)),"",H2)
J2=IF(ISNA(MATCH($M$4,$D2,0)),"",H2)
¤À§O¦V¤U½Æ»s

TOP

¦^´_ 2# aer
±z¦n,
³o¤G­Ó¤½¦¡¹ê§@ªºµ²ªG,¥u¦³¦b§¹¥þ¬Ûµ¥©ó¤G­Ó«ü©w¤é´Á®É,¤~·|±a¥X¼Æ¾Ú,§_«h´N¥þªÅ¥Õ,¤£²Å¦X§Úªº±ø¥ó»Ý¨D®@!!

TOP

¦^´_ 3# PJChen
I2=IF($D2=LOOKUP($M$5,OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))),$H2,"")
J2=IF($D2=LOOKUP($M$4,OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))),$H2,"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

ÁÂÁª©¤jªº¸Ñµª...¥i¦æ!!  

TOP

¦^´_ 4# Hsieh

¤j¤j,
³o­Ó¤½¦¡¥Î¨ì¦Ü¤µ,µo²{¦³¿ù»~µo¥Í: JÄæ·íµ²±b¤é´Á¬Û¦P®É,À³¸Ó¥u¥X²{³Ì«á¤@µ§ª÷ÃB,¦ý¦P¤é´Áªºª÷ÃB³£¤@°_show¥X¨Ó¤F.

¨ì´Á¤é_µ²±b¤é.zip (11.56 KB)

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-5-1 21:54 ½s¿è

¦^´_ 6# PJChen

I2Àx¦s®æ
  1. =IF(ROW()=LOOKUP(2,1/($K$1>=OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))),ROW(OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2)))),H2,"")
½Æ»s¥N½X
J2Àx¦s®æ
  1. =IF(ROW()=LOOKUP(2,1/($L$1>=OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))),ROW(OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2)))),H2,"")
½Æ»s¥N½X
¦n¹³¶V¼g¶V½ÆÂø¤F¡K(µÒ)

TOP

¦^´_ 6# PJChen

I2¤½¦¡
  1. =IF((SUMPRODUCT(($D$2:$D2=$D2)*($F$2:$F2=$F2))=SUMPRODUCT((OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))=$D2)*(OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,,COUNTIF($F:$F,$F2))=$F2)))*($D2=LOOKUP(K$1,OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2)))),$H2,"")
½Æ»s¥N½X
¦V¥k¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh

°½Ãi§@ªk¡G
  1. =IF(($D2=$D3)*($F2=$F3)+$D2<>LOOKUP(K$1,OFFSET(INDEX($F:$F,MATCH($F2,$F:$F,0),),,-2,COUNTIF($F:$F,$F2))),"",$H2)
½Æ»s¥N½X
¥k©Ô¤U©Ô

TOP

¦^´_ 8# Hsieh
¦^´_ 9# Bodhidharma

·PÁ¤G¦ì¨ó§U,7~9¼Óªº¤½¦¡³£¥i¦æ!

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD