{"id":10160,"date":"2025-01-09T06:06:19","date_gmt":"2025-01-09T06:06:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh\/"},"modified":"2025-01-09T06:06:19","modified_gmt":"2025-01-09T06:06:19","slug":"huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c theo chi nh\u00e1nh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c 1 danh s\u00e1ch ch\u1ecdn (dropdown List) ph\u1ee5 thu\u1ed9c v\u00e0o\u00a0n\u1ed9i dung \u0111\u01b0\u1ee3c ch\u1ecdn \u1edf danh s\u00e1ch kh\u00e1c?\u00a0Gi\u1ea3 s\u1eed nh\u01b0 ch\u00fang ta c\u00f3 4 chi nh\u00e1nh, t\u1ea1i m\u1ed7i chi nh\u00e1nh c\u00f3 s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean kh\u00e1c nhau, t\u00ean nh\u00e2n vi\u00ean kh\u00e1c nhau. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 khi ch\u1ecdn 1 chi nh\u00e1nh trong danh s\u00e1ch chi nh\u00e1nh th\u00ec danh s\u00e1ch nh\u00e2n vi\u00ean s\u1ebd thay \u0111\u1ed5i t\u01b0\u01a1ng \u1ee9ng v\u1edbi chi nh\u00e1nh \u0111\u00f3. C\u1ee5 th\u1ec3 nh\u01b0 v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21241\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/debai-danh-sc3a1ch-che1bb8dn-phe1bba5-thue1bb99c-nv-theo-chi-nhc3a1nh.png\" width=\"1118\" height=\"388\" title=\"debai-danh-sc3a1ch-che1bb8dn-phe1bba5-thue1bb99c-nv-theo-chi-nhc3a1nh\"><\/p>\n<p><span style=\"font-size: 14pt\"><strong>Y\u00eau c\u1ea7u:<\/strong><\/span><\/p>\n<ol>\n<li>Th\u1ed1ng k\u00ea t\u1ed5ng s\u1ed1 ng\u01b0\u1eddi trong m\u1ed7i chi nh\u00e1nh t\u1ea1i d\u00f2ng 12<\/li>\n<li>T\u1ea1o danh s\u00e1ch ch\u1ecdn chi nh\u00e1nh t\u1ea1i \u00f4 G2<\/li>\n<li>T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c chi nh\u00e1nh t\u1ea1i \u00f4 G3<\/li>\n<\/ol>\n<p>Sau \u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch\u00a0t\u1ea1o danh s\u00e1ch nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c theo chi nh\u00e1nh tr\u00ean Excel nh\u00e9:<\/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-677f675af001c\" 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-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Thong_ke_tong_so_nguoi_trong_moi_chi_nhanh\" title=\"Th\u1ed1ng k\u00ea t\u1ed5ng s\u1ed1 ng\u01b0\u1eddi trong m\u1ed7i chi nh\u00e1nh\">Th\u1ed1ng k\u00ea t\u1ed5ng s\u1ed1 ng\u01b0\u1eddi trong m\u1ed7i chi nh\u00e1nh<\/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-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Tao_danh_sach_chon_chi_nhanh\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn chi nh\u00e1nh\">T\u1ea1o danh s\u00e1ch ch\u1ecdn chi nh\u00e1nh<\/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-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Tao_danh_sach_chon_nhan_vien_phu_thuoc_chi_nhanh\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c chi nh\u00e1nh\">T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c chi nh\u00e1nh<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Xac_dinh_vi_tri_cot\" title=\"X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ed9t\">X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ed9t<\/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-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Xac_dinh_toa_do_diem_dau_vung_danh_sach\" title=\"X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m \u0111\u1ea7u v\u00f9ng danh s\u00e1ch\">X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m \u0111\u1ea7u v\u00f9ng danh s\u00e1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Xac_dinh_toa_do_diem_cuoi_vung_danh_sach\" title=\"X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m cu\u1ed1i v\u00f9ng danh s\u00e1ch\">X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m cu\u1ed1i v\u00f9ng danh s\u00e1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tao-danh-sach-nhan-vien-phu-thuoc-theo-chi-nhanh.html#Tao_danh_sach_chon_nhan_vien\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean\">T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thong_ke_tong_so_nguoi_trong_moi_chi_nhanh\"><\/span>Th\u1ed1ng k\u00ea t\u1ed5ng s\u1ed1 ng\u01b0\u1eddi trong m\u1ed7i chi nh\u00e1nh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u1ed1ng k\u00ea s\u1ed1 ng\u01b0\u1eddi trong m\u1ed7i chi nh\u00e1nh, ch\u00fang ta s\u1ebd c\u1ea7n ph\u1ea3i \u0111\u1ebfm s\u1ed1 \u00f4\u00a0c\u00f3 ch\u1ee9a n\u1ed9i dung trong m\u1ed7i c\u1ed9t.<\/p>\n<p>\u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, trong Excel ch\u00fang ta s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dem-o-trong-excel-dung-ham-count-va-counta.html\">h\u00e0m COUNTA<\/a>. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p>A12=COUNTA(A2:A11)&amp;\u201d ng\u01b0\u1eddi\u201d<\/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-138.gif\" title=\"ex101_92019-nho-138\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>H\u00e0m COUNTA(A2:A11)<\/strong> ra k\u1ebft qu\u1ea3 l\u00e0 con s\u1ed1 th\u1ec3 hi\u1ec7n t\u1ed5ng s\u1ed1 ng\u01b0\u1eddi<\/li>\n<li><strong>K\u00fd t\u1ef1 &amp;<\/strong> \u0111\u1ec3 n\u1ed1i chu\u1ed7i<\/li>\n<li><strong>ng\u01b0\u1eddi<\/strong> l\u00e0 1 chu\u1ed7i k\u00fd t\u1ef1, \u0111\u1ec3 c\u00f3 th\u1ec3 gh\u00e9p v\u1edbi 1 h\u00e0m th\u00ec ch\u00fang ta ph\u1ea3i \u0111\u1eb7t chu\u1ed7i \u0111\u00f3 trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<\/ul>\n<p>Sau khi t\u00ednh \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ea1i A12, ch\u00fang ta s\u1ebd copy c\u00f4ng th\u1ee9c sang c\u00e1c c\u1ed9t b\u00ean ph\u1ea3i, tr\u00ean c\u00f9ng d\u00f2ng 12 v\u00e0 thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21242\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/kq01-ham-counta-dem-so-nguoi-trong-cac-chi-nhanh.png\" width=\"582\" height=\"416\" title=\"kq01-ham-counta-dem-so-nguoi-trong-cac-chi-nhanh\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_chi_nhanh\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn chi nh\u00e1nh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn cho c\u00e1c chi nh\u00e1nh, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Data Validation trong th\u1ebb Data.<\/p>\n<p>Khi m\u1edf c\u1eeda s\u1ed5 Data Validation, ch\u00fang ta ch\u1ecdn ti\u1ebfp:<\/p>\n<ul>\n<li>M\u1ee5c Allow: Ch\u1ecdn List<\/li>\n<li>Source: Ch\u1ecdn v\u00f9ng A1:D1 l\u00e0 danh s\u00e1ch c\u00e1c chi nh\u00e1nh<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21243\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/kq02-data-validation-cho-chi-nhanh.png\" width=\"1185\" height=\"505\" title=\"kq02-data-validation-cho-chi-nhanh\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 ch\u00fang ta c\u00f3 danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 G2 l\u00e0 danh s\u00e1ch c\u00e1c chi nh\u00e1nh t\u1eeb Chi nh\u00e1nh 01 \u0111\u1ebfn chi nh\u00e1nh 04<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Data Validation \u0111\u1ec3 nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb select box<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-thiet-lap-chi-nhap-du-lieu-dang-ngay-thang-trong-o-tren-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng trong \u00f4 tr\u00ean Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_nhan_vien_phu_thuoc_chi_nhanh\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c chi nh\u00e1nh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta \u0111\u00e3 bi\u1ebft c\u00e1ch \u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn trong 1 \u00f4, \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng Data Validation. Nh\u01b0ng \u0111i\u1ec1u quan tr\u1ecdng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 x\u00e1c \u0111\u1ecbnh \u0111\u00fang \u0111\u01b0\u1ee3c Source \u0111\u1ec3 n\u1ea1p v\u00e0o trong List.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_vi_tri_cot\"><\/span>X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c thay \u0111\u1ed5i t\u00ean chi nh\u00e1nh s\u1ebd gi\u00fap ch\u00fang ta x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ed9t c\u1ea7n tham chi\u1ebfu: D\u00f9ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-match.html\">h\u00e0m Match<\/a> \u0111\u1ec3 tra c\u1ee9u t\u00ean chi nh\u00e1nh \u0111\u01b0\u1ee3c ch\u1ecdn trong danh s\u00e1ch chi nh\u00e1nh. K\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 c\u1ed9t t\u00ednh t\u1eeb v\u1ecb tr\u00ed b\u1eaft\u00a0c\u1ee7a v\u00f9ng lookup_array c\u1ee7a h\u00e0m Match<\/p>\n<p>=MATCH(G2,A1:D1,0)<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>G2: T\u00ean chi nh\u00e1nh \u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li>A1:D1: V\u00f9ng danh s\u00e1ch chi nh\u00e1nh<\/li>\n<li>0: Ph\u01b0\u01a1ng th\u1ee9c tham chi\u1ebfu l\u00e0 ch\u00ednh x\u00e1c theo t\u00ean chi nh\u00e1nh<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 t\u1ea1i G2 ch\u1ecdn Chi nh\u00e1nh 02 th\u00ec ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 2<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/kq03-ham-match-xac-dinh-so-cot.png\" width=\"1254\" height=\"280\" title=\"kq03-ham-match-xac-dinh-so-cot\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_toa_do_diem_dau_vung_danh_sach\"><\/span>X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m \u0111\u1ea7u v\u00f9ng danh s\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u1ef1a v\u00e0o b\u1ea3ng danh s\u00e1ch, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y danh s\u00e1ch c\u00e1c chi nh\u00e1nh \u0111\u1ec1u b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng 2. Do \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u c\u1ee7a danh s\u00e1ch b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-lay-dia-chi-cua-o-tinh-trong-excel.html\">h\u00e0m ADDRESS<\/a>.<\/p>\n<p>H\u00e0m Address gi\u00fap x\u00e1c \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 c\u1ee7a 1 \u00f4 b\u1eb1ng c\u00e1ch ch\u1ec9 ra s\u1ed1 d\u00f2ng, s\u1ed1 c\u1ed9t.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3:<\/p>\n<ul>\n<li>S\u1ed1 d\u00f2ng = 2<\/li>\n<li>S\u1ed1 c\u1ed9t = k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Match \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u1edf tr\u00ean (\u00f4 I7)<\/li>\n<\/ul>\n<p style=\"padding-left: 30px\">I8=ADDRESS(2,I7)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xac_dinh_toa_do_diem_cuoi_vung_danh_sach\"><\/span>X\u00e1c \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m cu\u1ed1i v\u00f9ng danh s\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 v\u1ec1 b\u1ea3ng danh s\u00e1ch \u1edf tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y t\u1ed1i \u0111a t\u1edbi d\u00f2ng th\u1ee9 11. N\u1ebfu coi \u0111i\u1ec3m cu\u1ed1i l\u00e0 d\u00f2ng 11 th\u00ec ta c\u00f3 \u00f4 cu\u1ed1i l\u00e0<\/p>\n<p style=\"padding-left: 30px\">I9=ADDRESS(11,I7)<\/p>\n<p>Tuy nhi\u00ean \u0111\u1ec3 gi\u00fap danh s\u00e1ch thay \u0111\u1ed5i linh \u0111\u1ed9ng t\u00f9y theo s\u1ed1 nh\u00e2n vi\u00ean trong m\u1ed7i danh s\u00e1ch th\u00ec ch\u00fang ta s\u1ebd\u00a0c\u1ea7n t\u00f9y bi\u1ebfn l\u1ea1i \u0111i\u1ec3m cu\u1ed1i n\u00e0y.<\/p>\n<p>Nh\u01b0 \u1edf tr\u00ean ch\u00fang ta \u0111\u00e3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m COUNTA \u0111\u1ec3 \u0111\u1ebfm trong v\u00f9ng t\u1eeb d\u00f2ng 2 t\u1edbi d\u00f2ng 11 trong m\u1ed7i danh s\u00e1ch \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 nh\u00e2n vi\u00ean trong m\u1ed7i danh s\u00e1ch. \u00c1p d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd \u0111\u1ebfm trong ph\u1ea1m vi I8:I9<\/p>\n<p>C\u00e1ch vi\u1ebft h\u00e0m nh\u01b0 sau:<\/p>\n<p>J9=COUNTA(INDIRECT(I8&amp;\u201d:\u201d&amp;I9))<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li><strong>I8<\/strong> l\u00e0 t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m \u0111\u1ea7u<\/li>\n<li><strong>I9<\/strong> l\u00e0 t\u1ecda \u0111\u1ed9 \u0111i\u1ec3m cu\u1ed1i (t\u00ednh to\u00e0n b\u1ed9 s\u1ed1 d\u00f2ng)<\/li>\n<li><strong>I8&amp;\u201d:\u201d&amp;I9<\/strong> l\u00e0 th\u1ec3 hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng v\u00f9ng t\u1eeb \u0111i\u1ec3m \u0111\u1ea7u t\u1edbi \u0111i\u1ec3m cu\u1ed1i<\/li>\n<li><strong>Indirect<\/strong> l\u00e0 h\u00e0m gi\u00fap x\u00e1c \u0111\u1ecbnh n\u1ed9i dung trong v\u00f9ng tr\u00ean<\/li>\n<li><strong>CountA<\/strong> \u0111\u1ec3 \u0111\u1ebfm to\u00e0n b\u1ed9 c\u00e1c n\u1ed9i dung trong v\u00f9ng t\u1ea1o b\u1edfi Indirect, k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 \u00f4 c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 (\u00f4 c\u00f3 n\u1ed9i dung)<\/li>\n<\/ul>\n<p>Khi \u0111\u00f3 \u0111i\u1ec3m cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong v\u00f9ng t\u1eeb d\u00f2ng 2 t\u1edbi d\u00f2ng 11 l\u00e0:<\/p>\n<p style=\"padding-left: 30px\">I10=ADDRESS(J9+1,I7)<\/p>\n<p>Gh\u00e9p l\u1ea1i \u0111i\u1ec3m \u0111\u1ea7u v\u00e0 \u0111i\u1ec3m cu\u1ed1i \u0111\u1ec3 t\u1ea1o th\u00e0nh 1 v\u00f9ng d\u1eef li\u1ec7u th\u00ec ch\u00fang ta d\u00f9ng:<\/p>\n<p style=\"padding-left: 30px\">I11=I8&amp;\u201d:\u201d&amp;I10<\/p>\n<p>\u0110\u1ec3 cho ch\u1eafc ch\u1eafn ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam t\u00ean Sheet n\u01a1i ch\u1ee9a b\u1ea3ng danh s\u00e1ch chi nh\u00e1nh (v\u00ed d\u1ee5 sheet DeBai):<\/p>\n<p style=\"padding-left: 30px\">I11=\u201dDeBai!\u201d&amp;I8&amp;\u201d:\u201d&amp;I10<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_nhan_vien\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i \u00f4 G3 ch\u00fang ta s\u1eed d\u1ee5ng Data Validation nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21245\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/kq03-data-validation-danh-sach-nhan-vien.png\" width=\"1258\" height=\"433\" title=\"kq03-data-validation-danh-sach-nhan-vien\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7n t\u1ea1o danh s\u00e1ch ch\u1ecdn nh\u00e2n vi\u00ean ph\u1ee5 thu\u1ed9c v\u00e0o t\u00ean chi nh\u00e1nh \u0111\u01b0\u1ee3c ch\u1ecdn. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>\u0110\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu trong b\u00e0i vi\u1ebft n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 theo \u0111\u1ecba ch\u1ec9: <a href=\"http:\/\/bit.ly\/2nKY8h7\">http:\/\/bit.ly\/2nKY8h7<\/a><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau trong Excel b\u1eb1ng VBA<\/a><\/p>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng linh ho\u1ea1t c\u00e1c h\u00e0m v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 trong Excel t\u1ea1o ra hi\u1ec7u qu\u1ea3 r\u1ea5t tuy\u1ec7t v\u1eddi ph\u1ea3i kh\u00f4ng n\u00e0o. N\u1ebfu b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel th\u00ec h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2vLfy1e\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a> c\u1ee7a H\u1ecdc Excel Online. Kh\u00f3a h\u1ecdc n\u00e0y gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m, t\u1eeb h\u00e0m c\u01a1 b\u1ea3n t\u1edbi h\u00e0m n\u00e2ng cao, hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel nh\u01b0 Conditional formatting, Data Validation, Filter, Pivot Table\u2026 Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y \u0111\u1ec1u r\u1ea5t c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y tr\u00ean Excel.<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i n\u00e0y nh\u00e9. 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<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-138.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10160","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\/10160","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=10160"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10161"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}