{"id":8790,"date":"2024-12-29T05:32:56","date_gmt":"2024-12-29T05:32:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-lap-bang-thong-ke-loi-cho-giam-thi-trong-excel\/"},"modified":"2024-12-29T05:32:56","modified_gmt":"2024-12-29T05:32:56","slug":"huong-dan-lap-bang-thong-ke-loi-cho-giam-thi-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/huong-dan-lap-bang-thong-ke-loi-cho-giam-thi-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i cho gi\u00e1m th\u1ecb trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m nhi\u1ec7m v\u1ee5 ki\u1ec3m tra v\u00e0 gi\u1eef g\u00ecn k\u1ec9 lu\u1eadt trong nh\u00e0 tr\u01b0\u1eddng? B\u1ea1n c\u1ea7n m\u1ed9t c\u00f4ng c\u1ee5 n\u00e0o \u0111\u00f3 t\u1ed5ng h\u1ee3p l\u1ea1i nh\u1eefng g\u00ec \u0111\u00e3 ghi ch\u00fa \u0111\u1ec3 b\u00e1o c\u00e1o l\u00ean, \u0111\u1ed3ng th\u1eddi ph\u1ea3i d\u1ec5 hi\u1ec3u \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c theo? Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i \u0111\u01a1n gi\u1ea3n s\u1eed d\u1ee5ng trong m\u00f4i tr\u01b0\u1eddng s\u01b0 ph\u1ea1m.<\/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-6770df07247e7\" 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-thong-ke-loi-trong-excel.html#Bang_thong_ke_loi_don_gian\" title=\"B\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i \u0111\u01a1n gi\u1ea3n\">B\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i \u0111\u01a1n gi\u1ea3n<\/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-thong-ke-loi-trong-excel.html#Khoi_tao_du_lieu\" title=\"Kh\u1edfi t\u1ea1o d\u1eef li\u1ec7u\">Kh\u1edfi t\u1ea1o d\u1eef li\u1ec7u<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/bang-thong-ke-loi-trong-excel.html#Lap_bang_thong_ke_loi_theo_thang_va_bao_cao\" title=\"L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i theo th\u00e1ng v\u00e0 b\u00e1o c\u00e1o\">L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i theo th\u00e1ng v\u00e0 b\u00e1o c\u00e1o<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/bang-thong-ke-loi-trong-excel.html#Tao_bang_du_lieu\" title=\"T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u\">T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/bang-thong-ke-loi-trong-excel.html#Tao_bang_bao_cao\" title=\"T\u1ea1o b\u1ea3ng b\u00e1o c\u00e1o\">T\u1ea1o b\u1ea3ng b\u00e1o c\u00e1o<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Bang_thong_ke_loi_don_gian\"><\/span>B\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Khoi_tao_du_lieu\"><\/span>Kh\u1edfi t\u1ea1o d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26734\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-2.jpg\" width=\"453\" height=\"467\" title=\"bang-thong-ke-loi-2\"><\/p>\n<p>Trong tay b\u1ea1n l\u00e0 danh s\u00e1ch 4 h\u1ecdc sinh vi ph\u1ea1m ng\u00e0y h\u00f4m nay. B\u00e2y gi\u1edd, h\u00e3y t\u1ea1o m\u1ed9t b\u1ea3ng g\u1ed3m t\u00ean nh\u1eefng h\u1ecdc sinh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26735\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-3.png\" width=\"387\" height=\"122\" title=\"bang-thong-ke-loi-3\"><\/p>\n<p><strong>L\u1edbp:\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn ghi t\u00ean l\u1edbp trong gi\u1ea5y, ho\u1eb7c\u00a0<em>l\u1ea5y d\u1eef li\u1ec7u t\u1eeb c\u01a1 s\u1edf d\u1eef li\u1ec7u h\u1ecdc sinh c\u1ee7a tr\u01b0\u1eddng<strong>.<\/strong><\/em><\/p>\n<p><strong>L\u1ed7i vi ph\u1ea1m:<\/strong> \u0110\u1ec3 tr\u00e1nh vi\u1ec7c ph\u1ea3i nh\u1eadp nhi\u1ec1u, ta s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng quy \u0111\u1ecbnh l\u1ed7i theo m\u00e3 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26738\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-4.png\" width=\"257\" height=\"140\" title=\"bang-thong-ke-loi-4\"><\/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-821.gif\" title=\"ex101_92019-nho-821\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Sau \u0111\u00f3 ta s\u1eed d\u1ee5ng c\u00e1c h\u00e0m tham chi\u1ebfu ch\u1eb3ng h\u1ea1n nh\u01b0 <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-vlookup-co-ban-cho-nguoi-moi.html\">VLOOKUP<\/a><\/strong>, <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-index-va-match-qua-bai-tap-co-loi-giai.html\">INDEX\/MATCH<\/a><\/strong>. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng VLOOKUP.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26739\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-5-1024x146-1.png\" width=\"1024\" height=\"146\" title=\"bang-thong-ke-loi-5-1024x146-1\"><\/p>\n<p><strong>=VLOOKUP(D2,$AK$2:$AL$6,2,0)<\/strong><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 l\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i \u0111\u01a1n gi\u1ea3n r\u1ed3i. Kh\u00f4ng h\u1ec1 kh\u00f3 ph\u1ea3i kh\u00f4ng?<\/p>\n<p>Tuy nhi\u00ean, ta s\u1ebd kh\u00f4ng ch\u1ec9 d\u1eebng l\u1ea1i t\u1ea1i \u0111\u00e2y. T\u1eeb b\u1ea3ng n\u00e0y, c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u00e1p d\u1ee5ng m\u00e0 sau \u0111\u00e2y H\u1ecdc Excel Online s\u1ebd \u0111\u01b0a ra m\u1ed9t v\u00ed d\u1ee5: <em>L\u1eadp b\u1ea3ng b\u00e1o c\u00e1o th\u1ed1ng k\u00ea l\u1ed7i theo th\u00e1ng.<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lap_bang_thong_ke_loi_theo_thang_va_bao_cao\"><\/span>L\u1eadp b\u1ea3ng th\u1ed1ng k\u00ea l\u1ed7i theo th\u00e1ng v\u00e0 b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Tao_bang_du_lieu\"><\/span>T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Tr\u01b0\u1edbc ti\u00ean ta h\u00e3y ng\u00f3 qua b\u1ea3ng danh s\u00e1ch l\u1ed7i m\u1ed9t ch\u00fat.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26741\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-4-1.png\" width=\"257\" height=\"140\" title=\"bang-thong-ke-loi-4-1\"><\/h3>\n<p>C\u00e2u h\u1ecfi \u0111\u1eb7t ra \u1edf \u0111\u00e2y l\u00e0, s\u1ebd c\u00f3 nh\u1eefng l\u1ed7i kh\u00e1c ph\u00e1t sinh th\u00eam v\u00e0o. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ta c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i khi tham chi\u1ebfu m\u00e0 kh\u00f4ng ph\u1ea3i ch\u1ecdn l\u1ea1i v\u00f9ng?<\/p>\n<p>T\u00ednh n\u0103ng\u00a0<strong>Table<\/strong> s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng, sau \u0111\u00f3 v\u00e0o th\u1ebb\u00a0<strong>Insert<\/strong>, ta ch\u1ecdn ch\u1ee9c n\u0103ng\u00a0<strong>Table.\u00a0<\/strong>Ch\u1ecdn\u00a0<strong>My Table has headers\u00a0<\/strong>n\u1ebfu c\u00f3 v\u00e0 \u1ea5n OK:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26744\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-6.png\" width=\"518\" height=\"194\" title=\"bang-thong-ke-loi-6\"><\/p>\n<p>T\u1ea1i th\u1ebb ng\u1eef c\u1ea3nh\u00a0<strong>Design<\/strong> v\u1eeba xu\u1ea5t hi\u1ec7n, ta ti\u1ebfn h\u00e0nh \u0111\u1ed5i t\u00ean cho b\u1ea3ng sao cho d\u1ec5 nh\u1edb, ch\u1eb3ng h\u1ea1n nh\u01b0 <strong>Bangloi<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26745\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-7-1024x257-1.png\" width=\"1024\" height=\"257\" title=\"bang-thong-ke-loi-7-1024x257-1\"><\/p>\n<p>Khi \u0111\u00f3 d\u00f9 ta th\u00eam d\u1eef li\u1ec7u,\u00a0<strong>Bangloi\u00a0<\/strong>c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt. C\u00f4ng th\u1ee9c v\u1edbi VLOOKUP khi \u0111\u00f3 c\u0169ng c\u1ea7n m\u1ed9t ch\u00fat thay \u0111\u1ed5i:<\/p>\n<p><em>=VLOOKUP(D2,<strong>Bangloi<\/strong>,2,0)<\/em><\/p>\n<p>B\u00e2y gi\u1edd ta c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u theo th\u00e1ng. V\u00ed d\u1ee5 th\u00e1ng 3\/2019:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26747\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-9.png\" width=\"759\" height=\"123\" title=\"bang-thong-ke-loi-9\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng theo d\u00f5i \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111\u1ed1i t\u01b0\u1ee3ng, ta s\u1eed d\u1ee5ng\u00a0<span style=\"text-decoration: underline\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-split-arrange-hide-unhide.html\">ch\u1ee9c n\u0103ng Split<\/a>.<\/strong><\/span><\/p>\n<figure id=\"attachment_26749\" aria-describedby=\"caption-attachment-26749\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-26749\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-10-1024x358-1.png\" width=\"1024\" height=\"358\" title=\"bang-thong-ke-loi-10-1024x358-1\"><figcaption id=\"caption-attachment-26749\" class=\"wp-caption-text\">T\u00ednh n\u0103ng Split gi\u00fap quan s\u00e1t c\u1ea3 2 b\u1ea3ng d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Tao_bang_bao_cao\"><\/span>T\u1ea1o b\u1ea3ng b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ngo\u00e0i ra, ta s\u1ebd <strong>kh\u00f4ng<\/strong> b\u00e1o c\u00e1o tr\u00ean c\u00f9ng sheet d\u1eef li\u1ec7u nh\u1eadp v\u00e0o. H\u00e3y t\u1ea1o th\u00eam m\u1ed9t Sheet m\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26746\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-8.png\" width=\"298\" height=\"84\" title=\"bang-thong-ke-loi-8\"><\/p>\n<p>T\u1ea1i Sheet n\u00e0y, \u0111\u01a1n gi\u1ea3n ta s\u1ebd l\u00e0m thao t\u00e1c Copy l\u1ea1i nh\u1eefng d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u sau \u0111\u00f3 ch\u00e8n h\u00e0m\u00a0<strong>VLOOKUP<\/strong> v\u00e0o.<\/p>\n<p><em>Gi\u1ea3 s\u1eed \u0111\u1ebfn ng\u00e0y th\u1ee9 10, danh s\u00e1ch h\u1ecdc sinh vi ph\u1ea1m c\u1ee7a b\u1ea1n t\u0103ng l\u00ean 10 v\u00e0 1 l\u1ed7i m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o: \u0110i d\u00e9p l\u00ea.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26751\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-11-1024x188-1.png\" width=\"1024\" height=\"188\" title=\"bang-thong-ke-loi-11-1024x188-1\"><\/p>\n<p>T\u1ea1i b\u1ea3ng b\u00e1o c\u00e1o ta\u00a0c\u00f3 th\u1ec3 copy\u00a0d\u1eef li\u1ec7u v\u00e0o, th\u00eam m\u1ed9t ch\u00fat ch\u1ec9nh s\u1eeda:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26752\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-12.png\" width=\"973\" height=\"634\" title=\"bang-thong-ke-loi-12\"><\/p>\n<p>T\u1ea1i \u0111\u00e2y ta thi\u1ebft l\u1eadp\u00a0<strong>VLOOKUP<\/strong> theo b\u1ea3ng v\u00e0 ti\u1ebfn h\u00e0nh Fill:<\/p>\n<p>=VLOOKUP(\u2018D\u1eef li\u1ec7u\u2019!D2,Bangloi,2,0)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26753\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-13.png\" width=\"489\" height=\"309\" title=\"bang-thong-ke-loi-13\"><\/p>\n<p><strong>L\u1ed7i #N\/A:<\/strong> V\u00ec h\u00f4m \u0111\u00f3 h\u1ecdc sinh n\u00e0y kh\u00f4ng vi ph\u1ea1m n\u00ean kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb tra c\u1ee9u. \u0110\u1ec3 s\u1eeda \u0111i\u1ec1u n\u00e0y ta c\u00f3 th\u1ec3 l\u1ed3ng th\u00eam h\u00e0m\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-nhan-biet-loai-loi-va-cach-bay-loi-trong-excel.html\"><strong>IFERROR<\/strong><\/a>:<\/p>\n<p><strong>=IFERROR(VLOOKUP(\u2018D\u1eef li\u1ec7u\u2019!D2,Bangloi,2,0),\u201d\u201d)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26756\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-14.png\" width=\"868\" height=\"314\" title=\"bang-thong-ke-loi-14\"><\/p>\n<p>Sau \u0111\u00f3, ti\u1ebfn h\u00e0nh ch\u1ec9nh s\u1eeda, \u0111\u1ecbnh d\u1ea1ng v\u00e0 l\u00e0m \u0111\u1eb9p cho b\u1ea3ng t\u00ednh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-26762\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bang-thong-ke-loi-15-1024x403-1.png\" width=\"1024\" height=\"403\" title=\"bang-thong-ke-loi-15-1024x403-1\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 m\u1ed9t b\u1ea3ng b\u00e1o c\u00e1o \u0111\u01a1n gi\u1ea3n r\u1ed3i. Ngo\u00e0i ra, ta c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng v\u00e0 t\u1ed1i \u01b0u h\u01a1n b\u1eb1ng nhi\u1ec1u c\u00e1ch, ch\u1eb3ng h\u1ea1n nh\u01b0 \u1ee9ng d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c kh\u00e1c, ho\u1eb7c s\u1eed d\u1ee5ng\u00a0<strong>VBA.\u00a0<\/strong>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t v\u00e0 t\u00ecm ra nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ed9c \u0111\u00e1o \u0111\u1ec3 h\u1ed7 tr\u1ee3 cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/bang-xep-hang-hoc-sinh-theo-tung-lop-trong-excel.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh theo t\u1eebng l\u1edbp trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/bang-xep-hang-hoc-sinh-cho-nhieu-lop-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng x\u1ebfp h\u1ea1ng h\u1ecdc sinh cho nhi\u1ec1u l\u1edbp 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>S\u1eed d\u1ee5ng COUNTIF thi\u1ebft l\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 b\u1ea3ng ph\u00e2n lo\u1ea1i<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tinh-diem-trung-binh-mon-hoc-sinh-sinh-vien.html\"><strong>T\u00ednh \u0111i\u1ec3m trung b\u00ecnh m\u00f4n cho sinh vi\u00ean<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/lap-so-diem-theo-lop-va-mon-trong-excel.html\"><strong>L\u1eadp s\u1ed5 \u0111i\u1ec3m theo m\u00f4n v\u00e0 l\u1edbp<\/strong><\/a><\/p>\n<p>\u00a0<\/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\/2024\/12\/ex101_92019-nho-821.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8791,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8790","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\/8790","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=8790"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8791"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}