{"id":4637,"date":"2024-12-08T05:33:00","date_gmt":"2024-12-08T05:33:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba\/"},"modified":"2024-12-08T05:33:00","modified_gmt":"2024-12-08T05:33:00","slug":"huong-dan-cach-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau trong Excel b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>B\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o khi mu\u1ed1n tr\u00ecnh b\u00e0y c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng theo 1 danh s\u00e1ch trong Excel? C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, m\u1ed9t trong nh\u1eefng c\u00e1ch th\u01b0\u1eddng g\u1eb7p nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Data Validation\/ List.\u00a0Nh\u01b0ng v\u1edbi y\u00eau c\u1ea7u n\u00e2ng cao h\u01a1n l\u00e0 t\u1ea1o danh s\u00e1ch ph\u1ee5 thu\u1ed9c l\u1eabn nhau th\u00ec\u00a0th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch t\u1ea1o danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau trong Excel b\u1eb1ng VBA nh\u00e9.<\/p>\n<p>\u0110\u1ec3 l\u00e0m r\u00f5 n\u1ed9i dung n\u00e0y, ch\u00fang ta c\u00f9ng tham kh\u1ea3o v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20762\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/de-bai-tao-danh-sach-phu-thuoc-tinh-huyen.png\" width=\"952\" height=\"344\" title=\"de-bai-tao-danh-sach-phu-thuoc-tinh-huyen\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta c\u00f3 2 danh s\u00e1ch: Danh s\u00e1ch t\u1ec9nh\/ th\u00e0nh ph\u1ed1 c\u1ee7a Vi\u1ec7t Nam. T\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed7i t\u1ec9nh \/ th\u00e0nh ph\u1ed1 l\u00e0 c\u00e1c Qu\u1eadn \/ huy\u1ec7n. Y\u00eau c\u1ea7u l\u00e0 ch\u00fang ta c\u1ea7n t\u1ea1o ra danh s\u00e1ch ch\u1ecdn T\u1ec9nh \/ TP v\u00e0o v\u1ecb tr\u00ed \u00f4 F1, trong danh s\u00e1ch n\u00e0y t\u00ean c\u00e1c t\u1ec9nh\/ TP ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n. T\u1ea1i \u00f4 F2 t\u1ea1o danh s\u00e1ch ch\u1ecdn t\u00ean c\u00e1c Qu\u1eadn \/ Huy\u1ec7n ph\u1ee5 thu\u1ed9c theo t\u1ec9nh \/ TP \u0111\u01b0\u1ee3c ch\u1ecdn t\u1ea1i \u00f4 F1.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<p>Sau \u0111\u00e2y ch\u00fang ta s\u1ebd l\u1ea7n l\u01b0\u1ee3t \u0111i gi\u1ea3i quy\u1ebft c\u1ee5 th\u1ec3 t\u1eebng tr\u01b0\u1eddng h\u1ee3p.<\/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-67552f8b9bb07\" 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-phu-thuoc-nhau-trong-excel-bang-vba.html#Tao_danh_sach_chon_gia_tri_khong_trung\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\">T\u1ea1o danh s\u00e1ch ch\u1ecdn gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/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-phu-thuoc-nhau-trong-excel-bang-vba.html#Tao_danh_sach_chon_phu_thuoc\" title=\"T\u1ea1o danh s\u00e1ch ch\u1ecdn ph\u1ee5 thu\u1ed9c\">T\u1ea1o danh s\u00e1ch ch\u1ecdn ph\u1ee5 thu\u1ed9c<\/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-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba.html#Buoc_1_Tao_ra_danh_sach_cac_Quan_Huyen_phu_thuoc_theo_gia_tri_chon_o_o_F1\" title=\"B\u01b0\u1edbc 1: T\u1ea1o ra danh s\u00e1ch c\u00e1c Qu\u1eadn\/ Huy\u1ec7n ph\u1ee5 thu\u1ed9c theo gi\u00e1 tr\u1ecb ch\u1ecdn \u1edf \u00f4 F1\">B\u01b0\u1edbc 1: T\u1ea1o ra danh s\u00e1ch c\u00e1c Qu\u1eadn\/ Huy\u1ec7n ph\u1ee5 thu\u1ed9c theo gi\u00e1 tr\u1ecb ch\u1ecdn \u1edf \u00f4 F1<\/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-tao-danh-sach-phu-thuoc-nhau-trong-excel-bang-vba.html#Buoc_2_Tao_danh_sach_chon_tai_o_F2\" title=\"B\u01b0\u1edbc 2: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 F2\">B\u01b0\u1edbc 2: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 F2<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_gia_tri_khong_trung\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra 1 danh s\u00e1ch ch\u1ecdn c\u00e1c t\u1ec9nh\/TP kh\u00f4ng tr\u00f9ng nhau t\u1ea1i \u00f4 F1, ch\u00fang ta c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u1ec7c sau:<\/p>\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-158.gif\" title=\"vba101_92019-nho-158\"><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-375.gif\" title=\"ex101_92019-nho-375\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>L\u1ecdc c\u00e1c n\u1ed9i dung kh\u00f4ng tr\u00f9ng (ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n) t\u1ea1i c\u1ed9t A. \u0110\u01b0a k\u1ebft qu\u1ea3 l\u1ecdc \u0111\u01b0\u1ee3c ra c\u1ed9t C<\/li>\n<li>T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 F1 b\u1eb1ng Data Validation<\/li>\n<\/ul>\n<p><strong>V\u1ec1 vi\u1ec7c l\u1ecdc gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng t\u1eeb 1 danh s\u00e1ch<\/strong>, ch\u00fang ta c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch l\u00e0m: S\u1eed d\u1ee5ng Advanced Filter, S\u1eed d\u1ee5ng\u00a0Remove Duplicates<\/p>\n<p>Tham kh\u1ea3o: <a href=\"http:\/\/blog.ezworkapp.com\/tu-dong-loc-danh-sach-khong-trung-voi-advanced-filter-vba-cuc-ky-don-gian.html\">T\u1ef1 \u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u1edbi Advanced Filter VBA c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n<\/a><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng Advanced Filter trong VBA \u0111\u1ec3 l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u1edbi c\u1ed9t A. N\u1ebfu b\u1ea1n ch\u01b0a r\u00f5 c\u00e1ch l\u00e0m th\u00ec c\u00f3 th\u1ec3 tham kh\u1ea3o \u1edf link b\u00e0i vi\u1ebft ph\u00eda tr\u00ean. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20765\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/code-loc-danh-sach-ko-trung-advanced-filter.png\" width=\"1513\" height=\"294\" title=\"code-loc-danh-sach-ko-trung-advanced-filter\"><\/p>\n<p>T\u1ea1i c\u1ed9t A: \u00e1p d\u1ee5ng Advanced Filter t\u1eeb A1 t\u1edbi A1000 (gi\u1ea3 \u0111\u1ecbnh t\u1edbi 1000 d\u00f2ng d\u1eef li\u1ec7u)\u00a0trong sheet1 (l\u00e0 sheet \u0111ang l\u00e0m vi\u1ec7c)<\/p>\n<ul>\n<li><strong>Action<\/strong>: Th\u1ef1c hi\u1ec7n\u00a0h\u00e0nh \u0111\u1ed9ng\u00a0copy k\u1ebft qu\u1ea3 ra v\u1ecb tr\u00ed kh\u00e1c<\/li>\n<li><strong>CopyToRange<\/strong>: V\u1ecb tr\u00ed l\u1ea5y k\u1ebft qu\u1ea3 l\u00e0 \u00f4 C1 trong sheet1 (l\u00e0 sheet \u0111ang l\u00e0m vi\u1ec7c)<\/li>\n<li><strong>Unique<\/strong>: \u0111\u1ec3 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng, ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n th\u00ec ch\u1ecdn l\u00e0 True<\/li>\n<\/ul>\n<p>Khi ch\u1ea1y c\u00e2u l\u1ec7nh n\u00e0y, ch\u00fang ta thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 danh s\u00e1ch T\u1ec9nh\/TP nh\u01b0 \u1edf c\u1ed9t C<\/p>\n<p><strong>\u0110\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn cho \u00f4 F1<\/strong>, 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-20768\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-danh-sach-chon-theo-tinh.png\" width=\"800\" height=\"499\" title=\"tao-danh-sach-chon-theo-tinh\"><\/p>\n<p>T\u1ea1i \u00f4 F1 ch\u1ecdn th\u1ebb <strong>Data<\/strong> =&gt; Ch\u1ecdn ch\u1ee9c n\u0103ng <strong>Data Validation<\/strong>. Trong c\u1eeda s\u1ed5 Data Validation th\u1ef1c hi\u1ec7n ti\u1ebfp c\u00e1c n\u1ed9i dung:<\/p>\n<ul>\n<li><strong>Allow<\/strong>: ch\u1ecdn <strong>List<\/strong> \u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn<\/li>\n<li><strong>Source<\/strong>: Ngu\u1ed3n cho danh s\u00e1ch. Ngu\u1ed3n n\u00e0y s\u1ebd c\u0103n c\u1ee9 v\u00e0o n\u1ed9i dung \u1edf c\u1ed9t C. Do \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m OFFSET, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed C2, k\u1ebft th\u00fac l\u00e0 v\u1ecb tr\u00ed\u00a0t\u00ednh t\u1eeb C2 t\u1edbi t\u1ed5ng s\u1ed1 \u0111\u1ed1i t\u01b0\u1ee3ng trong v\u00f9ng C2:C1000. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">COUNTA(C2:C1000) = 63 t\u01b0\u01a1ng \u1ee9ng v\u1edbi 63 t\u1ec9nh th\u00e0nh ph\u1ed1<\/p>\n<p style=\"padding-left: 60px\">OFFSET(C2,0,0,63) = v\u00f9ng C2:C64<\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch t\u1ea1o 1 danh s\u00e1ch \u0111\u1ed9ng, trong \u0111\u00f3 \u0111\u1ed9 r\u1ed9ng c\u1ee7a danh s\u00e1ch c\u00f3 th\u1ec3 thay \u0111\u1ed5i t\u00f9y theo s\u1ed1 \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 trong danh s\u00e1ch \u0111\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_danh_sach_chon_phu_thuoc\"><\/span>T\u1ea1o danh s\u00e1ch ch\u1ecdn ph\u1ee5 thu\u1ed9c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7c t\u1ea1o danh s\u00e1ch ch\u1ecdn cho T\u1ec9nh\/TP t\u1ea1i \u00f4 F1, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn 1 t\u1ec9nh\/TP b\u1ea5t k\u1ef3.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 c\u00f3 danh s\u00e1ch ph\u1ee5 thu\u1ed9c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u1ecdn t\u1ea1i F1, ch\u00fang ta c\u00f3 th\u1ec3 h\u00ecnh dung c\u00e1c c\u00f4ng vi\u1ec7c ph\u1ea3i l\u00e0m l\u00e0:<\/p>\n<ul>\n<li>T\u1ea1i c\u1ed9t D s\u1ebd t\u1ea1o ra danh s\u00e1ch c\u00e1c Qu\u1eadn\/ Huy\u1ec7n ph\u1ee5 thu\u1ed9c theo gi\u00e1 tr\u1ecb ch\u1ecdn \u1edf \u00f4 F1.<\/li>\n<li>T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 F2 theo danh s\u00e1ch trong c\u1ed9t D<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Tao_ra_danh_sach_cac_Quan_Huyen_phu_thuoc_theo_gia_tri_chon_o_o_F1\"><\/span>B\u01b0\u1edbc 1: T\u1ea1o ra danh s\u00e1ch c\u00e1c Qu\u1eadn\/ Huy\u1ec7n ph\u1ee5 thu\u1ed9c theo gi\u00e1 tr\u1ecb ch\u1ecdn \u1edf \u00f4 F1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1edfi m\u1ed7i khi ch\u1ecdn gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 F1 th\u00ec danh s\u00e1ch c\u00f3 th\u1ec3 thay \u0111\u1ed5i, do \u0111\u00f3 vi\u1ec7c \u0111\u1ea7u ti\u00ean c\u1ea7n l\u00e0m l\u00e0 l\u00e0m m\u1edbi l\u1ea1i n\u1ed9i dung trong c\u1ed9t D, x\u00f3a c\u00e1c n\u1ed9i dung tr\u01b0\u1edbc \u0111\u00f3 trong danh s\u00e1ch.<\/p>\n<p>Ti\u1ebfp \u0111\u00f3 th\u1ef1c hi\u1ec7n v\u00f2ng l\u1eb7p \u0111\u1ec3 x\u00e9t t\u1eebng gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t A v\u1edbi gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 F1. N\u1ebfu v\u1ecb tr\u00ed n\u00e0o gi\u1ed1ng nhau th\u00ec s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t B l\u1ea5y sang c\u1ed9t D.\u00a0K\u1ebft qu\u1ea3 \u0111\u01b0a sang c\u1ed9t D s\u1ebd theo d\u00f2ng cu\u1ed1i c\u00f3 d\u1eef li\u1ec7u trong c\u1ed9t n\u00e0y.<\/p>\n<p>N\u1ed9i dung c\u1ee5 th\u1ec3 c\u1ee7a c\u00e2u l\u1ec7nh VBA nh\u01b0 sau:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/c598a76bbd4f53442dfdea4294c7e4db\">Gist<\/a>.<\/div>\n<p>Do m\u1ed7i l\u1ea7n thay \u0111\u1ed5i gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 F1 s\u1ebd ch\u1ea1y l\u1ea1i c\u00e2u l\u1ec7nh tr\u00ean, n\u00ean ch\u00fang ta s\u1ebd g\u00e1n c\u00e2u l\u1ec7nh n\u00e0y trong s\u1ef1 ki\u1ec7n thay \u0111\u1ed5i gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 F1 c\u1ee7a worksheet nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">Private Sub Worksheet_Change(ByVal Target As Range)<\/p>\n<p style=\"padding-left: 60px\">If Not Application.Intersect(Range(\u201cF1\u201d), Range(Target.Address)) Is Nothing Then<\/p>\n<p style=\"padding-left: 90px\">Call Ma_Huyen_GetData<\/p>\n<p style=\"padding-left: 60px\">End If<\/p>\n<p style=\"padding-left: 30px\">End Sub<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-y-nghia-va-cach-dung-cac-su-kien-trong-vba-excel.html\">T\u00ecm hi\u1ec3u v\u1ec1 \u00fd ngh\u0129a v\u00e0 c\u00e1ch d\u00f9ng c\u00e1c s\u1ef1 ki\u1ec7n trong VBA Excel<\/a><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20770\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba-loc-danh-sach-phu-thuoc.gif\" width=\"774\" height=\"371\" title=\"vba-loc-danh-sach-phu-thuoc\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Tao_danh_sach_chon_tai_o_F2\"><\/span>B\u01b0\u1edbc 2: T\u1ea1o danh s\u00e1ch ch\u1ecdn t\u1ea1i \u00f4 F2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i \u00f4 F2 ch\u1ecdn th\u1ebb\u00a0<strong>Data<\/strong>\u00a0=&gt; Ch\u1ecdn ch\u1ee9c n\u0103ng\u00a0<strong>Data Validation<\/strong>. Trong c\u1eeda s\u1ed5 Data Validation th\u1ef1c hi\u1ec7n ti\u1ebfp c\u00e1c n\u1ed9i dung:<\/p>\n<ul>\n<li><strong>Allow<\/strong>: ch\u1ecdn\u00a0<strong>List<\/strong>\u00a0\u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn<\/li>\n<li><strong>Source<\/strong>: Ngu\u1ed3n cho danh s\u00e1ch. Ngu\u1ed3n n\u00e0y s\u1ebd c\u0103n c\u1ee9 v\u00e0o n\u1ed9i dung \u1edf c\u1ed9t D. Do \u0111\u00f3 s\u1eed d\u1ee5ng h\u00e0m OFFSET, b\u1eaft \u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed D2, k\u1ebft th\u00fac l\u00e0 v\u1ecb tr\u00ed\u00a0t\u00ednh t\u1eeb D2 t\u1edbi t\u1ed5ng s\u1ed1 \u0111\u1ed1i t\u01b0\u1ee3ng trong v\u00f9ng D2:D1000. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta c\u00f3:<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\">COUNTA(D2:D1000) =\u00a0t\u1ed5ng s\u1ed1 qu\u1eadn\/huy\u1ec7n l\u1ea5y \u0111\u01b0\u1ee3c t\u1eeb c\u00e2u l\u1ec7nh VBA \u1edf tr\u00ean<\/p>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20771\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-tao-danh-sach-phu-thuoc.png\" width=\"769\" height=\"256\" title=\"ket-qua-tao-danh-sach-phu-thuoc\"><\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 c\u00e1ch kh\u00e1c nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau.html\">C\u00e1ch t\u1ea1o Combobox c\u00f3 danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-mot-danh-sach-tuy-chon-trong-excel.html\">T\u1ea1o m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-danh-sach-tinh-huyen-xa-phu-thuoc-nhau.html\">C\u00e1ch t\u1ea1o danh s\u00e1ch t\u1ec9nh huy\u1ec7n x\u00e3 ph\u1ee5 thu\u1ed9c nhau<\/a><\/p>\n<p>B\u1ea1n c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n khi \u00e1p d\u1ee5ng VBA v\u00e0o trong c\u00f4ng vi\u1ec7c tr\u00ean Excel kh\u00f4ng? VBA th\u1ef1c s\u1ef1 l\u00e0 m\u1ed9t ki\u1ebfn th\u1ee9c n\u00e2ng cao trong Excel, kh\u00f3 h\u1ecdc, nh\u01b0ng n\u00f3 l\u1ea1i gi\u00fap \u00edch r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c. H\u00e3y tham gia ngay kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2v5t9A8\">VBA101 \u2013 L\u1eadp tr\u00ecnh VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a> c\u00f9ng H\u1ecdc Excel Online. Kh\u00f3a h\u1ecdc n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebfp c\u1eadn c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 VBA trong Excel m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u nh\u1ea5t, c\u00f3 h\u1ec7 th\u1ed1ng gi\u00fap b\u1ea1n n\u1eafm b\u1eaft ki\u1ebfn th\u1ee9c n\u00e0y m\u1ed9t c\u00e1ch nhanh nh\u1ea5t. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i r\u1ea5t h\u1ea5p d\u1eabn khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. 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\/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-158.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4637","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\/4637","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=4637"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4638"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}