① excel涓鎬庢牱鐢ㄦ暟鎹榪涜屾帓浣峞xcel涓鎬庢牱鐢ㄦ暟鎹榪涜屾帓浣嶆樉紺
銆銆瀵笰1錛欰10鏁版嵁榪涜屼腑鍥藉紡鎺掑悕錛屽垯鍦˙1杈撳叆鍏寮=SUMPRODUCT(($A$1:$A$10>A1)*(1/COUNTIF($A$1:$A$10,$A$1:$A$10)))+1
銆銆B1鍏寮忓悜涓嬪嶅埗
銆銆緹庡紡闄嶅簭鎺掑簭
銆銆鍦˙1涓杈撳叆鎴栧嶅埗綺樿創涓嬪垪鍏寮
銆銆=RANK(A:A,A1)
銆銆涓嬫媺濉鍏
銆銆緹庡紡鍗囧簭鎺掑簭
銆銆鍦˙1涓杈撳叆鎴栧嶅埗綺樿創涓嬪垪鍏寮
銆銆=RANK(A:A,A1,1)
銆銆涓嬫媺濉鍏
銆銆鏍規嵁鏁版嵁鐨勭櫨鍒嗘瘮鏉ユ帓浣嶏紝鐢1;
銆銆2;
銆銆3鎺掍綅