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

[µo°Ý] ¤½¦¡Àu¤Æªº°ÝÃD¡C

[µo°Ý] ¤½¦¡Àu¤Æªº°ÝÃD¡C

«e3¤j.png
2019-9-19 04:16
      
«e3¤p.png
2019-9-19 04:17

±NAP13:BX20ªº®æ¦¡§ï¬°AP1:CE7ªº®æ¦¡«á¡A¤½¦¡¹ïÀ³½Õ¾ã¬°~~
«e¤T¤j¡J
AQ3=MAX(--TEXT(INDEX($B:$G,AQ$1,),"[>="&IF(AQ$1="",AO3,999)&"]!0"))
AS3=MAX(--TEXT(INDEX($B:$G,AS$1,),"[>="&IF(AS$1<>"",AQ3,999)&"]!0"))
AU3=MAX(--TEXT(INDEX($B:$G,AU$1,),"[>="&IF(AU$1<>"",AS3,999)&"]!0"))
¨ä¾l......Ãþ±À¡C

«e¤T¤p¡J
AQ3==MIN(--TEXT(INDEX($B:$G,AQ$1,),"[<="&IF(AQ$1="",AO3,-1)&"]!99!9"))
AS3=MIN(--TEXT(INDEX($B:$G,AS$1,),"[<="&IF(AS$1<>"",AQ3,-1)&"]!99!9"))
AU3 =MIN(--TEXT(INDEX($B:$G,AU$1,),"[<="&IF(AU$1<>"",AS3,-1)&"]!99!9"))
¨ä¾l......Ãþ±À¡C

¦]¬°¤£¯à½Æ»sAQ3:AR3ª½±µ¶K¤WAS3©MAU3¡A¥u¯à½Æ»sAS3:AT¶K¤WAU3
©Ò¥H½Ð°Ý¡J
¤½¦¡¯à§_¦AÀu¤Æ¶Ü?
ÁÂÁÂ!
´ú¸Õªþ¥óÀÉ®× : ¤½¦¡Àu¤Æªº°ÝÃD.rar (20.23 KB)

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-24 04:21 ½s¿è

¦^´_ 1# ziv976688
1¼Óªº»Ý¨D¥i©¿²¤¤£±j¨D~¤@¦]¥u¬O¦h¼g1­ÓAS3ªº¤½¦¡¡C¤]¤£¬O¦h³Â·Ðªº¨Æ¡A¤G¦]¦³§ó­«­nªº°ÝÃD¨D¸Ñ~
¤­¦æªº«e3¤p¤u§@ªíªºAR3
=IF(AQ3=999,"",SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX($B:$G,AR$1,)=AQ3,$B$2:$G$2,0),{1,2,3,4,5})*10^{0,2,4,6,8}),"00"&REPT("!,00",4)),"00,",))
½Ð°Ý: ¤½¦¡¤¤ªº1,2,3,4,5©M0,2,4,6,8©M4¥Nªí¤°»ò·N¸q?
PS :¤­¦æªºÄæ¼Æ¤ñ=6:9:8:8:8
¦p¤U¹Ï :
¤­¦æ.png
2019-9-24 03:57


¦]¬°·í®æ¦¡§ï¬°¦p§À¼Æªº«e3¤p¤u§@ªí¡A¨äAR3¤½¦¡´N¥²¶·§ï¬°
=IF(AQ3=999,"",SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX($B:$E,AR$1,)=AQ3,$B$2:$E$2,0),{1,2,3})*10^{0,2,4}),"00"&REPT("!,00",4)),"00,",))
¤~¯àÅã¥Ü¥¿½Tªºµª®×¡C
½Ð°Ý: AR3ªº¤½¦¡§ï¦¨³o¼Ë¥¿½T¶Ü?
PS :§À¼ÆªºÄæ¼Æ¤ñ=4:4:4:4:4:4:4:4:4:3
¦p¤U¹Ï :
§À¼Æ.png
2019-9-24 03:58


¦]¬°539ÁÙ¦³
¥Í¨vªºÄæ¦ì¤ñ=3:3:3:3:3:3:3:3:4:4:4:3
¤K¨öªºÄæ¦ì¤ñ=4:5:5:5:5:5:5:5

¥t¥~¤j¼Ö³z49¦³
¤­¦æªºÄæ¦ì¤ñ=8:12:10:10:9
§À¼ÆªºÄæ¦ì¤ñ=5:5:5:5:5:5:5:5:5:4
¥Í¨vªºÄæ¦ì¤ñ=4:4:4:4:4:4:4:4:4:4:5:4
¤K¨öªºÄæ¦ì¤ñ=6:6:7:6:6:6:6:6

©Ò¥H½Ð«ü¾É©M»¡©ú¤½¦¡¤¤¦U¬qªº·N²[¡A¥H§Q¤£¤~¯à¦]À³®æ¦¡ªºÅܤƦӶñ¤J¾A·í¥¿½Tªº¤½¦¡¡C
ÁÂÁÂ!

´ú¸ÕÀÉ : ´ú¸ÕÀÉ.rar (42.52 KB)

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-24 13:42 ½s¿è

¦^´_ 4# ML089
Mª©¥D : ±z¦n!
·PÁ±z3¼ÓªººëÅP¸ÑÃD¤½¦¡~¹ê¦b¬O¤Ó¯«¤Ó¤è«K¤F^^
......................................................................................................................
¦]¬°¥Ñ3¼Óªº¶Q¸Ñ¡A±oª¾APÄ檺¤å¦r¡A¥i¥H¥Î"INDIRECT"Âà´«~(¥»¨Ó¤£¤~¬O¥H¬°$B$2:$G$2µL¨ç¼Æ¥iÂà´«)~
©Ò¥H2¼Óªº¹Ï¤ù©Mªþ¥ó½d¨Òªº§À¼ÆÀɮפ§AP3:AP12¡A¤]§ï¬°B:E¡FF:I¡F......¡FAL:AN~¦pªþ¥ó : ´ú¸ÕÀÉ_V1.rar (45.92 KB)
ÁÂÁ±z^^

PS: ¥Ø«e¨Ì3¼Óªº¶Q¸Ñ
¤­¦æªºAR3  =SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX(INDIRECT($AP3),AR$1,)=AQ3,INDEX(INDIRECT($AP3),2,),0),{1,2,3,4,5})*10^{0,2,4,6,8}),"00"&REPT("!,00",4)),"00,",)

§À¼ÆªºAR3  =SUBSTITUTE(TEXT(SUM(LARGE(IF(INDEX(INDIRECT($AP3),AR$1,)=AQ3,INDEX(INDIRECT($AP3),2,),0),{1,2,3})*10^{0,2,4}),"00"&REPT("!,00",4)),"00,",)

TOP

¦^´_ 7# ML089
Mª©¥D : ±z¦n!
·PÁ±zªº­@¤ß»¡©ú»P«ü¾É~¤£¤~ÁA¸Ñ¤F^^
¨ä¾l¤£¦PÄæ¦ì¤ñªº¤½¦¡¡A¤£¤~À³¸Ó¥i¥H¦Û¦æ½Õ¾ã¤F~·P®¦...........n+1

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-24 16:34 ½s¿è

¦^´_ 7# ML089

Mª©¥D : ±z¦n!
¤£¦n·N«ä¡A«e3¤j¤½¦¡¦³1­Ó¦a¤è¡A¤£ª¾¯à§_½Õ¾ã?
ÁÂÁ±z!

¤å¦r»¡©ú :
·í¨S¦³¦¸¤jªº¦¸¼Æ­È(AS3)©Î²Ä¤T¤jªº¦¸¼Æ­È(AU3)®É¡A§Æ±æ(AS3)©Î(AU3)¯àÅã¥Ü"N"~
¦]¬°AS3©ÎAU3Åã¥Ü0¡A¦b¬Y±¡ªp¤U(¤×¨ä¬O¦b¤ñ¹ïÄæ¦ì¼Æ¸û¤Ö®É¡A±`·|µo¥Í)¡AAT3©ÎAV3·|²£¥Í"¿ù»~­È"¡C
¸Ô¦p¤U¦C¹Ï¤ù ~
¥¼©R¦W_1.png
2019-9-24 16:18
        
¥¼©R¦W_2.png
2019-9-24 16:19

´ú¸Õªþ¥ó : 539_§À¼Æ±Æ§Ç-V2.rar (4.06 KB)

TOP

¸É¥R :
¦pªGÅã¥Ü¤å¦r¡A·|¤ñ¥ô¦ó¯Â¼Æ­È³£¤j¦Ó¤£¥i¦æ®É¡A¬O§_¯àÅã¥Ü"­t­È"~EX : "-999"¡C
ÁÂÁ±z!

TOP

¦^´_ 11# ML089
Mª©¥D : ±z¦n!
©Ò¦³¤£¤~¯à·Q¨ìªº»Ý¨D¡A³£¤w¶êº¡¹F¦¨¡C
±zªº­@¤ß¨ó§U©M¼ö¤ß«ü¾É~¤£¤~»Ê·P¤­¤º~¦b¦¹«ôÁÂ!!!!!!!!!

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD