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

[µo°Ý] «ü©w­Èªº¹ïÀ³¼Æ+±Æ§Ç

[µo°Ý] «ü©w­Èªº¹ïÀ³¼Æ+±Æ§Ç

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-7-18 17:56 ½s¿è

»Ý¨D¡J
±NYÄæ>=$W$1ªºXÄ檺¦P¦C­È¶ñ¤JZÄæ¡F¥B±NZÄæ­È¥Ñ¤p¦Ó¤j©¹¤U±Æ§Ç¡C
½Ð°Ý¡JZ2ªº2003ª©¨ç¼Æ¤½¦¡¡H
¸Ô¦p½d¨ÒÀÉ
ÁÂÁ¦U¦ì¡I

«ü©w­Èªº¹ïÀ³¼Æ+±Æ§Ç.rar (6.08 KB)

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-7-20 22:02 ½s¿è

Z2
=IF(ROW(A1)>COUNTIF(Y$2:Y$40,">=18"),"",SMALL(IF(Y$2:Y$40>=$W$1,X$2:X$40),ROW(A1)))   2003ª©

§Úªº§x´b¦b©ó
±N18§ï¬°$W$1´N¤£¦æ¤F¡A¦]¬°$W$1´N¯Â¬O$W$1¡A¤£¬O=$W$1ªºÀx¦s®æ­È
=IF(ROW(A1)>COUNTIF(Y$2:Y$40,">=$W$1"),"",SMALL(IF(Y$2:Y$40>=$W$1,X$2:X$40),ROW(A1)))

½Ð¦U¦ì¼ö¤ßªº¤j¤j¤£§[­×¥¿¤½¦¡¡CÁÂÁÂ^^

TOP

¦^´_ 2# ziv976688

¸Õ¸Õ¬Ý   
=IF(ROW(A1)>COUNTIF(Y$2:Y$40,">="& $W$1),"",SMALL(IF(Y$2:Y$40>=$W$1,X$2:X$40),ROW(A1)))

TOP

¦^´_ 3# jcchiang
°ÝÃD¸Ñ¨M¤F !
¸U¤À·PÁ±zªºÀ°¦£ !

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD