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

½Ð­×¥¿¤½¦¡ªºbug¡CÁÂÁ¡I

½Ð­×¥¿¤½¦¡ªºbug¡CÁÂÁ¡I


½Ð­×¥¿¤½¦¡ªºbug.rar (3.12 KB)
B2=IF(MAX($A$2:A2)>=MAX($B1:$Z1),"",SMALL($B1:$Z1,COUNTIF($B1:$Z1,"<="&A2)+1))
B9=IF(MAX($A$9:A9)>=MAX($B8:$Z8),"",SMALL($B8:$Z8,COUNTIF($B8:$Z8,"<="&A9)+1))
¤G­Ó¤½¦¡°£¤F­pºâ¦ì§}ªº½d³ò¤£¦P¤§¥~¡A¨ä§PÂ_ªºÅÞ¿è«h§¹¥þ¬Û¦P¡C

°ÝÃD¡J°£«DA9¬°ªÅ¥Õ¡A§_«hB9ªº¤½¦¡¨S¦³¿ìªkÅã¥Ü¡i­«½Æ¨ú¨ä1¨Ã¥Ñ¤p¦Ó¤j±Æ§Ç¡jªº¥¿½Tµª®×¡C

»Ý¨D¡J
1_½Ð°Ý¡J¬°¤°»òB2¥i¥HÅã¥Ü¥¿½Tªºµª®×¡A¦Ó B9«o¤£¦æ¡H
2_¥t·Ð½Ð­×¥¿B9¤½¦¡ªºbug¡C
ÁÂÁ¡I

=IF(MAX($A$2:A2)>=MAX($B1:$Z1),"",SMALL($B1:$Z1,COUNTIF($B1:$Z1,"<="&N(A2))+1))

TOP

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

·PÁª©¥D¤j¤jªº«ü¥¿^^

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-4-28 10:22 ½s¿è

¦^´_ 2# ­ã´£³¡ªL
¤£¦n·N«ä¡A§ä¨ì±zªº³o­Ó¸Ñµª¤½¦¡¡A¬O¤p§Ì»Ý­nªº¡C
¦ý¦pªG¦U¨ú1ªº­È¦³¥]¬A0­È(«DªÅ¥Õ®æ)®É¡A
½Ð°Ý :B15ªº­×¥¿ ¤½¦¡­n¦p¦ó½s¼g?
ÁÂÁ±z

¦U¼Æ­È¨ú1§t0­È.rar (2.48 KB)

TOP

¦^´_ 4# ziv976688


=IF(MAX($A13:A$13)>=MAX($10:$10),"",SMALL($10:$10,COUNTIF($10:$10,"<="&A13)+1))

TOP

¦^´_ 5# ­ã´£³¡ªL
­ì¨Ó¦³N( )©M¨S¦³N( )ªº®t§O¬O¦b«e1Ä榳µL¼ÐÃD¥H¥~¡AÁÙ¦³¯à¤£¯àÅã¥Ü0­Èªº¥\¯à¡C
ÁÂÁ±zªº¤£§[«ü¾É~·P®¦

TOP

¦^´_ 5# ­ã´£³¡ªL
ª©¥D¤j¤j:
=IF(MAX($A13:A$13)>=MAX($10:$10),"",SMALL($10:$10,COUNTIF($10:$10,"<="&A13)+1))
­n§ï¦¨¥Ñ¤j¦Ó¤p(­°¾­)±Æ¦C¡A¤½¦¡À³¸Ó¦p¦ó§ï?
§Ú¦³±NMAX©MSMALL©M>©M<¦U§ï¬°MIN©MLARGE©M<©M>
¦ýÅã¥Ü¤£¥X¥¿½Tµª®×^^"
ÁÂÁ±z^^

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-4-30 15:48 ½s¿è

¦pªG§ï¦¨  
=IF(MAX($A13:A$13)>=MAX($10:$10),"",LARGE($10:$10,COUNTIF($10:$10,">="&A13)+1))
¤Ö¤F³Ì¤j­È~Åã¥Ü¤£¥X¨Ó^^"

TOP

¦^´_ 8# papaya


=IF(COUNTIF($A13:A$13,MIN(10:10)),"",LARGE(10:10,COUNTIF(10:10,">="&A13&"e0")+1))

TOP

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

­«½Æ¨ú1+±Æ§Ç.rar (7.65 KB)
ª©¥D¤j¤j¡J±z¦n¡I
¤£¦n·N«ä¡A¥H¹ê°Èªí®æ´ú¸Õµ²ªG~·í"³Q·j´Mªº¦C"¦³¼ÐÃD®É¡A·|¼vÅTµª®×(³Ì¤j­ÈµLªkÅã¥Ü)¡C
«_¬N³Â·Ð±z¦A½ç±Ð"³Q·j´M¦C"µL¼ÐÃDªº¤½¦¡~
©Î¤£¨ü"·j´M¦C"¼ÐÃD¼vÅTªº¤½¦¡¤]¥i¥H¡C
ÁÂÁ±z^^

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD