{"id":3209,"date":"2023-07-29T09:58:05","date_gmt":"2023-07-29T09:58:05","guid":{"rendered":"http:\/\/s1.dressupeverything.com\/%e5%87%bd%e6%95%b0%e6%8e%92%e5%90%8d\/"},"modified":"2023-07-29T09:58:05","modified_gmt":"2023-07-29T09:58:05","slug":"%e5%87%bd%e6%95%b0%e6%8e%92%e5%90%8d","status":"publish","type":"post","link":"https:\/\/maomaochia.com\/zh\/%e5%87%bd%e6%95%b0%e6%8e%92%e5%90%8d\/","title":{"rendered":"\u600e\u6837\u5c06\u4e00\u7ec4\u6570\u5b57\u6392\u540d\uff1f RANK\u51fd\u6570\u6392\u540d\u600e\u4e48\u7528\uff1f"},"content":{"rendered":"<\/p>\n<div class=\"inner-post-entry entry-content\" id=\"penci-post-entry-inner\">\n<div style=\"margin: 8px auto;text-align: center;clear: both\">\n<div class=\"ai-attributes\">\n<div class=\"adofl-label\">Advertisement<\/div>\n<\/div>\n<p><a href=\"https:\/\/maomaochia.courses\/webdev\/?utm_source=maomaochia&amp;utm_medium=banner_top&amp;utm_campaign=d01\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webdev-book-ver-min.png\" data-rel=\"penci-gallery-image-content\"  data-recalc-dims=\"1\" data-lazy-src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/1_webdev-book-ver-min.png\" class=\" jetpack-lazy-image\" title=\"webdev-book-ver-min\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webdev-book-ver-min.png\" data-recalc-dims=\"1\" title=\"webdev-book-ver-min\"><\/a><\/div>\n<p>\u4eca\u5929\u7ed9\u5927\u5bb6\u8bf4\u7684\u662fRANK\u51fd\u6570\uff0c\u8fd9\u4e2a\u51fd\u6570\u5c31\u662f\u7528\u6765RANK\u4f60\u60f3\u6392\u540d\u7684\u6570\u5b57\uff0c\u5e94\u7528\u6bd4\u8f83\u5e7f\u6cdb\uff0c\u4f7f\u7528\u4e5f\u662f\u5f88\u7b80\u5355\uff0c\u6211\u6765\u7ed9\u5927\u5bb6\u73b0\u89e3\u91ca\u4e00\u4e0bRANK\u51fd\u6570\u6392\u540d\u3002<\/p>\n<p><span id=\"more-10797\"><\/span><\/p>\n<h3><span id=\"1Rank-han-shu-pai-ming-zen-me-yong\">1.Rank\u51fd\u6570\u6392\u540d\u600e\u4e48\u7528\uff1f<\/span><\/h3>\n<p>\u5f53\u4f60\u60f3\u8981\u6392\u540d\u3001\u6392\u5e8f\u7684\u65f6\u5019\uff0c\u4f60\u8981\u60f3\u5230Rank\u51fd\u6570\uff0c\u5f88\u597d\u8bb0\u5fc6\uff0c\u8fd9\u4e2a\u82f1\u6587\u5355\u8bcd\u5c31\u662f\u6392\u540d\u7684\u610f\u601d\uff0c\u90a3\u4e48\u5148\u6765\u89e3\u91ca\u4e00\u4e0b\u8fd9\u4e2a\u51fd\u6570\u6240\u6709\u7684\u6761\u4ef6\uff1a<\/p>\n<p>\u2981 Number\uff1a\u662f\u8981\u67e5\u627e\u6392\u540d\u7684\u6570\u5b57<br \/>\u2981 Ref\uff1a\u662f\u4e00\u7ec4\u6570\u6216\u8005\u5bf9\u4e00\u4e2a\u6570\u636e\u5217\u8868\u7684\u5f15\u7528\uff0c\u975e\u6570\u5b57\u503c\u5c06\u4f1a\u88ab\u5ffd\u7565<br \/>\u2981 Order\uff1a\u5728\u5217\u8868\u4e2d\u6392\u540d\u7684\u6570\u5b57\uff0c\u82e5\u4e3a0\u662f\u5ffd\u7565\u3001\u964d\u5e8f\uff1b\u975e\u96f6\u503c\u662f\u5347\u5e8f<\/p>\n<div>\n<div class=\"penci-custom-html-inside-content\"><ins class=\"adsbygoogle\" style=\"text-align:center\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-5714391875552789\" data-ad-slot=\"3533928161\"><\/ins><\/div>\n<\/div>\n<h3>  <\/h3>\n<h3><span id=\"2RANK-han-shu-shi-ji-cao-zuo-an-li\">2.RANK\u51fd\u6570\u5b9e\u9645\u64cd\u4f5c\u6848\u4f8b<\/span><\/h3>\n<p>\u8fd9\u4e2a\u662fEXCEL\u4e2d\u5bf9RANK\u7684\u89e3\u91ca\uff0c\u662f\u4e0d\u662f\u770b\u4e0d\u61c2\uff1f\uff1f\u6ca1\u4e8b\uff0c\u6211\u7528\u4e00\u4e2a\u5b9e\u9645\u7684\u6848\u4f8b\u6765\u5e26\u4f60\u770b\u770b\u600e\u4e48\u7528RANK\u3002<br \/>\u73ed\u7ea7\u4e2d\u6709\uff11\uff18\u540d\u5b66\u751f\uff0c\u8003\u8bd5\u5206\u6570\u5206\u522b\u662f\u4e0b\u56fe\uff0c\u73b0\u5728\u8981\u628a\u8fd9\u4e9b\u5b66\u751f\u7684\u6210\u7ee9\u6392\u5e8f\u3002<\/p>\n<h3>  <\/h3>\n<p>Number\uff1a\u5c31\u662f\u9009\u4e2d\u5176\u4e2d\u4e00\u4e2a\u5355\u5143\u683c<br \/>Ref\uff1a\u5c31\u662fB2\uff1aB19<br \/>Order:\u53ef\u4ee5\u51991<br \/>\u9700\u8981\u6ce8\u610f\u54e6\uff0c\u5728\u8fd9\u4e2a\u60c5\u51b5\u4e0b\u5982\u679c\u5c31\u6309\u7167\u4e0a\u9762\u7684\u6765\uff0c\u5f97\u5230\u7684\u7ed3\u679c\u662f\u4e0d\u5bf9\u7684\uff1a<\/p>\n<div style=\"margin: 8px auto;text-align: center;clear: both\">\n<div class=\"ai-attributes\">\n<div class=\"adofl-label\">Advertisement<\/div>\n<\/div>\n<p><a href=\"https:\/\/maomaochia.courses\/webdev\/?utm_source=maomaochia&amp;utm_medium=banner_content&amp;utm_campaign=d01\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webcourse-ads1.png\" data-rel=\"penci-gallery-image-content\"  data-recalc-dims=\"1\" data-lazy-src=\"https:\/\/i2.wp.com\/zh.maomaochia.com\/wp-content\/uploads\/sites\/12\/2020\/10\/webcourse-ads1.png?w=1170&amp;is-pending-load=1#038;ssl=1\" class=\" jetpack-lazy-image\" title=\"webcourse-ads1\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webcourse-ads1.png\" data-recalc-dims=\"1\" title=\"webcourse-ads1\"><\/a><\/div>\n<h3>  <\/h3>\n<h3><span id=\"3-wei-shen-meRANK-han-shu-ji-suan-chu-lai-de-pai-ming-bu-dui\">3.\u4e3a\u4ec0\u4e48RANK\u51fd\u6570\u8ba1\u7b97\u51fa\u6765\u7684\u6392\u540d\u4e0d\u5bf9\uff1f<\/span><\/h3>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u4e0d\u4e00\u6837\u7684\u5206\u6570\uff0c\u6392\u540d\u5374\u4e00\u6837\uff0c\u6240\u4ee5\u5c31\u6709\u95ee\u9898\u55bd\uff01\u4e3a\u4ec0\u4e48\u4f1a\u4e0d\u5bf9\u5462\uff1f\u6211\u6765\u544a\u8bc9\u5927\u5bb6\u3002<br \/>\u7b2c\u4e00\u4e2a\u60f3\u8981\u6c42RANK\u7684\u5355\u5143\u683cC2=RANK(B2,B2:B19,1)<br \/>\u4e0b\u62c9\u4e4b\u540e\uff0c\u7b2c\u4e8c\u4e2a\u5355\u5143\u683c\u5c31\u662fC4=RANK(B3,B3:B20,1)<br \/>\u53ef\u4ee5\u770b\u5230\u4e24\u4e2a\u516c\u5f0f\u5e76\u4e0d\u80fd\u7528\u540c\u4e00\u4e2a\u6570\u636e\u7684\u533a\u57df\uff0c\u540e\u9762\u7684\u5355\u5143\u683c\u4f9d\u6b21\u7c7b\u63a8\u5c31\u662f\u8fd9\u6837\uff0c\u5176\u5b9e\u770b\u6bcf\u4e2a\u5355\u5143\u683c\u7684\u516c\u5f0f\uff0c\u5c31\u77e5\u9053\u505a\u7684\u4e0d\u5bf9\u4e86\u3002\u90a3\u8981\u600e\u4e48\u89e3\u51b3\u5462\uff1f\u5173\u952e\u5728\u4e8eRef\u7684\u8303\u56f4\u9700\u8981\u7edd\u5bf9\u5f15\u7528\uff0c\u4e5f\u5c31\u662f\u8fd9\u4e2a\u8303\u56f4\u88ab\u9009\u5b9a\uff0c\u4e0d\u4f1a\u56e0\u4e3a\u4e0b\u62c9\u516c\u5f0f\u800c\u6539\u53d8\u3002<\/p>\n<h3><span id=\"4-jue-dui-yin-yong-de-kuai-jie-jian\">\uff14.\u7edd\u5bf9\u5f15\u7528\u7684\u5feb\u6377\u952e<\/span><\/h3>\n<p>\u7edd\u5bf9\u5f15\u7528\u7684\u5feb\u6377\u952e\u6211\u7ed9\u5927\u5bb6\u666e\u53ca\u4e00\u4e0b\uff0c\u9009\u4e2d\u5355\u5143\u683c\u4e4b\u540e\uff0c\u70b9\u51fbF4\uff0cB2\uff1aB19\u7684\u683c\u5f0f\u5c31\u4f1a\u53d8\u6210$B$2:$B$19<\/p>\n<div>\n<div class=\"penci-custom-html-inside-content\"><ins class=\"adsbygoogle\" style=\"text-align:center\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-5714391875552789\" data-ad-slot=\"3533928161\"><\/ins><\/div>\n<\/div>\n<h3><span id=\"5-wei-shen-me-jue-dui-yin-yong-shi-anF4mei-you-yong\">5.\u4e3a\u4ec0\u4e48\u7edd\u5bf9\u5f15\u7528\u65f6\u6309F4\u6ca1\u6709\u7528\uff1f<\/span><\/h3>\n<p>\u6709\u4e9b\u4eba\u53ef\u80fd\u70b9\u51fbF4\u4e4b\u540e\u6ca1\u6709\u7528\uff0c\u7535\u8111\u6392\u81f3\u548c\u7248\u672c\u4e0d\u4e00\u6837\u7684\u8bdd\uff0c\u662f\u53ef\u80fd\u7684\uff0c\u4f60\u53ef\u4ee5\u8bd5\u8bd5\uff0c\u9009\u4e2d\u5355\u5143\u683c\u4e4b\u540e\uff0c\u540c\u65f6\u70b9\u51fbFn\u548cF4\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u4e86\uff01<\/p>\n<div style=\"margin: 8px auto;text-align: center;clear: both\">\n<div class=\"ai-attributes\">\n<div class=\"adofl-label\">Advertisement<\/div>\n<\/div>\n<p><a href=\"https:\/\/maomaochia.courses\/webdev\/?utm_source=maomaochia&amp;utm_medium=banner_content&amp;utm_campaign=d01\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webcourse-ads3.png\" data-rel=\"penci-gallery-image-content\"  data-recalc-dims=\"1\" data-lazy-src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webcourse-ads3.png\" class=\" jetpack-lazy-image\" title=\"webcourse-ads3-63\"><img decoding=\"async\" src=\"https:\/\/maomaochia.com\/zh\/wp-content\/uploads\/sites\/3\/2023\/08\/webcourse-ads3.png\" data-recalc-dims=\"1\" title=\"webcourse-ads3-63\"><\/a><\/div>\n<p>\u63a5\u4e0b\u6765\u5c31\u9009\u4e2d\u6570\u636e\u8303\u56f4\uff1a<\/p>\n<h3>  <\/h3>\n<p>\u5b8c\u6574\u7684RANK\u51fd\u6570\u7684\u516c\u5f0f==RANK(B2,$B$2:$B$19,1)<br \/>\u7136\u540e\u4e0b\u62c9\u5f97\u5230\u6b63\u786e\u7684\u6392\u540d\u8868\u5355\uff0c\u4e00\u6837\u7684\u5206\u6570\u8fd8\u662f\u4f1a\u5e2e\u4f60\u6392\u5728\u4e00\u6837\u7684\u540d\u6b21\u54e6\uff0c\u5f88\u5f3a\u5927\u628a\uff01<\/p>\n<h3>  <\/h3>\n<p>\u8fd9\u6b21\u8bb2\u7684RANK\u51fd\u6570\uff0c\u5176\u5b9e\u5e94\u7528\u65f6\u975e\u5e38\u5e7f\u6cdb\u7684\uff0c\u7528RANK\u51fd\u6570\u53c8\u51c6\u786e\u53c8\u6b63\u786e\uff0c\u5173\u952e\u5728\u4e8e\u7edd\u5bf9\u5f15\u7528\u7684\u6b63\u786e\u4f7f\u7528\uff0c\u7528\u5bf9\u4e86\u5c31\u4e0d\u662f\u95ee\u9898\u5566\uff01\u4e0b\u6b21\u518d\u7ed9\u5927\u5bb6\u5206\u4eab\u5b9e\u7528\u7684EXCEL\u51fd\u6570\u4f7f\u7528\u6848\u4f8b\uff01<\/p>\n<div>\n<div class=\"penci-custom-html-inside-content\"><ins class=\"adsbygoogle\" style=\"text-align:center\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-5714391875552789\" data-ad-slot=\"3533928161\"><\/ins><\/div>\n<\/div>\n<ul>\n<li><a href=\"https:\/\/maomaochia.com\/zh\/excel%e6%9d%a1%e4%bb%b6%e7%bb%9f%e8%ae%a1-countif%e5%87%bd%e6%95%b0-%e7%94%a8excel%e7%bb%9f%e8%ae%a1%e8%8c%83%e5%9b%b4%e5%86%85%e4%b8%aa%e6%95%b0\/\">Excel\u6761\u4ef6\u7edf\u8ba1 Countif\u51fd\u6570\uff5c\u6559\u4f60\u7528excel\u7edf\u8ba1\u8303\u56f4\u5185\u4e2a\u6570\u3010\u9644\u52a0\u6848\u4f8b\u3011<\/a><\/li>\n<li><a href=\"https:\/\/maomaochia.com\/zh\/if%e7%94%a8%e6%b3%95-excel-if%e5%87%bd%e6%95%b0\/\">\uff08IF\u7528\u6cd5\uff09Excel\u4e2d\u7684If\u51fd\u6570\u57fa\u7840\u6559\u5b66\uff0cExcel\u505a\u5224\u65ad\u7528\u8fd9\u4e2a<\/a><\/li>\n<\/ul>\n<div class=\"post-tags\"> <a href=\"https:\/\/maomaochia.com\/zh\/tag\/%e6%95%99%e7%a8%8b\/\" rel=\"tag\">\u6559\u7a0b<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><span id=\"more-10797\"><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[4,7],"tags":[],"class_list":["post-3209","post","type-post","status-publish","format-standard","hentry","category-4","category-7"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/posts\/3209"}],"collection":[{"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/comments?post=3209"}],"version-history":[{"count":0,"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/posts\/3209\/revisions"}],"wp:attachment":[{"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/media?parent=3209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/categories?post=3209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maomaochia.com\/zh\/wp-json\/wp\/v2\/tags?post=3209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}