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

[µo°Ý] ¨ú«e10¤j(¤¤¦¡±Æ¦W)ªº¼Æ­È¡C

[µo°Ý] ¨ú«e10¤j(¤¤¦¡±Æ¦W)ªº¼Æ­È¡C


´ú¸ÕÀÉ¡J ¨ú«e10¤j(¤¤¦¡±Æ¦W)ªº¼Æ­È¡C.rar (2.48 KB)

»Ý¨D¡J
¥Ñ¥ª©¹¥k·j´M$ B3¡J$AX3¡A±N¨ä«e10¤j¼Æ­È¨Ì§Ç¶ñ¤J$B5¡J$AX5(¦³¦P¦W¦¸ªº¼Æ­È®É¡A³sÄò¨Ã¦C¥X)¡A
µLÅã¥Ü­ÈªºÀx¦s­ÓÅã¥ÜªÅ¥Õ¡C

½Ð°Ý¡J
¤W­zªº2003ª©¨ç¼Æ¤½¦¡À³¸Ó¦p¦ó½s¼g¡H
·Ð½Ð¦U¦ì¤j¤j«ü±Ð¡IÁÂÁ¡I

°ÝÃD¤w¸Ñ¨M¡CÁÂÁÂ!
B5
=IF((SUMPRODUCT((LARGE($B3:$AX3,COLUMN(A1))<=$B3:$AX3)/COUNTIF($B3:$AX3,$B3:$AX3))<11),LARGE($B3:$AX3,COLUMN(A1)),"")

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD