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

[µo°Ý] ²Î­p¨Ã±Æ§Ç¤½¦¡

[µo°Ý] ²Î­p¨Ã±Æ§Ç¤½¦¡


°ÝÃD:
½Ð°ÝF3:G5¦p¦ó¥H¤½¦¡¦Û°Ê±a¥XB:CÄæ¡A¼Æ¦r³Ì¦hªº¦WºÙ¨Ã¥HTOP123¤è¦¡±Æ§Ç

´£¿ô:
BÄæ¦WºÙ«D©T©w¡A¤]´N¬O¥i¯à·|¥X²{·sªº¦WºÙ¤£¤@©w¡A©Ò¥HµLªk¨Ï¥Î©T©w¦WºÙ¨Ó²Î­p¦U§O¼Æ¦r¡A¦Ó»Ý¥HBÄæ§Y®É¥X²{ªº¦WºÙª½±µ²Î­p¨Ã±Æ§Ç


´ú¸Õ.rar (7.4 KB)
*¦v¤k¤@ªTµL»~*

¢Ô¢²¡e°}¦C¤½¦¡¡f¡G
=INDEX(B:B,1/MOD(LARGE(IF(ISNUMBER(0/(MATCH(B$3:B$20,B:B,)=ROW(B$3:B$20))),SUMIF(B:B,B$3:B$20,C:C)+1/ROW(B$3:B$20)),ROW(A1)),1))

¢Õ¢²¡D¤@¯ë¤½¦¡¡G
=SUMIF(B:B,F3,C:C)

TOP

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

­ã¤j¡AÁÂÁ±z~~~~~~~~~~~~~~~~~
*¦v¤k¤@ªTµL»~*

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD