rankº¯Êý½µÐòÔõôÓÃ

ÕâÐøÏ**ýÎÄÔ¶²¡¶¼¶ÓÆ·ÒÆRANK

Çë²ÎÔÄ

·µ»ØÒ»¸öÊý×ÖÔÚÊý×ÖÁбíÖеÄÅÅλ¡£Êý×ÖµÄÅÅλÊÇÆä´óСÓëÁбíÖÐÆäËûÖµµÄ±ÈÖµ£¨Èç¹ûÁбíÒÑÅŹýÐò£¬ÎÊ´ðÔòÊý×ÖµÄÅÅλ¾ÍÊÇËüµ±Ç°µÄλÖã©¡£

Óï·¨

RANK(**mber,ref,order)

NumberΪÐèÒªÕÒµ½ÅÅλµÄÊý×Ö¡£

RefΪÊý×ÖÁбíÊý×é»ò¶ÔÊý×ÖÁбíµÄÒýÓá£RefÖеķÇÊýÖµÐͲÎÊý½«±»ºöÂÔ¡£

OrderΪһÊý×Ö£¬Ö¸Ã÷ÅÅλʩÁ¦Ö´µçµÄ·½Ê½¡£

Èç¹ûorderΪ0£¨Á㣩»òÊ¡ÂÔ£¬MicrÎüºþ´¨¿ØÃæËɺìÄ¿ÕëͼÏÂosoftExcel¶ÔÊý×ÖµÄÅÅλÊÇ»ùÓÚrefΪ°´ÕÕ½µÐòÅÅÁеÄÁÐ±í¡£
Èç¹ûorder²»ÎªÁ㣬MicrosoftExcel¶ÔÊý×ÖµÄÅÅλÊÇ»ùÓÚre¾Ù³Ô»¹ºõfΪ°´ÕÕÉýÐòÅÅÁеÄÁÐ±í¡£
˵Ã÷

º¯ÊýRANKÍâÑǽÚѽ»ù·¢ÈÃÑ¡Éܸü³Â¶ÔÖظ´ÊýµÄÅÅλÏàͬ¡£µ«Öظ´ÊýµÄ´æÔÚ½«Ó°ÏìºóÐøÊýÖµµÄÅÅλ¡£ÀýÈ磬ÔÚÒ»Áа´ÉýÐòÅÅÁеÄÕûÊýÖУ¬Èç¹ûÕûÊý10³öÏÖÁ½´Î£¬ÆäÅÅλΪ5£¬Ôò11µÄÅÅλΪ7£¨Ã»ÓÐÅÅλΪ6µÄÊýÖµ£©¡£

ÓÉÓÚijЩԭÒò£¬Óû§¿ÉÄÜʹÓÿ¼ÂÇÖظ´Êý×ÖµÄÅÅ붨Òå¡£ÔÚÇ°ÃæµÄʾÀýÖУ¬Óû§¿ÉÄÜÒª½«ÕûÊý10µÄÅÅλ¸ÄΪ5.5¡£Õâ¿Éͨ¹ý½«ÏÂÁÐÐÞÕýÒòËØÌí¼Óµ½°´ÅÅλ·µ»ØµÄÖµÀ´ÊµÏÖ¡£¸ÃÐÞÕýÒòËضÔÓÚ°´ÕÕÉýÐò¼ÆËãÅÅλ£¨Ë³Ðò=·ÇÁãÖµ£©»ò°´ÕÕ½µÐò¼ÆËãÅÅλ£¨Ë³Ðò=0»ò±»ºöÂÔ£©µÄÇé¿ö¶¼ÊÇÕýÈ·µÄ¡£

Öظ´ÊýÅÅλµÄÐÞÕýÒòËØ=[COUNT(ref)+1¨CRANK(nÎöÀïumber,ref,µôÅ©¼ÆËÕÇë×Ê0)¨CRANK(n·¶°ËË«ËÄÖ½ÔÆijumber,ref,1)]/2¡£

ÔÚÏÂÁÐʾÀýÖУ¬RANK(A2,A1:A5,1Ô¬±ÊÁË)µÈÓÚ3¡£ÐÞÕýÒòËØÊÇ(5+1¨C2¨C3)/2=0.5£¬¿¼ÂÇÖظ´ÊýÅÅλµÄÐÞ¸ÄÅÅλÊÇ3+0.5=3.5¡£Èç¹ûÊý×Ö½öÔÚref³öÏÖÒ»´Î£¬ÓÉÓÚ²»±Øµ÷Áò·¿Ö¹ÓÅϯÃŵ÷Ñ½ñÕûRANK£¬Òò´ËÐÞÕýÒòÖ÷½Ï¸»·À²â³ËØΪ0¡£

ʾÀý

Èç¹ûÄú½«Ê¾Àý¸´ÖƵ½¿Õ°×¹¤×÷±íÖУ¬¿ÉÄÜ»á¸üÒ×ÓÚÀí½â¸ÃʾÀý¡£

²Ù×÷·½·¨

´´½¨¿Õ°×¹¤×÷²¾»ò¹¤×÷±í¡£
ÇëÔÚ¡°°ïÖú¡±Ö÷ÌâÖÐѡȡʾÀý¡£²»ÒªÑ¡È¡ÐлòÁбêÌâ¡£


´Ó°ïÖúÖÐѡȡʾÀý¡£

°´Ct¹¤ÄêÉýÎÝ°û·­¶¼´Ë½¥¶Ïrl+C¡£
ÔÚ¹¤×÷±íÖУ¬Ñ¡Öе¥Ôª¸ñA1£¬ÔÙ°´Ctrl+V¡£
ÈôÒªÔڲ鿴½á¹ûºÍ²é¿´·µ»Ø½á¹ûµÄ¹«Ê½Ö®¼äÇл»£¬Çë°´Ctrl+`£¨ÖØÒô·û£©£¬»òÔÚ¡°¹¤¾ß¡±²Ëµ¥ÉÏ£¬Ö¸Ïò¡°¹«Ê½ÉóºË¡±£¬´Ë°û½öÔÙµ¥»÷¡°¹«Ê½ÉóºËģʽ¡±¡£



A
7
3.5
3.5
1
2
¹«Ê½ËµÃ÷£¨½áÒâ´íµô¶¯¶Ü¸÷ÆÀ¹Ü¹û£©
=RANK(A3,A2:A6,1)3.5¼þ·Àϣѧ¹ûÇøÍõֹÞíÃÅÔÚÉϱíÖеÄÅÅλ(3)
=RANK(A2,A×÷ÎÝÎÂ2:A6,1)7ÔÚÉϱíÖеÄÅÅλ(5)