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

[µo°Ý] ¨ç¼Æ_«ü©w¦PÄ椧¹ïÀ³­È¦AÅã¥Ü©óX,Y¤G¦Cªº¦PÄæ¡C

[µo°Ý] ¨ç¼Æ_«ü©w¦PÄ椧¹ïÀ³­È¦AÅã¥Ü©óX,Y¤G¦Cªº¦PÄæ¡C

¦WºÙ©w¸q
R_R=INDIRECT("R"&ROW())
T_3=INDIRECT("R3C"&COLUMN(),0)
T_5=INDIRECT("R5C"&COLUMN(),0)
X=R_R+T_3
Y=T_5-R_R

»¡©ú¡J
Sheet1!
T7
=IF(OR($R7="",T$5="",$R7>=T$5,T$5-$R7=$R7+T$3),"",IF(AND(SUMIF(OFFSET($J$6,IF({1;0},X,Y),,,7),OFFSET($I$6,$R7,MATCH($R$5,OFFSET($J$6,T$5,,,7),)))),Y,""))
§Y·íT5´Á¼ÆªºR5­È(EX¡JT5=41=M47=30)¡A
¨ä¦bR7´Á¼Æªº¦PÄæ¹ïÀ³­È(EX¡JR8=2=M8=29)¡A
¦³¦AÅã¥Ü©ó«ü©wªºX(EX¡JR8+T$3=111=L117=29)¡AY(EX¡JT$5-R8=39=P45=29)®É¡A
«hT7Åã¥ÜY­È(EX¡JT8=39)¡A§_«hÅã¥ÜªÅ¥Õ¡C
¨ä¾lT12,T32,T41¥H¦¹Ãþ±À¡C

»Ý¨D¡J
·Q±N~
·íT5´Á¼ÆªºR5­È¡A¨ä¦bR7´Á¼Æªº¦PÄæ¹ïÀ³­È¦³¦AÅã¥Ü©óX,Y¤G¦C~
§ï¬°~
·íT5´Á¼ÆªºR5­È¡A¨ä¦bR7´Á¼Æ¤§¦PÄæ¹ïÀ³­È¦³¦AÅã¥Ü©ó«ü©wX,Y¤G¦Cªº¡y¦PÄæ¦ì¡z¡C
¸Ô¦pSheet2!T41

PS¡J¤p§Ì¥u·|¥ÎCOUNTIF¡A¦ý®Ä²v¤£¨Î^^"

¥H¤W  Àµ½Ð¦U¦ì«e½ú¡B¥ý¶i¤£§[½ç±Ð! ÁÂÁÂ!

°Ñ¦Òªþ¥ó¡J
http://www.FunP.Net/502777

¦^´_ 5# Airman


Airman¤j¡G
¥H±z¹ï¤½¦¡ªº¥\¤O¡A¹ê¥i¦b¦¹µo´§ªº¡A«Ü§Ö§Y¥i¤É¯Å¡A¤W¶Ç¤Î¤U¸üªþ¥ó¤]¤è«K¡I
¥»½×¾ÂÁö¦³µû¤À¾÷¨î¡A¦ý¬Ý¨Ó¤]ÂA¤Ö¤H¥Î¡A¥i¯àı±o¨ººØ¿n¤À¨S¦h¤j¥Î³B§a¡I
¬Æ¦Ü±o¨ì¦^ÂФ]¤£¦^À³ªº¦hªÌ¬O¡AµS¦pª¾ÃÑ+¡A¨£©Ç¤£©Ç¤F¡I

¨ºMODE¨ç¼Æ¬O±qWorlon¤j¤ÎPINY¤j¨º¾Ç¨Óªº¡A´Xµf¬ã¨s¤~ı±o¥iÀ³¥Î¦b¦¹¡A¬G¤]µL¤°·s·N¡I

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2015-11-3 19:22 ½s¿è

¦^´_ 3# ­ã´£³¡ªL

­ã¤j:
­è­è¥H¦¹¶Qµª´ú¸Õ¥t¤@µo°ÝÃD(X,Y,Z¤T¦C)¡A²K¥[ ,4  Z  ,0  «á~¥ç¥i®M¥Î¡C«Ü¹ê¥Î~·P®¦^^

¦]¬°´Á¼Æ¼W¦h¡A¥²¶·±N¦P®É¥X²{¦bN¦Cªº±ø¥ó¡A¦A¶i¶¥¬°¦P®É¥X²{¦bN¦Cªº"¦PÄæ"~¥HÁY¤p­pºâ½d³ò©M´£°ª¤¤¼ú²vªº¥i¯à©Ê¡F
¦ý¥H«e­pºâ¦PÄæ©Ò¥Îªº¤½¦¡¦h¬OCOUNTIF+OFFSET©Î¬OA¦¡=B¦¡=C¦¡....~¤£¬O®Ä²v¤£¨Î´N¬O¤½¦¡"¸¨¸¨ªø"¡A
©Ò¥H¤~¤S±N´¿¸g³£¦bª¾ÃÑ+µoªí¹Lªº¦Ñ°ÝÃD¡A¦A¦¸´£¥Xµo°Ý¡A¥H§Q§ó·s¡C

¦A¦¸©Ó»X±zªº¨ó§U©M«ü¾É~¨ü¯q¨}¦h~¤£³Ó·P¿E~·P®¦¦A·P®¦......¡C

TOP

¦^´_ 3# ­ã´£³¡ªL

­ã¤j:
´ú¸Õ¦¨¥\~Æg!
ÁÂÁ±z^^

¤p¾Ç¥Íµ¥¯Å¦b¨üµª«á¡A°£¤F¯à»¡ÁÂÁ¤§¥~¡A¦n¹³³£¨S¦³¨ä¥¦¥ô¦óªº¹ê»Ú¦^³ø¦æ°Ê¥i°µ(EX:µû»ù...)¡A¶Ã¨S¦³ feelªº^^"

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-11-3 16:35 ½s¿è

¬O§_¦p¦¹¡G¤@¯ë¤½¦¡
=IF(OR($R7="",T$5="",$R7>=T$5,T$5-$R7=$R7+T$3),"",IF(MODE(N(OFFSET($I$6,CHOOSE({1,2,3},$R7,X,Y),MATCH($R$5,OFFSET($J$6,T$5,,,7),))),0,0,0),Y,""))

¥HMATCH¨ú±o¤T´Áªº¦PÄæ¦ì¼Æ¦r¡A
¦A¥H MODE ¨ú²³¼Æ¡A¦P®É¤T­Ó¬Û¦P«h¦¨¥ß¡ã¡ã

TOP

¤£¦n·N«ä~¦]¼Ð¥Ü¤£°÷ÄYÂÔ~
http://www.FunP.Net/502777~§@¼o¡C

T12©MT41¤G­Ó²Õ¦X¡A¨äÀ³¼Ð¥ÜªºÀx¦s®æ¦³­«Å|¡A
¦A¤W¶Ç¦³¥HÃC¦â°Ï¤À¦U²Õ¦Xªº·sªþ¥ó
http://www.FunP.Net/34272

T12(M12)¬°7¸¹©³¦âªº²Õ¦X(­«Å|³¡¤À¥H7¸¹®Ø½u´À¥N)¡C
T41(M41)¬°45¸¹©³¦âªº²Õ¦X¡C

ÂԽаѦÒ~ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD