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

[µo°Ý] ½Ð±Ð²Å¦X¤G±ø¥óªº¥¿½T¤½¦¡¡C

[µo°Ý] ½Ð±Ð²Å¦X¤G±ø¥óªº¥¿½T¤½¦¡¡C


½Ð±Ð²Å¦X¤G±ø¥óªº¥¿½T¤½¦¡¡C.rar (7.29 KB)
B65
=64¦C«e5¤j¥B>$A64 (§Y64¦C¦³¼Ð¥Ü4¸¹©³¦âªºÀx¦s®æ)ªº²Ä2¦C¦PÄ渹½X¡A
¥k©Ô¨ìAN65¡A¨Ã±NÅã¥Ü¥Xªº¸¹½X¥H¥Ñ¤p¦Ó¤j¾î¦C¡C

B66
=64¦C«e10¤j¥B>$A64 (§Y64¦C¦³¼Ð¥Ü4¸¹+¦³¼Ð¥Ü38¸¹©³¦âªºÀx¦s®æ)ªº²Ä2¦C¦PÄ渹½X¡A
¥k©Ô¨ìAN66¡A¨Ã±NÅã¥Ü¥Xªº¸¹½X¥H¥Ñ¤p¦Ó¤j¾î¦C¡C

B68
=67¦C«e5¤j¥B>$A67 (§Y67¦C¦³¼Ð¥Ü4¸¹©³¦âªºÀx¦s®æ)ªº²Ä2¦C¦PÄ渹½X¡A
¥k©Ô¨ìAN68¡A¨Ã±NÅã¥Ü¥Xªº¸¹½X¥H¥Ñ¤p¦Ó¤j¾î¦C¡C

B69
=67¦C«e10¤j¥B>$A67 (§Y67¦C¦³¼Ð¥Ü4¸¹+¦³¼Ð¥Ü38¸¹©³¦âªºÀx¦s®æ)ªº²Ä2¦C¦PÄ渹½X¡A
¥k©Ô¨ìAN69¡A¨Ã±NÅã¥Ü¥Xªº¸¹½X¥H¥Ñ¤p¦Ó¤j¾î¦C¡C

¨ä¾l.....Ãþ±À¡C

½Ð±Ð¤W­z²Å¦X¤G±ø¥óªºB65©MB66¤§¥¿½T¤½¦¡¡CÁÂÁ¡I

¸É¥R :
¦]¬°B65©MB66ªº¤½¦¡ªu¥Î¨ìB68©MB69©M¨ä¾lBÄæÀx¦s®æ®É¡A·|²£¥Í#NUM!¡A
©Ò¥H­ì¦³ªºB65©MB66¤½¦¡¨Ã¤£¥¿½T¡C
½Ð¦U¦ì¤j¤j¤£§[½ç¥¿¡CÁÂÁ !

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-5-6 09:38 ½s¿è

¿ù»~³B~Á|¨Ò»¡©ú~
B69
=IF(COLUMN(A$1)>COUNTIF($B67:$AN67,">="&LARGE($B67:$AN67,10)),"",SMALL(IF(($B67:$AN67>=LARGE($B67:$AN67,10))*($B67:$AN67>$A67),$B$2:$AN$2),COLUMN(A$1)))
¦]¬°67¦Cªº«e10¤jÁÙ¥]¬AAE67=9©MAH67=9¡A¤£¬O>$A67¡A©Ò¥HÅã¥Ü#NUM!

TOP

¦^´_ 3# papaya


=IF(COLUMN(A$1)>COUNTIF($B64:$AN64,">="&MAX(LARGE($B64:$AN64,5),A$64)),"",SMALL(IF($B64:$AN64>=MAX(LARGE($B64:$AN64,5),$A64+1),$B$2:$AN$2),COLUMN(A$1)))

«e10¤j, 5§ï10

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-5-6 13:48 ½s¿è

¦^´_ 4# ­ã´£³¡ªL
½Ð±Ð²Å¦X¤G±ø¥óªº¥¿½T¤½¦¡_v1.rar (7.6 KB)
ª©¥D¤j¤j : ±z¦n!
=IF(COLUMN(A$1)>COUNTIF($B64:$AN64,">="&MAX(LARGE($B64:$AN64,5),A$64)),"",SMALL(IF($B64:$AN64>=MAX(LARGE($B64:$AN64,5),$A64+1),$B$2:$AN$2),COLUMN(A$1)))
66¦C(§t)¥H¤Uªºµª®×¤£¥¿½T^^"
±N¥i¯à¬Oµ§»~ªºA$64§ï¬°$A64
¦C69©M¦C72ªºµª®×ÁÙ¬O¦³#NUM!
·Ð½Ð«ü¥¿¡CÁÂÁ±z^^

TOP

¦^´_ 5# papaya


MAX(LARGE($B67:$AN67,10),$A67+1)

TOP

¦^´_ 6# ­ã´£³¡ªL
ª©¥D¤j¤j : ±z¦n!
MAX(.......,$A64+1)´N¯à´À¥N($B64:$AN64>$A64)~¾Ç²ß¤F^^
ÁÂÁ±zªº­@¤ß«ü¾É~OK¤F~·P®¦^^

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD