{"id":5217,"date":"2024-12-10T01:33:54","date_gmt":"2024-12-10T01:33:54","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel\/"},"modified":"2024-12-10T01:33:54","modified_gmt":"2024-12-10T01:33:54","slug":"huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c ch\u00fang ta th\u01b0\u1eddng g\u1eb7p ph\u1ea3i y\u00eau c\u1ea7u v\u1ec1 l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 theo d\u00f5i\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung c\u1ee5 th\u1ec3, ch\u1ec9 li\u00ean quan ri\u00eang t\u1edbi 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3 c\u1ea7n b\u00e1o c\u00e1o. M\u1ee5c\u00a0\u0111\u00edch\u00a0\u0111\u1ec3 t\u00e1ch ri\u00eang d\u1eef li\u1ec7u li\u00ean quan t\u1edbi\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o\u00a0\u0111\u1ec3 gi\u00fap th\u1ed1ng k\u00ea, ph\u00e2n t\u00edch nh\u1eefng d\u1eef li\u1ec7u\u00a0\u0111\u00f3. K\u1ef9 thu\u1eadt l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft c\u0169ng l\u00e0 m\u1ed9t k\u1ef9 thu\u1eadt cao,\u00a0\u0111\u00f2i h\u1ecfi nhi\u1ec1u y\u1ebfu t\u1ed1 v\u1ec1:<\/p>\n<ul>\n<li>Tr\u00ecnh b\u00e0y b\u00e1o c\u00e1o khoa h\u1ecdc,\u00a0\u0111\u1eb9p m\u1eaft trong\u00a0excel<\/li>\n<li>C\u00e1ch\u00a0\u0111\u1ec3 l\u1ea5y n\u1ed9i dung b\u00e1o c\u00e1o\u00a0t\u1eeb d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u\u00a0\u1edf b\u1ea3ng k\u00ea theo\u00a0\u0111\u00fang\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1eadp b\u00e1o c\u00e1o<\/li>\n<\/ul>\n<p>Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 1 c\u00f4ng th\u1ee9c gi\u00fap vi\u1ec7c l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft tr\u1edf n\u00ean r\u1ea5t d\u1ec5 d\u00e0ng v\u00e0 thu\u1eadn ti\u1ec7nth\u00f4ng qua v\u00ed d\u1ee5 sau:<\/p>\n<p>Ch\u00fang ta c\u00f3 1 b\u1ea3ng k\u00ea th\u00f4ng tin b\u00e1n h\u00e0ng c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng theo c\u00e1c ng\u00e0y (B\u1ea3ng A2:E12), trong\u00a0\u0111\u00f3\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 c\u1ed9t T\u00ean\u00a0m\u1eb7t h\u00e0ng.<\/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-67579a82118ca\" 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-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/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-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Cach_thuc_hien\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Buoc_1_Tao_danh_sach_chon_ten_mat_hang\" title=\"B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean m\u1eb7t h\u00e0ng\">B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean m\u1eb7t h\u00e0ng<\/a><\/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\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Buoc_2_Cong_thuc_lay_du_lieu_vao_bao_cao\" title=\"B\u01b0\u1edbc 2: C\u00f4ng th\u1ee9c\u00a0l\u1ea5y d\u1eef li\u1ec7u v\u00e0o b\u00e1o c\u00e1o\">B\u01b0\u1edbc 2: C\u00f4ng th\u1ee9c\u00a0l\u1ea5y d\u1eef li\u1ec7u v\u00e0o b\u00e1o c\u00e1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Buoc_3_Cach_bay_loi\" title=\"B\u01b0\u1edbc 3:\u00a0C\u00e1ch b\u1eaby l\u1ed7i\">B\u01b0\u1edbc 3:\u00a0C\u00e1ch b\u1eaby l\u1ed7i<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html#Nhung_dieu_can_luu_y\" title=\"Nh\u1eefng\u00a0\u0111i\u1ec1u c\u1ea7n l\u01b0u\u00a0\u00fd\">Nh\u1eefng\u00a0\u0111i\u1ec1u c\u1ea7n l\u01b0u\u00a0\u00fd<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>L\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft cho t\u1eebng m\u1eb7t h\u00e0ng (v\u00f9ng G1:J12), bi\u1ebft r\u1eb1ng\u00a0khi thay\u00a0\u0111\u1ed5i t\u00ean h\u00e0ng th\u00ec b\u00e1o c\u00e1o s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i n\u1ed9i dung t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3.<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14736\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-01.png\" width=\"1326\" height=\"433\" title=\"heo-bcct-offset-01\">C\u00e1ch th\u1ef1c hi\u1ec7n<\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Tao_danh_sach_chon_ten_mat_hang\"><\/span>B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean m\u1eb7t h\u00e0ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ede b\u1ea3ng k\u00ea b\u00e1n h\u00e0ng c\u00f3 3 m\u1eb7t h\u00e0ng l\u00e0 H\u00e0ng A, H\u00e0ng B, H\u00e0ng C. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean m\u1eb7t h\u00e0ng t\u1ea1i\u00a0\u00f4 H2 nh\u01b0 sau:<\/p>\n<p>Ch\u1ecdn tab Data \/ Data Validation<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14737\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-02.png\" width=\"1160\" height=\"680\" title=\"heo-bcct-offset-02\"><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/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\/2024\/12\/ex101_92019-nho-445.gif\" title=\"ex101_92019-nho-445\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-175.gif\" title=\"vba101_92019-nho-175\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-445.gif\" title=\"ex101_92019-nho-445\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong b\u1ea3ng Data Validation:<\/p>\n<ul>\n<li>M\u1ee5c Allow ch\u00fang ta ch\u1ecdn List<\/li>\n<li>M\u1ee5c Data nh\u1eadp n\u1ed9i dung nh\u01b0 sau: H\u00e0ng A, H\u00e0ng B, H\u00e0ng C<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14738\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-03.png\" width=\"580\" height=\"406\" title=\"heo-bcct-offset-03\"><\/p>\n<p>B\u1ea5m ok<\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta t\u1ea1i\u00a0\u00f4 H2 ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn t\u00ean h\u00e0ng theo danh s\u00e1ch g\u1ed3m 3 m\u1eb7t h\u00e0ng n\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Cong_thuc_lay_du_lieu_vao_bao_cao\"><\/span>B\u01b0\u1edbc 2: C\u00f4ng th\u1ee9c\u00a0l\u1ea5y d\u1eef li\u1ec7u v\u00e0o b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0103n c\u1ee9 v\u00e0o v\u1ecb tr\u00ed t\u00ean h\u00e0ng x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf tr\u00ean, l\u1ea5y c\u00e1c n\u1ed9i dung g\u1ed3m: Ng\u00e0y, T\u00ean nh\u00e2n vi\u00ean, s\u1ed1\u00a0l\u01b0\u1ee3ng, th\u00e0nh ti\u1ec1n t\u01b0\u01a1ng\u00a0\u1ee9ng theo m\u1eb7t h\u00e0ng\u00a0\u0111\u00f3 =&gt; S\u1eed d\u1ee5ng h\u00e0m\u00a0OFFSET<\/p>\n<p>B\u1edfi v\u00ec\u00a0k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 1 m\u1ea3ng d\u1eef li\u1ec7u n\u00ean ch\u00fang ta c\u1ea7n s\u1eed d\u1ee5ng t\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng.<\/p>\n<p>Khi vi\u1ebft c\u00f4ng th\u1ee9c m\u1ea3ng, ch\u00fang ta ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng s\u1ebd th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 (G5:J12), sau\u00a0\u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft th\u00fac\u00a0c\u00f4ng th\u1ee9c n\u00e0y ch\u00fang ta s\u1ebd d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + Enter<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m\u00a0OFFSET g\u1ed3m:<\/p>\n<p>=OFFSET(reference, rows, cols, [height], [width])<\/p>\n<ul>\n<li>references: T\u00ean h\u00e0ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o t\u1ea1i\u00a0\u00f4 H2 tr\u00f9ng v\u1edbi t\u00ean h\u00e0ng trong c\u1ed9t A =&gt; C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Index+Match\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed n\u00e0o\u00a0\u1edf c\u1ed9t A c\u00f3 k\u1ebft qu\u1ea3\u00a0\u0111\u00fang<\/li>\n<li>row: s\u1ed1\u00a0d\u00f2ng b\u1eaft \u0111\u1ea7u t\u00ednh t\u1eeb k\u1ebft qu\u1ea3,\u00a0\u1edf\u00a0\u0111\u00e2y t\u00ednh t\u1ea1i d\u00f2ng\u00a0\u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n t\u00ean h\u00e0ng n\u00ean row = 0<\/li>\n<li>cols:\u00a0S\u1ed1 c\u1ed9t b\u1eaft \u0111\u1ea7u\u00a0t\u00ednh t\u1eeb k\u1ebft qu\u1ea3,\u00a0\u1edf\u00a0\u0111\u00e2y l\u1ea5y k\u1ebft qu\u1ea3 b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb c\u1ed9t B t\u1edbi c\u00e1c c\u1ed9t kh\u00e1c (c\u1ed9t B c\u00e1ch c\u1ed9t A l\u00e0 1 c\u1ed9t) n\u00ean cols = 1<\/li>\n<li>\u0110\u1ed9 l\u1edbn c\u1ee7a v\u00f9ng c\u1ea7n l\u1ea5y b\u1edfi h\u00e0m\u00a0OFFSET s\u1ebd l\u00e0:<\/li>\n<\/ul>\n<p>+)\u00a0Height (s\u1ed1\u00a0d\u00f2ng): B\u1eb1ng s\u1ed1 d\u00f2ng c\u00f3\u00a0T\u00ean h\u00e0ng t\u1ea1i H2 tr\u00f9ng v\u1edbi c\u1ed9t T\u00ean h\u00e0ng =&gt; S\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n t\u00ean h\u00e0ng n\u00e0y<\/p>\n<p>+)\u00a0Weight (s\u1ed1 c\u1ed9t):\u00a0\u1edf\u00a0\u0111\u00e2y b\u00e1o c\u00e1o chi ti\u1ebft c\u1ea7n 4 c\u1ed9t, do\u00a0\u0111\u00f3 l\u1ea5y 4 c\u1ed9t t\u01b0\u01a1ng\u00a0\u1ee9ng theo t\u00ean h\u00e0ng n\u00e0y.<\/p>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<ul>\n<li>H\u00e0m Index + Match\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">INDEX($A$3:$A$12,MATCH($H$2,$A$3:$A$12,0))<\/p>\n<ul>\n<li>H\u00e0m COUNTIF\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">COUNTIF($A$3:$A$12,$H$2)<\/p>\n<p>C\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh l\u00e0:<\/p>\n<p>=OFFSET(INDEX($A$3:$A$12,MATCH($H$2,$A$3:$A$12,0)),0,1,COUNTIF($A$3:$A$12,$H$2),4)<\/p>\n<p>Ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14739\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-04.png\" width=\"1324\" height=\"434\" title=\"heo-bcct-offset-04\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Cach_bay_loi\"><\/span>B\u01b0\u1edbc 3:\u00a0C\u00e1ch b\u1eaby l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0OFFSET cho v\u00f9ng b\u1ea3ng G5:J12, t\u00ean h\u00e0ng l\u00e0 H\u00e0ng A, ch\u00fang ta thu\u00a0\u0111\u01b0\u1ee3c 4 d\u00f2ng k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng theo b\u1ea3ng k\u00ea. Nh\u01b0 v\u1eady l\u00e0 k\u1ebft qu\u1ea3 \u0111\u00e3 \u0111\u00fang.<\/p>\n<p>Nh\u01b0ng v\u00f9ng b\u1ea3ng G5:J12 c\u00f3 t\u1edbi 8 d\u00f2ng. V\u1eady nh\u1eefng d\u00f2ng th\u1eeba s\u1ebd xu\u1ea5t hi\u1ec7n l\u1ed7i #N\/A<\/p>\n<p>\u0110\u1ec3 b\u1eaby l\u1ed7i n\u00e0y, kh\u00f4ng\u00a0\u0111\u1ec3 l\u1ed7i hi\u1ec3n th\u1ecb th\u00ec ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional Formatting:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh t\u1eeb <strong>G5:J12<\/strong><\/li>\n<li>Trong tab <strong>Home<\/strong> &gt; Ch\u1ecdn <strong>Conditional formatting<\/strong> &gt; Ch\u1ecdn <strong>New Rule<\/strong><\/li>\n<li>M\u1ee5c <strong>Select a Rule Type<\/strong> ch\u1ecdn<strong> Format only cells that conain<\/strong><\/li>\n<li>M\u1ee5c <strong>Format only cells\u00a0with<\/strong> ch\u1ecdn\u00a0<strong>Errors<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14740\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-05.png\" width=\"1016\" height=\"490\" title=\"heo-bcct-offset-05\"><\/p>\n<p>Ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4 c\u00f3 ch\u1ee9a l\u1ed7i trong v\u00f9ng b\u1ea3ng n\u00e0y trong m\u1ee5c Format &gt; Ch\u1ecdn m\u00e0u ch\u1eef l\u00e0 m\u00e0u tr\u1eafng<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14741\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-06.png\" width=\"1136\" height=\"648\" title=\"heo-bcct-offset-06\"><\/p>\n<p>B\u1ea5m ok v\u00e0 ch\u00fang ta s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14742\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-bcct-offset-07.png\" width=\"562\" height=\"399\" title=\"heo-bcct-offset-07\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_dieu_can_luu_y\"><\/span>Nh\u1eefng\u00a0\u0111i\u1ec1u c\u1ea7n l\u01b0u\u00a0\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Do h\u00e0m\u00a0OFFSET l\u1ea5y ra k\u1ebft qu\u1ea3 l\u00e0 1 m\u1ea3ng li\u1ec1n nhau, do\u00a0\u0111\u00f3 d\u1eef li\u1ec7u trong b\u1ea3ng k\u00ea (ph\u1ea7n nguy\u00ean li\u1ec7u\u00a0\u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o) s\u1ebd ph\u1ea3i\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 theo t\u00ean h\u00e0ng<\/li>\n<li>C\u00e1c c\u1ed9t k\u1ebft qu\u1ea3 trong b\u00e1o c\u00e1o chi ti\u1ebft s\u1ebd l\u1ea5y t\u01b0\u01a1ng\u00a0\u1ee9ng theo v\u1ecb tr\u00ed trong b\u1ea3ng k\u00ea t\u01b0\u01a1ng\u00a0\u1ee9ng theo v\u1ecb tr\u00ed c\u1ed9t t\u00ean h\u00e0ng. Do\u00a0\u0111\u00f3 t\u00f9y theo v\u1ecb tr\u00ed c\u00e1c v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ea5y trong b\u00e1o c\u00e1o chi ti\u1ebft m\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00e1c tham s\u1ed1:\u00a0Row, Cols, Height,\u00a0Weight trong h\u00e0m\u00a0offset cho ph\u00f9 h\u1ee3p.\u00a0\u0110\u1ec3 thu\u1eadn l\u1ee3i h\u01a1n khi l\u00e0m vi\u1ec7c n\u00e0y th\u00ec ch\u00fang ta\u00a0\u0111\u1eb7t c\u00e1c c\u1ed9t k\u1ebft qu\u1ea3 li\u1ec1n k\u1ec1 nhau, tr\u00e1nh vi\u1ec7c c\u1ed9t\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1eadp b\u00e1o c\u00e1o (t\u00ean h\u00e0ng) n\u1eb1m xen gi\u1eefa c\u00e1c c\u1ed9t k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<p>T\u1ea3i v\u1ec1 file m\u1eabu:\u00a0<a href=\"http:\/\/bit.ly\/2IhmiYq\">http:\/\/bit.ly\/2IhmiYq<\/a><\/p>\n<p>Video h\u01b0\u1edbng d\u1eabn chi ti\u1ebft<\/p>\n<iframe loading=\"lazy\" title=\"C\u00f4ng th\u1ee9c l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng v\u1edbi h\u00e0m offset v\u00e0 index match\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/iVHqvrkAVZo?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/lap-bao-cao-tong-hop-tu-dong-voi-excel-va-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p t\u1ef1 \u0111\u1ed9ng v\u1edbi Excel v\u00e0 VBA<\/a><\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u th\u00eam c\u00e1c ki\u1ebfn th\u1ee9c kh\u00e1c v\u1ec1 Excel, h\u00e3y tham gia ngay\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2LVCEMc\"><strong>Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/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\/2024\/12\/ex101_92019-nho-445.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5217","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5217","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=5217"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5217\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5218"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}