{"id":12349,"date":"2025-01-15T08:21:21","date_gmt":"2025-01-15T08:21:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rank-ham-xep-thu-hang-trong-excel\/"},"modified":"2025-01-15T08:21:21","modified_gmt":"2025-01-15T08:21:21","slug":"ham-rank-ham-xep-thu-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rank-ham-xep-thu-hang-trong-excel\/","title":{"rendered":"H\u00e0m Rank, h\u00e0m x\u1ebfp th\u1ee9 h\u1ea1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>Trong b\u1ea3ng t\u00ednh nhi\u1ec1u s\u1ed1 li\u1ec7u, ta c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp ch\u00fang theo m\u1ed9t th\u1ee9 t\u1ef1 n\u00e0o \u0111\u00f3, \u0111\u1ec3 t\u1eeb \u0111\u00f3 bi\u1ebft th\u1ee9 h\u1ea1ng v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t d\u00f2ng trong b\u1ea3ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-xep-thu-hang-trong-excel-rank.html\">H\u00e0m <strong>RANK<\/strong><\/a> trong Excel tr\u1ea3 v\u1ec1 th\u1ee9 h\u1ea1ng c\u1ee7a m\u1ed9t s\u1ed1 trong danh s\u00e1ch c\u00e1c s\u1ed1.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67876fff12621\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-xep-thu-hang-trong-excel-rank.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-xep-thu-hang-trong-excel-rank.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span><strong>C\u00fa ph\u00e1p<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">=<strong>RANK( number, ref, [order])<\/strong><\/p>\n<p style=\"text-align: justify\"><em>Trong \u0111\u00f3:<\/em><\/p>\n<p style=\"text-align: justify\"><strong>\u2013 <em>Number<\/em><\/strong>: \u0110\u1ed1i s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm th\u1ee9 h\u1ea1ng cho n\u00f3.<br \/>\n<strong>\u2013 <em>Ref<\/em><\/strong>: M\u1ed9t m\u1ea3ng ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn danh s\u00e1ch c\u00e1c s\u1ed1.<br \/>\n<strong>\u2013 <em>Order<\/em><\/strong>: S\u1ed1 ch\u1ec9 r\u00f5 c\u00e1ch x\u1ebfp h\u1ea1ng. (Order c\u00f3 2 gi\u00e1 tr\u1ecb l\u00e0 0 v\u00e0 1).<\/p>\n<p style=\"text-align: justify\">*<strong>L\u01b0u \u00fd<\/strong>:\u00a0N\u1ebfu Order=0 th\u00ec x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, order =1 th\u00ec x\u1ebfp h\u00e0ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">*Tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u1ecdn s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (Order =0)<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-387.gif\" title=\"ex101_92019-nho-387\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">\u00a0\u2013 Mu\u1ed1n t\u00ecm th\u1ee9 h\u1ea1ng c\u1ee7a s\u1ed1 6 trong b\u1ea3ng s\u1ed1 li\u1ec7u sau \u0111\u00e2y, ta d\u00f9ng h\u00e0m <strong>RANK.\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3365 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-tien-te-8.png\" width=\"600\" height=\"421\" title=\"doi-tien-te-8\"><\/p>\n<p style=\"text-align: justify\">=&gt; K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3366 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-tien-te-9.png\" width=\"600\" height=\"419\" title=\"doi-tien-te-9\"><\/p>\n<p style=\"text-align: justify\">*Tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u1ecdn s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (Order =1)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3367 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-tien-te-10.png\" width=\"600\" height=\"358\" title=\"doi-tien-te-10\"><\/p>\n<p style=\"text-align: justify\">=&gt; K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3368 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-tien-te-11.png\" width=\"600\" height=\"420\" title=\"doi-tien-te-11\"><\/p>\n<p style=\"text-align: justify\">Th\u1ebf l\u00e0 xong, ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n<p>\u0110\u00ea\u0309 co\u0301 th\u00ea\u0309 trau d\u00f4\u0300i ki\u00ea\u0301n th\u01b0\u0301c t\u01b0\u0300 c\u01a1 ba\u0309n \u0111\u00ea\u0301n n\u00e2ng cao v\u00ea\u0300 Excel ca\u0301c ba\u0323n ha\u0303y \u0111\u0103ng ki\u0301 tham gia ngay nh\u01b0\u0303ng kho\u0301a\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\/excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener\">h\u1ecdc Excel v\u0103n ph\u00f2ng<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m v\u00ea\u0300 Excel se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t v\u01a1\u0301i gia\u0301 tha\u0300nh c\u01b0\u0323c h\u00e2\u0301p d\u00e2\u0303n.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-387.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12350,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12349","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12349"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12349\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12350"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}