{"id":9324,"date":"2025-01-02T01:17:34","date_gmt":"2025-01-02T01:17:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel\/"},"modified":"2025-01-02T01:17:34","modified_gmt":"2025-01-02T01:17:34","slug":"huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK \u0111\u1ec3 x\u1ebfp h\u1ea1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u00e0m RANK l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n c\u1ee7a\u00a0Excel d\u00f9ng cho m\u1ee5c\u00a0\u0111\u00edch x\u1ebfp h\u1ea1ng. Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc\u00a0Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK m\u1ed9t c\u00e1ch chi ti\u1ebft v\u00e0 c\u1ee5 th\u1ec3 nh\u1ea5t.<\/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-6775e92dbc757\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html#Cau_truc_cua_ham_RANK\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m RANK\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m RANK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html#Xep_hang_theo_thu_tu_tang_dan_voi_ham_RANK\" title=\"X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0v\u1edbi h\u00e0m RANK\">X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0v\u1edbi h\u00e0m RANK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html#Xep_hang_theo_thu_tu_giam_dan_bang_ham_RANK\" title=\"X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n\u00a0b\u1eb1ng h\u00e0m RANK\">X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n\u00a0b\u1eb1ng h\u00e0m RANK<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham_RANK\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m RANK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m RANK\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=RANK(number, ref,\u00a0[order])<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li><strong>Number<\/strong>: s\u1ed1 c\u1ea7n x\u1ebfp h\u1ea1ng trong danh s\u00e1ch<\/li>\n<li><strong>Ref<\/strong>: danh s\u00e1ch c\u00e1c s\u1ed1<\/li>\n<li><strong>Order<\/strong>: th\u1ee9 t\u1ef1 x\u1ebfp h\u1ea1ng.\u00a0G\u1ed3m 2 c\u00e1ch s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (s\u1ed1 0 = m\u1eb7c \u0111\u1ecbnh n\u1ebfu kh\u00f4ng nh\u1eadp) hay th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (s\u1ed1 1)<\/li>\n<\/ul>\n<p>H\u00e0m RANK\u00a0\u0111\u01b0\u1ee3c d\u00f9ng trong m\u1ecdi phi\u00ean b\u1ea3n c\u1ee7a\u00a0Excel nh\u01b0\u00a0Excel 2003,\u00a0Excel 2007,\u00a0Excel 2010,\u00a0Excel 2013,\u00a0Excel 2016,\u00a0Office 365\u2026<\/p>\n<p>Tuy nhi\u00ean trong c\u00e1c phi\u00ean b\u1ea3n m\u1edbi c\u1ee7a\u00a0Excel (t\u1eeb 2010 tr\u1edf\u00a0\u0111i) c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m RANK.AVG v\u00e0 RANK.EQ\u00a0\u0111\u1ec3\u00a0vi\u1ec7c s\u1eafp x\u1ebfp\u00a0\u0111\u01b0\u1ee3c c\u1ee5 th\u1ec3 h\u01a1n, ch\u00ednh x\u00e1c h\u01a1n. Tuy nhi\u00ean ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m RANK trong m\u1ecdi phi\u00ean b\u1ea3n m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng.<\/p>\n<p>Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng x\u00e9t m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANK\u00a0\u0111\u1ec3 x\u1ebfp h\u1ea1ng trong\u00a0Excel<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xep_hang_theo_thu_tu_tang_dan_voi_ham_RANK\"><\/span>X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0v\u1edbi h\u00e0m RANK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24870\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rank-xep-hang-theo-diem-1.png\" width=\"453\" height=\"240\" title=\"ham-rank-xep-hang-theo-diem-1\"><\/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-38.gif\" title=\"ex101_92019-nho-38\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111i\u1ec3m c\u1ee7a m\u1ed7i ng\u01b0\u1eddi x\u1ebfp h\u1ea1ng th\u1ee9 m\u1ea5y\u00a0trong danh s\u00e1ch\u00a0\u0111i\u1ec3m trung b\u00ecnh B2:B8, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Rank:<\/p>\n<p style=\"padding-left: 30px\">C2=RANK(B2,$B$2:$B$8)<\/p>\n<ul>\n<li>X\u00e9t\u00a0\u0111i\u1ec3m TB t\u1ea1i\u00a0\u00f4 B2, trong danh s\u00e1ch\u00a0\u0111i\u1ec3m t\u1eeb B2:B8<\/li>\n<li>Kh\u00f4ng s\u1eed d\u1ee5ng tham s\u1ed1 t\u1ea1i\u00a0[order] t\u1ee9c l\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ta th\u1ea5y:<\/p>\n<ul>\n<li>Ng\u01b0\u1eddi c\u00f3\u00a0\u0111i\u1ec3m TB cao nh\u1ea5t l\u00e0 9.5\u00a0\u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng 1<\/li>\n<li>Ng\u01b0\u1eddi c\u00f3\u00a0\u0111i\u1ec3m TB l\u00e0 8.1\u00a0\u0111\u01b0\u1ee3c x\u1ebfp th\u1ee9 2, trong\u00a0\u0111\u00f3 c\u00f3 2 ng\u01b0\u1eddi c\u00f9ng\u00a0\u0111i\u1ec3m, do\u00a0\u0111\u00f3 c\u00f3 2 v\u1ecb tr\u00ed x\u1ebfp h\u1ea1ng 2 l\u00e0 d\u00f2ng 3 v\u00e0 d\u00f2ng 6<\/li>\n<li>Do 2 ng\u01b0\u1eddi\u00a0\u0111\u1ed3ng h\u1ea1ng 2 n\u00ean s\u1ebd kh\u00f4ng c\u00f3 x\u1ebfp h\u1ea1ng 3. H\u1ea1ng ti\u1ebfp theo s\u1ebd l\u00e0 h\u1ea1ng 4,\u00a0\u1ee9ng v\u1edbi s\u1ed1\u00a0\u0111i\u1ec3m TB l\u00e0 7.6<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Xep_hang_theo_thu_tu_giam_dan_bang_ham_RANK\"><\/span>X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n\u00a0b\u1eb1ng h\u00e0m RANK<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>X\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n khi ch\u00fang ta mu\u1ed1n\u00a0\u0111\u00e1nh gi\u00e1 tr\u00ean nh\u1eefng ti\u00eau ch\u00ed \u201ckh\u00f4ng t\u1ed1t\u201d, c\u0103n c\u1ee9 v\u00e0o\u00a0\u0111\u00f3\u00a0\u0111\u1ec3\u00a0\u0111\u00e1nh gi\u00e1 xem ai c\u00f3 gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t th\u00ec t\u1ed1t nh\u1ea5t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24872\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rank-xep-hang-thu-tu-giam-dan-1.png\" width=\"479\" height=\"210\" title=\"ham-rank-xep-hang-thu-tu-giam-dan-1\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta mu\u1ed1n x\u1ebfp h\u1ea1ng theo s\u1ed1 l\u1ed7i m\u00e0 m\u1ed7i ng\u01b0\u1eddi m\u1eafc ph\u1ea3i. Ai\u00a0\u00edt l\u1ed7i nh\u1ea5t th\u00ec x\u1ebfp th\u1ee9 1. S\u1ed1\u00a0l\u1ed7i t\u0103ng d\u1ea7n th\u00ec th\u1ee9 t\u1ef1 x\u1ebfp h\u1ea1ng s\u1ebd t\u0103ng d\u1ea7n.<\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m RANK v\u1edbi\u00a0<strong>Order = 1<\/strong><\/p>\n<p style=\"padding-left: 30px\">C2=RANK(B2,$B$2:$B$8,1)<\/p>\n<ul>\n<li>Gi\u00e1 tr\u1ecb x\u00e9t x\u1ebfp h\u1ea1ng:\u00a0\u00f4 B2<\/li>\n<li>V\u00f9ng danh s\u00e1ch c\u00e1c s\u1ed1 tham chi\u1ebfu: B2:B8. V\u00f9ng n\u00e0y c\u1ea7n <a href=\"http:\/\/blog.ezworkapp.com\/cach-giu-o-tham-chieu-co-dinh-trong-excel.html\">c\u1ed1\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ec3 kh\u00f4ng thay\u00a0\u0111\u1ed5i trong c\u00e1c c\u00f4ng th\u1ee9c<\/a><\/li>\n<li>Th\u1ee9 t\u1ef1 x\u1ebfp h\u1ea1ng: gi\u1ea3m d\u1ea7n, d\u00f9ng s\u1ed1 1<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady 2 ng\u01b0\u1eddi c\u00f3 l\u1ed7i\u00a0\u00edt nh\u1ea5t (l\u00e0 1 l\u1ed7i) th\u00ec\u00a0\u0111\u1ec1u x\u1ebfp th\u1ee9 1. Ng\u01b0\u1eddi m\u1eafc nhi\u1ec1u l\u1ed7i nh\u1ea5t (l\u00e0 8 l\u1ed7i) x\u1ebfp th\u1ee9 7<\/p>\n<p>Tuy nhi\u00ean trong 2 c\u00e1ch s\u1eafp x\u1ebfp tr\u00ean, ch\u00fang ta th\u1ea5y h\u00e0m RANK cho ph\u00e9p nh\u1eefng gi\u00e1 tr\u1ecb gi\u1ed1ng nhau th\u00ec c\u00f9ng chung 1 th\u1ee9 h\u1ea1ng. Nh\u01b0ng th\u1ef1c t\u1ebf\u00a0\u0111\u00f4i khi ch\u00fang ta c\u1ea7n x\u1ebfp h\u1ea1ng c\u1ee5 th\u1ec3 cho t\u1eebng b\u1eadc, n\u1ebfu gi\u1ed1ng nhau th\u00ec c\u1ea7n c\u00f3 th\u00eam ti\u00eau ch\u00ed ph\u1ee5\u00a0\u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9\u00a0\u0111\u00e1nh gi\u00e1 x\u1ebfp h\u1ea1ng. Khi\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd c\u00f3 th\u00eam 2 ki\u1ec3u x\u1ebfp h\u1ea1ng:<\/p>\n<p><strong>Ki\u1ec3u th\u1ee9 1: X\u1ebfp h\u1ea1ng\u00a0li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc (kh\u00f4ng\u00a0\u0111\u1ed3ng h\u1ea1ng)<\/strong><\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-rank-va-ham-countif-de-xep-hang-lien-tuc-khong-nhay-bac-trong-excel.html\">C\u00e1ch d\u00f9ng\u00a0h\u00e0m RANK v\u00e0 h\u00e0m COUNTIF\u00a0\u0111\u1ec3 x\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc\u00a0trong\u00a0Excel<\/a><\/p>\n<p><strong>Ki\u1ec3u th\u1ee9 2: X\u1ebfp h\u1ea1ng theo\u00a0\u0111i\u1ec1u ki\u1ec7n<\/strong><\/p>\n<p>N\u1ed9i dung n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-1.html\">X\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n trong excel\u00a0\u2013 Ph\u1ea7n 1<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-2.html\">X\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n trong excel\u00a0\u2013 Ph\u1ea7n\u00a02<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/xep-hang-theo-dieu-kien-trong-excel-phan-3.html\">X\u1ebfp h\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n trong excel\u00a0\u2013 Ph\u1ea7n\u00a03<\/a><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam b\u00e0i vi\u1ebft v\u1ec1 x\u1ebfp h\u1ea1ng trong b\u00e1o c\u00e1o b\u1eb1ng\u00a0Pivot table trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xep-hang-trong-bao-cao-bang-pivot-table.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1ebfp h\u1ea1ng trong b\u00e1o c\u00e1o b\u1eb1ng Pivot Table<\/a><\/p>\n<p>\u00a0<\/p>\n<p><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-38.gif\" title=\"ex101_92019-nho-38\"><br \/>\n<\/a><\/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-38.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9325,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9324","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\/9324","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=9324"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9324\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9325"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}