{"id":9074,"date":"2025-01-01T12:42:09","date_gmt":"2025-01-01T12:42:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lap-bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel\/"},"modified":"2025-01-01T12:42:09","modified_gmt":"2025-01-01T12:42:09","slug":"huong-dan-lap-bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-lap-bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>T\u1ea1i c\u00e1c tr\u01b0\u1eddng h\u1ecdc, nh\u1eefng b\u1ea3ng t\u00ednh qu\u1ea3n l\u00fd ho\u1ea1t \u0111\u1ed9ng nh\u01b0 danh s\u00e1ch l\u1edbp, b\u1ea3ng \u0111i\u1ec3m m\u00f4n, b\u1ea3ng \u0111i\u1ec3m thi\u2026 l\u00e0 r\u1ea5t quan tr\u1ecdng. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i \u1edf \u0111\u00e2u c\u0169ng c\u00f3 \u0111\u1ea7y \u0111\u1ee7 ph\u01b0\u01a1ng ti\u1ec7n c\u0169ng nh\u01b0 c\u00e1c ph\u1ea7n m\u1ec1m chuy\u00ean d\u1ee5ng h\u1ed7 tr\u1ee3, ho\u1eb7c ch\u1ec9 h\u1ed7 tr\u1ee3 nh\u1eefng c\u00f4ng vi\u1ec7c ph\u1ee9c t\u1ea1p. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ebfn nh\u1eefng b\u1ea3ng t\u00ednh Excel \u2013 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c l\u1ea1i r\u1ea5t d\u1ec5 s\u1eed d\u1ee5ng. Sau \u0111\u00e2y H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eadn b\u1ea1n c\u00e1ch l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp.<\/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-67753820f3109\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html#Nhung_cong_thuc_can_thiet_de_lap_bang_xep_hang_hoc_sinh_theo_tung_lop\" title=\"Nh\u1eefng c\u00f4ng th\u1ee9c c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp\">Nh\u1eefng c\u00f4ng th\u1ee9c c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html#1_Ham_RANK_hoac_COUNTIF\" title=\"1. H\u00e0m RANK ho\u1eb7c COUNTIF\">1. H\u00e0m RANK ho\u1eb7c COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html#2_Xep_hang_khong_lien_tuc_khong_nhay_bac\" title=\"2. X\u1ebfp h\u1ea1ng kh\u00f4ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc\">2. X\u1ebfp h\u1ea1ng kh\u00f4ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html#Xay_dung_bang_tinh\" title=\"X\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh\">X\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Nhung_cong_thuc_can_thiet_de_lap_bang_xep_hang_hoc_sinh_theo_tung_lop\"><\/span>Nh\u1eefng c\u00f4ng th\u1ee9c c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 thi\u1ebft l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp, \u0111\u01a1n gi\u1ea3n ta ch\u1ec9 c\u1ea7n\u00a0<strong>02\u00a0<\/strong>c\u00f4ng th\u1ee9c.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"1_Ham_RANK_hoac_COUNTIF\"><\/span>1. H\u00e0m RANK ho\u1eb7c COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi h\u00e0m\u00a0<strong>RANK<\/strong> ta s\u1ebd thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=RANK(\u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh 1, danh s\u00e1ch \u0111i\u1ec3m s\u1ed1,th\u1ee9 t\u1ef1 t\u1eeb cao xu\u1ed1ng th\u1ea5p hay t\u1eeb th\u1ea5p l\u00ean cao)<\/strong><\/p>\n<\/blockquote>\n<p>Xem th\u00eam v\u1ec1 h\u00e0m RANK t\u1ea1i \u0111\u00e2y:\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html\">S\u1eed d\u1ee5ng h\u00e0m RANK<\/a><\/strong><\/p>\n<p>C\u00f2n h\u00e0m COUNTIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u1ebfp h\u1ea1ng nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(danh s\u00e1ch \u0111i\u1ec3m s\u1ed1,\u201d&gt;\u201d&amp; \u0111i\u1ec3m s\u1ed1 c\u1ee7a h\u1ecdc sinh 1)+1<\/strong><\/p>\n<\/blockquote>\n<p>H\u00e0m COUNTIF trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd \u0111\u1ebfm nh\u1eefng \u0111i\u1ec3m s\u1ed1 l\u1edbn h\u01a1n \u0111i\u1ec3m s\u1ed1 c\u1ee7a t\u1eebng h\u1ecdc sinh, sau \u0111\u00f3 c\u1ed9ng v\u1edbi 1 \u0111\u1ec3 ra \u0111\u01b0\u1ee3c x\u1ebfp h\u1ea1ng. V\u00ed d\u1ee5, h\u1ecdc sinh th\u1ee9 nh\u1ea5t c\u00f3 \u0111i\u1ec3m cao nh\u1ea5t, h\u00e0m\u00a0<strong>COUNTIF<\/strong> tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 0, sau \u0111\u00f3 c\u1ed9ng v\u1edbi 1 th\u00e0nh x\u1ebfp h\u1ea1ng 1.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"2_Xep_hang_khong_lien_tuc_khong_nhay_bac\"><\/span>2. X\u1ebfp h\u1ea1ng kh\u00f4ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Chuy\u1ec7n g\u00ec s\u1ebd x\u1ea3y ra n\u1ebfu hai ng\u01b0\u1eddi b\u1eb1ng \u0111i\u1ec3m nhau? H\u00e0m\u00a0<strong>RANK<\/strong> hay\u00a0<strong>COUNTIF<\/strong> \u0111\u1ec1u s\u1ebd tr\u1ea3 v\u1ec1 x\u1ebfp h\u1ea1ng nh\u1ea3y b\u1eadc (v\u00ed d\u1ee5: 1-3-4-5-6: thi\u1ebfu h\u1ea1ng 2 do hai ng\u01b0\u1eddi cao nh\u1ea5t b\u1eb1ng \u0111i\u1ec3m).<\/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-2.gif\" title=\"ex101_92019-nho-2\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, ta s\u1ebd s\u1eed d\u1ee5ng s\u1ef1 h\u1ed7 tr\u1ee3 t\u1eeb\u00a0<strong>COUNTIF<\/strong> v\u00e0\u00a0<strong>COUNT.\u00a0<\/strong>C\u00e1ch l\u00e0m c\u1ee5 th\u1ec3, c\u00e1c b\u1ea1n h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html\"><strong>X\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc trong Excel<\/strong><\/a><\/p>\n<figure id=\"attachment_25780\" aria-describedby=\"caption-attachment-25780\" style=\"width: 430px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25780\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xep-hang-diem-so-1.png\" width=\"430\" height=\"185\" title=\"xep-hang-diem-so-1\"><figcaption id=\"caption-attachment-25780\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng h\u00e0m RANK v\u00e0 COUNTIF<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_bang_tinh\"><\/span>X\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng b\u1ea3ng t\u00ednh, c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 x\u1ebfp h\u1ea1ng \u0111i\u1ec3m trung b\u00ecnh. T\u00f9y t\u1eebng tr\u01b0\u1eddng s\u1ebd c\u00f3 nh\u1eefng th\u00f4ng tin ri\u00eang, tuy v\u1eady v\u1eabn s\u1ebd c\u00f3 nh\u1eefng ti\u00eau \u0111\u1ec1 c\u1ed9t chung sau \u0111\u00e2y:<\/p>\n<p><strong>S\u1ed1 th\u1ee9 t\u1ef1<\/strong><\/p>\n<p><strong>T\u00ean h\u1ecdc sinh<\/strong><\/p>\n<p><strong>M\u00e3 s\u1ed1<\/strong><\/p>\n<p><strong>\u0110i\u1ec3m trung b\u00ecnh<\/strong><\/p>\n<p><strong>X\u1ebfp lo\u1ea1i<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25782\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xep-hang-diem-so-2.png\" width=\"628\" height=\"450\" title=\"xep-hang-diem-so-2\"><\/p>\n<p>Sau \u0111\u00f3, v\u1eadn d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c t\u1eeb tr\u00ean, ta thi\u1ebft l\u1eadp x\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc gi\u1ea3m d\u1ea7n, b\u1eaft \u0111\u1ea7u nh\u1eadp t\u1eeb \u00f4 E2:<\/p>\n<blockquote>\n<p><strong>=(COUNTIF($D$2:$D$15,\u201d&gt;\u201d&amp;D2)+1)+(COUNTIF($D$2:D2,D2)-1)<\/strong><\/p>\n<\/blockquote>\n<p>Vi\u1ebft g\u1ecdn h\u01a1n:<\/p>\n<blockquote>\n<p><strong>=COUNTIF($D$2:$D$15,\u201d&gt;\u201d&amp;D2)+COUNTIF($D$2:D2,D2)<\/strong><\/p>\n<\/blockquote>\n<p>Ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>RANK:<\/strong><\/p>\n<blockquote>\n<p><strong>=RANK(D2,$D$2:$D$15)+(COUNTIF($D$2:D2,D2)-1)<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25783\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xep-hang-diem-so-3.png\" width=\"633\" height=\"501\" title=\"xep-hang-diem-so-3\"><\/p>\n<p>Tuy nhi\u00ean, c\u00e1ch l\u00e0m n\u00e0y c\u00f3 m\u1ed9t v\u1ea5n \u0111\u1ec1. \u0110\u00f3 l\u00e0 vi\u1ec7c x\u1ebfp h\u1ea1ng kh\u00f4ng nh\u1ea3y b\u1eadc s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, d\u1eabn \u0111\u1ebfn s\u1ef1 \u201ckh\u00f4ng c\u00f4ng b\u1eb1ng\u201d: nh\u1eefng ng\u01b0\u1eddi t\u00ean \u1edf tr\u00ean n\u1ebfu c\u00f9ng \u0111i\u1ec3m s\u1ebd c\u00f3 h\u1ea1ng cao h\u01a1n ng\u01b0\u1eddi \u1edf d\u01b0\u1edbi. B\u1edfi v\u1eady, khi ti\u1ebfn h\u00e0nh t\u1ea1o b\u1ea3ng \u0111i\u1ec3m, ta kh\u00f4ng khuy\u1ebfn kh\u00edch vi\u1ec7c x\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c n\u00e0y m\u00e0 c\u1ea7n ph\u1ea3i ti\u1ebfn h\u00e0nh x\u1ebfp h\u1ea1ng theo nh\u1eefng hi\u1ec7u s\u1ed1 kh\u00e1c.<\/p>\n<hr>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-rank-va-ham-countif-de-xep-hang-lien-tuc-khong-nhay-bac-trong-excel.html\"><strong>S\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u00e0 RANK \u0111\u1ec3 x\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-rank-de-xep-hang-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m RANK \u0111\u1ec3 x\u1ebfp h\u1ea1ng trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-thiet-lap-so-thu-tu-thanh-phan-bang-phan-loai.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 b\u1ea3ng ph\u00e2n lo\u1ea1i<\/strong><\/a><\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh\u00a0cho nhi\u1ec1u\u00a0l\u1edbp trong Excel<\/strong><\/p>\n<p>\u00a0<\/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-2.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9074","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\/9074","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=9074"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9074\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9075"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}