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

excel ±Æ§Ç°ÝÃD

EXCELµæ³¾¨D±Ï

¦pªGA1=BÄ檺¬Y¤@Äæ¦ìªº­È¡A¦ÓBÄæÄæ¦ì¥Ñ sum(c1:c4)¬Ûµ¥¦Ó¦¨¡C
¨Ò¦p¡Gsum(c1:c4)=5¡A§YA1=B5Äæ¦ìªº­È
            sum(c1:c4)=9¡A§YA1=B9Äæ¦ìªº­È
½Ð°Ý¡GA1ªº¨ç¼Æ¸Ó¦p¦ó³]©w¡H

TOP

¦^´_ 1# shuilin
=indirect("B" & sum(c1:c4))

TOP

¦^´_ 2# stillfish00


    ·PÁ±z³o»ò§Ö´N¦^´_¡A¨ä¹ê§Ú¬O¦³­Ó·Q°µ­Ó§Q¥Î¶Ã¼Æ±Æ§Çªº°ÝÃD¡C

TOP

excel ±Æ§Ç°ÝÃD

¦pªGb1=20¡A¨º»òa2¨ìa20³£¬°=RAND()¡Ab2¨ìb20¬°=RANK(A2,A$2:A$20)
¦pªGb1=15¡A¨º»òa2¨ìa20³£¬°=RAND()¡Ab2¨ìb20¬°=RANK(A2,A$2:A$15)
¦pªGb1=10¡A¨º»òa2¨ìa20³£¬°=RAND()¡Ab2¨ìb20¬°=RANK(A2,A$2:A$10)
½Ð°Ýb1¬OÅܼơA¨º»òb2¨ìb20ªº¨ç¼Æ¸Ó¦p¦ó³]©w¡H Book1.rar (7.44 KB)

¦^´_ 1# shuilin

b2 =IFERROR(RANK(A2,INDIRECT("A$2:A$"&$B$1)),"")
ss

TOP

¦^´_ 4# shuilin
B2
=RANK(A2,OFFSET($A$2,,,VALUE($B$1)-1,1))

TOP

·PÁ¦U¦ìªº«üÂI¡A¤p§Ì¤w¼g¥X»Ý­nªº¨ç¼Æ¡AÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD