{"id":8915,"date":"2024-12-29T07:17:19","date_gmt":"2024-12-29T07:17:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-lap-bang-xep-hang-hoc-sinh-cho-nhieu-lop-trong-excel\/"},"modified":"2024-12-29T07:17:19","modified_gmt":"2024-12-29T07:17:19","slug":"huong-dan-lap-bang-xep-hang-hoc-sinh-cho-nhieu-lop-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-lap-bang-xep-hang-hoc-sinh-cho-nhieu-lop-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, H\u1ecdc Excel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp. V\u1edbi b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp.<\/p>\n<p>Xem l\u1ea1i b\u00e0i vi\u1ebft tr\u01b0\u1edbc:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp trong Excel<\/strong><\/a><\/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-6770f77e65ff1\" 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-cho-nhieu-lop-trong-excel.html#Nhung_cong_thuc_can_thiet_de_lap_bang_xep_hang_hoc_sinh_cho_nhieu_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\u00a0cho nhi\u1ec1u 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\u00a0cho nhi\u1ec1u l\u1edbp<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/bang-xep-hang-hoc-sinh-cho-nhieu-lop-trong-excel.html#Lap_bang_xep_hang_hoc_sinh_cho_nhieu_lop\" title=\"L\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp\">L\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp<\/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_cho_nhieu_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\u00a0cho nhi\u1ec1u l\u1edbp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>\u00a0<\/strong>L\u1ea7n n\u00e0y, thay v\u00ec <strong>RANK ho\u1eb7c<\/strong>\u00a0<strong>COUNTIF<\/strong>, ta s\u1ebd s\u1eed d\u1ee5ng\u00a0<strong>01\u00a0<\/strong>c\u00f4ng th\u1ee9c l\u00e0\u00a0<strong>COUNTIFS<\/strong><\/p>\n<figure id=\"attachment_25788\" aria-describedby=\"caption-attachment-25788\" style=\"width: 729px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25788 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xep-hang-nhieu-lop-1.png\" width=\"729\" height=\"454\" title=\"xep-hang-nhieu-lop-1\"><figcaption id=\"caption-attachment-25788\" class=\"wp-caption-text\">B\u1ea3ng x\u1ebfp h\u1ea1ng kh\u00f4ng ph\u00e2n l\u1edbp<\/figcaption><\/figure>\n<p>Ta ti\u1ebfn h\u00e0nh\u00a0ph\u00e2n lo\u1ea1i d\u1ef1a v\u00e0o 2 \u0111i\u1ec1u ki\u1ec7n l\u00e0\u00a0<strong>L\u1edbp<\/strong> v\u00e0\u00a0<strong>\u0110i\u1ec3m trung b\u00ecnh:<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng v\u1edbi\u00a0<strong>COUNTIFS<\/strong> nh\u01b0 sau (nh\u1eadp t\u1ea1i \u00f4 F2):<\/p>\n<blockquote>\n<p><strong>=COUNTIFS($D$2:$D$15,D2,$E$2:$E$15,\u201d&gt;\u201d&amp;E2)+1<\/strong><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Lap_bang_xep_hang_hoc_sinh_cho_nhieu_lop\"><\/span>L\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0169ng gi\u1ed1ng nh\u01b0 b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ngo\u00e0i nh\u1eefng th\u00f4ng s\u1ed1 c\u01a1 b\u1ea3n, ta c\u00f3 th\u00eam m\u1ed9t c\u1ed9t:\u00a0<strong>L\u1edbp.<\/strong><\/p>\n<p>Ta ti\u1ebfn h\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 F2. Sau \u0111\u00f3 s\u1eed d\u1ee5ng Autofill cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i:<\/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\/2024\/12\/ex101_92019-nho-837.gif\" title=\"ex101_92019-nho-837\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_26532\" aria-describedby=\"caption-attachment-26532\" style=\"width: 749px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26532 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xep-hang-nhieu-lop-2.png\" width=\"749\" height=\"472\" title=\"xep-hang-nhieu-lop-2\"><figcaption id=\"caption-attachment-26532\" class=\"wp-caption-text\">B\u1ea3ng x\u1ebfp h\u1ea1ng chia theo l\u1edbp<\/figcaption><\/figure>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n x\u1ebfp h\u1ea1ng li\u00ean t\u1ee5c kh\u00f4ng nh\u1ea3y b\u1eadc, h\u00e3y nh\u1edb t\u1edbi c\u00f4ng th\u1ee9c trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc. Ti\u1ebfp t\u1ee5c \u00e1p d\u1ee5ng v\u00e0o b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y:<\/p>\n<blockquote>\n<p><strong>=COUNTIFS($D$2:$D$15,D2,$E$2:$E$15,\u201d&gt;\u201d&amp;E2)+1+COUNTIFS($D$2:$D$15,D3,$E$2:$E$15,E3)-1<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26534\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xep-hang-nhieu-lop-3.png\" width=\"846\" height=\"496\" title=\"xep-hang-nhieu-lop-3\"><\/p>\n<p>Tuy nhi\u00ean, c\u0169ng nh\u01b0 l\u1ea7n tr\u01b0\u1edbc, vi\u1ec7c x\u1ebfp h\u1ea1ng n\u00e0y s\u1ebd khi\u1ebfn cho ng\u01b0\u1eddi \u1edf tr\u00ean c\u00f3 h\u1ea1ng cao h\u01a1n ng\u01b0\u1eddi \u1edf d\u01b0\u1edbi. \u0110\u1ec3 x\u00e9t c\u00f4ng b\u1eb1ng, ta ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c hi\u1ec7u s\u1ed1 kh\u00e1c (ch\u1eb3ng h\u1ea1n nh\u01b0 \u0111i\u1ec3m th\u00e0nh ph\u1ea7n). Trong b\u00e0i vi\u1ebft sau, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch x\u1ebfp h\u1ea1ng chi ti\u1ebft h\u01a1n trong m\u1ed9t l\u1edbp.<\/p>\n<hr>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan sau \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<\/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\/2024\/12\/ex101_92019-nho-837.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8916,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8915","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\/8915","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=8915"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8915\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8916"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}