① 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鎺掍綅