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

[µo°Ý] ¨ç¼Æ_¤½¦¡Â²¤Æ¡C

[µo°Ý] ¨ç¼Æ_¤½¦¡Â²¤Æ¡C

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-13 07:37 ½s¿è

¤p§Ì±N­ã´£³¡ªLª©¥D½ç±Ðªº2­Ó°}¦C¤½¦¡¤À§O©µ¦ù¬°¤T¬q¡A°£¤F±N¤T¬q¤½¦¡¥H*ª½±µ³sµ²¦X¨Ö¥~¡A¯à§_¦³¥¦ªk¥i±N¤½¦¡¦A²¤Æ?


¤£­­Äæ¦ì¤½¦¡
=IF(L_1,"",IF(AND(MMULT(--TEXT(IF(SUMIF(OFFSET($I$6,T$5-{3;2;1},1,,7),OFFSET($I$6,$R$6-3,1,3,7)),SUMIF(OFFSET($I$6,$R7-{3;2;1},1,,7),OFFSET($I$6,$R$6-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^1)>0)*AND(MMULT(--TEXT(IF(SUMIF(OFFSET($I$6,$R$6-{3;2;1},1,,7),OFFSET($I$6,$R7-3,1,3,7)),SUMIF(OFFSET($I$6,T$5-{3;2;1},1,,7),OFFSET($I$6,$R7-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^1)>0)*AND(MMULT(--TEXT(IF(SUMIF(OFFSET($I$6,$R7-{3;2;1},1,,7),OFFSET($I$6,T$5-3,1,3,7)),SUMIF(OFFSET($I$6,R$6-{3;2;1},1,,7),OFFSET($I$6,T$5-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^1)>0),$R7-3,""))

­­¦PÄæ¦ì¤½¦¡
=IF(L_1,"",IF(AND(MMULT(--TEXT(IF(OFFSET($I$6,$R$6-3,1,3,7)=OFFSET($I$6,T$5-3,1,3,7),N(OFFSET($I$6,$R$6-3,1,3,7)=OFFSET($I$6,$R7-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^0)>0)*AND(MMULT(--TEXT(IF(OFFSET($I$6,$R7-3,1,3,7)=OFFSET($I$6,$R$6-3,1,3,7),N(OFFSET($I$6,$R7-3,1,3,7)=OFFSET($I$6,T$5-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^0)>0)*AND(MMULT(--TEXT(IF(OFFSET($I$6,T$5-3,1,3,7)=OFFSET($I$6,$R7-3,1,3,7),N(OFFSET($I$6,T$5-3,1,3,7)=OFFSET($I$6,R$6-3,1,3,7)),""),"1;;-9;!0"),ROW($1:$7)^0)>0),$R7-3,""))

PS:½Ð«O¯dAND¨ç¼Æªº¥Îªk¡A¥H§Q¤p§Ì¥i¥H±N¨ä§ó§ï¬°OR®É¡A§Y¥i²Å¦X¬Y¤@¦Cªº¥t¤@­Ó±ø¥ó»Ý¨D¡CÁÂÁÂ!

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

¥»©«³Ì«á¥Ñ Airman ©ó 2015-12-13 22:17 ½s¿è

¸É¥Rªþ¥ó~
http://www.FunP.Net/412140

ÂԨѰѦÒ!ÁÂÁÂ!

TOP

¦^´_ 2# Airman
¸É¥R¥t¤@¤è¦¡ªº»¡©ú~§Æ±æ¹ï¸ÑÃD¦³À°§U~


ªþ¥ó: ¥t¤@¤è¦¡ªº»¡©ú.rar (3.64 KB)
ÂԨѰѦÒ!ÁÂÁÂ!

TOP

¦^´_ 2# Airman

¸U¤À©êºp~·U»¡·U¶Ã~ #3§@¼o¡C

¦A­«·s¾ã²z~
·sªþ¥ó¡J ¥t¤@¤è¦¡ªº»¡©ú-­«·s¾ã²z.rar (4.18 KB)

ÂԨѰѦÒ!ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD