如题所述
RANK
è¿åä¸ä¸ªæ°åå¨æ°åå表ä¸çæä½ãæ°åçæä½æ¯å ¶å¤§å°ä¸å表ä¸å ¶ä»å¼çæ¯å¼ï¼å¦æå表已æè¿åºï¼åæ°åçæä½å°±æ¯å®å½åçä½ç½®ï¼ã
è¯æ³
RANK(number,ref,order)
Number 为éè¦æ¾å°æä½çæ°åã
Ref 为æ°åå表æ°ç»æ对æ°åå表çå¼ç¨ãRef ä¸çéæ°å¼ååæ°å°è¢«å¿½ç¥ã
Order 为ä¸æ°åï¼æææä½çæ¹å¼ã
å¦æ order 为 0ï¼é¶ï¼æçç¥ï¼Microsoft Excel 对æ°åçæä½æ¯åºäº ref 为æç §éåºæåçå表ã
å¦æ order ä¸ä¸ºé¶ï¼Microsoft Excel 对æ°åçæä½æ¯åºäº ref 为æç §ååºæåçå表ã
说æ
å½æ° RANK 对éå¤æ°çæä½ç¸åãä½éå¤æ°çåå¨å°å½±ååç»æ°å¼çæä½ãä¾å¦ï¼å¨ä¸åæååºæåçæ´æ°ä¸ï¼å¦ææ´æ° 10 åºç°ä¸¤æ¬¡ï¼å
¶æä½ä¸º 5ï¼å 11
çæä½ä¸º 7ï¼æ²¡ææä½ä¸º 6 çæ°å¼ï¼ã
ç±äºæäºåå ï¼ç¨æ·å¯è½ä½¿ç¨èèéå¤æ°åçæä½å®ä¹ãå¨åé¢ç示ä¾ä¸ï¼ç¨æ·å¯è½è¦å°æ´æ° 10 çæä½æ¹ä¸º
5.5ãè¿å¯éè¿å°ä¸åä¿®æ£å ç´ æ·»å å°ææä½è¿åçå¼æ¥å®ç°ã该修æ£å ç´ å¯¹äºæç
§ååºè®¡ç®æä½ï¼é¡ºåº = éé¶å¼ï¼ææç
§éåºè®¡ç®æä½ï¼é¡ºåº = 0
æ被忽ç¥ï¼çæ
åµé½æ¯æ£ç¡®çã
éå¤æ°æä½çä¿®æ£å ç´ =[COUNT(ref) + 1 â RANK(number, ref, 0) â RANK(number, ref,
1)]/2ã
å¨ä¸å示ä¾ä¸ï¼RANK(A2,A1:A5,1) çäº 3ãä¿®æ£å ç´ æ¯ (5 + 1 â 2 â 3)/2 = 0.5ï¼èèéå¤æ°æä½çä¿®æ¹æä½æ¯ 3 +
0.5 = 3.5ãå¦ææ°åä»
å¨ ref åºç°ä¸æ¬¡ï¼ç±äºä¸å¿
è°æ´ RANKï¼å æ¤ä¿®æ£å ç´ ä¸º 0ã