{"id":3627,"date":"2024-12-03T03:13:22","date_gmt":"2024-12-03T03:13:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc\/"},"modified":"2024-12-03T03:13:22","modified_gmt":"2024-12-03T03:13:22","slug":"cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc\/","title":{"rendered":"C\u00e1ch t\u1ea1o \u00f4 l\u1ecdc d\u1eef li\u1ec7u v\u1eeba g\u00f5 ch\u1eef v\u1eeba hi\u1ec7n k\u1ebft qu\u1ea3 l\u1ecdc"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch<a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc.html\"><strong> t\u1ea1o \u00f4 l\u1ecdc d\u1eef li\u1ec7u<\/strong><\/a> gi\u00fap ch\u00fang ta v\u1eeba g\u00f5 ch\u1eef, v\u1eeba c\u00f3 th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 l\u1ecdc theo th\u1eddi gian th\u1ef1c.<\/p>\n<figure id=\"attachment_31621\" aria-describedby=\"caption-attachment-31621\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/type-to-filter-demo.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31621\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/type-to-filter-demo.gif\" alt=\"Demo \u00f4 l\u1ecdc d\u1eef li\u1ec7u v\u1eeba g\u00f5 v\u1eeba l\u1ecdc\" width=\"500\" height=\"250\" title=\"type-to-filter-demo\"><\/a><figcaption id=\"caption-attachment-31621\" class=\"wp-caption-text\">\u00d4 l\u1ecdc d\u1eef li\u1ec7u theo th\u1eddi gian th\u1ef1c<\/figcaption><\/figure>\n<p>Ch\u00fang ta s\u1ebd c\u00f3 nhi\u1ec1u h\u01a1n 1 c\u00e1ch \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 demo tr\u00ean:<\/p>\n<ul style=\"list-style-type: square\">\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER<\/a><\/li>\n<li>C\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng table k\u1ebft h\u1ee3p v\u1edbi code VBA<\/li>\n<\/ul>\n<p>V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER, b\u1ea1n c\u1ea7n ph\u1ea3i c\u00f3 phi\u00ean b\u1ea3n Excel 365. V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng table k\u1ebft h\u1ee3p v\u1edbi code VBA, th\u00ec b\u1ea1n kh\u00f4ng c\u1ea7n c\u00f3 phi\u00ean b\u1ea3n Excel 365.<\/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-674e7751ccada\" 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\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc.html#Cach_tao_chuc_nang_loc_du_lieu_su_dung_ham_FILTER_trong_Excel_365\" title=\"C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel 365\">C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel 365<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc.html#Cach_thiet_lap_Textbox\" title=\"C\u00e1ch thi\u1ebft l\u1eadp Textbox\">C\u00e1ch thi\u1ebft l\u1eadp Textbox<\/a><\/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\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc.html#Cach_thiet_lap_vung_chua_ket_qua_loc\" title=\"C\u00e1ch thi\u1ebft l\u1eadp v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 l\u1ecdc\">C\u00e1ch thi\u1ebft l\u1eadp v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 l\u1ecdc<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-o-loc-du-lieu-vua-go-chu-vua-hien-ket-qua-loc.html#Cach_tao_chuc_nang_loc_du_lieu_su_dung_Table_va_lap_trinh_VBA\" title=\"C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Table v\u00e0 l\u1eadp tr\u00ecnh VBA\">C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Table v\u00e0 l\u1eadp tr\u00ecnh VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_chuc_nang_loc_du_lieu_su_dung_ham_FILTER_trong_Excel_365\"><\/span><span style=\"font-size: 14pt\">C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel 365<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong ph\u1ea7n n\u00e0y, ch\u00fang ta s\u1ebd l\u1ea7n l\u01b0\u1ee3t \u0111i l\u00e0m nh\u1eefng vi\u1ec7c sau \u0111\u00e2y: thi\u1ebft l\u1eadp Textbox \u0111\u1ec3 g\u00f5 n\u1ed9i dung c\u1ea7n l\u1ecdc, thi\u1ebft l\u1eadp v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u l\u1ecdc, thi\u1ebft l\u1eadp h\u00e0m FILTER cho vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_Textbox\"><\/span><span style=\"font-size: 12pt\">C\u00e1ch thi\u1ebft l\u1eadp Textbox<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp \u0111\u01b0\u1ee3c Textbox trong Excel, ch\u00fang ta c\u1ea7n ph\u1ea3i m\u1edf th\u1ebb Developer l\u00ean. \u0110\u1ec3 m\u1edf th\u1ebb developer, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch m\u1edf th\u1ebb Developer<\/a><\/p>\n<p>Sau khi \u0111\u00e3 m\u1edf \u0111\u01b0\u1ee3c th\u1ebb Developer, c\u00e1ch thi\u1ebft l\u1eadp Textbox nh\u01b0 sau: b\u1ea5m v\u00e0o th\u1ebb\u00a0<strong>Developer\u00a0<\/strong>&gt; trong nh\u00f3m l\u1ec7nh\u00a0<strong>Controls\u00a0<\/strong>&gt; b\u1ea5m n\u00fat\u00a0<strong>Insert\u00a0<\/strong>&gt; trong khu v\u1ef1c\u00a0<strong>ActiveX Controls\u00a0<\/strong>&gt; b\u1ea5m\u00a0<strong>Textbox (ActiveX Control)<\/strong><\/p>\n<figure id=\"attachment_31623\" aria-describedby=\"caption-attachment-31623\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/tao-textbox-trong-excel-500x350-1.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31623\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-textbox-trong-excel-500x350-1.gif\" alt=\"T\u1ea1o textbox activex control\" width=\"500\" height=\"350\" title=\"tao-textbox-trong-excel-500x350-1\"><\/a><figcaption id=\"caption-attachment-31623\" class=\"wp-caption-text\">T\u1ea1o textbox activex control<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc ti\u1ebfp theo, ch\u00fang ta s\u1ebd \u0111i k\u1ebft n\u1ed1i Texbox n\u00e0y v\u1edbi 1 \u00f4 tr\u00ean b\u1ea3ng t\u00ednh Excel, gi\u1ea3 s\u1eed ch\u00fang ta s\u1ebd k\u1ebft n\u1ed1i t\u1edbi \u00f4 F1 th\u00ec thao t\u00e1c s\u1ebd nh\u01b0 sau<\/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-280.gif\" title=\"ex101_92019-nho-280\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u1ecdn Textbox khi Design Mode v\u1eabn \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn, b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0<em>Properties,\u00a0<\/em>trong c\u1eeda s\u1ed5\u00a0<em>Properties,\u00a0<\/em>ch\u1ecdn thu\u1ed9c t\u00ednh\u00a0<em>LinkedCell\u00a0<\/em>v\u00e0 g\u00f5 v\u00e0o \u00f4 mu\u1ed1n k\u1ebft n\u1ed1i t\u1edbi l\u00e0 \u00f4 F1. B\u1ea5m chu\u1ed9t ra ngo\u00e0i Textbox, sau \u0111\u00f3 b\u1ecf k\u00edch ho\u1ea1t\u00a0<em>Design Mode,\u00a0<\/em>k\u00edch ch\u1ecdn v\u00e0o b\u00ean trong c\u1ee7a Textbox 1 l\u1ea7n n\u1eefa v\u00e0 th\u1eed nh\u1eadp d\u1eef li\u1ec7u \u0111\u1ec3 ki\u1ec3m tra k\u1ebft n\u1ed1i gi\u1eefa Textbox v\u00e0 \u00f4 c\u1ea7n k\u1ebft n\u1ed1i (F1). N\u1ebfu ch\u01b0a r\u00f5, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i \u1ea3nh \u0111\u1ed9ng sau \u0111\u00e2y<\/p>\n<figure id=\"attachment_31624\" aria-describedby=\"caption-attachment-31624\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/ket-noi-textbox-va-o-tren-excel.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31624\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-noi-textbox-va-o-tren-excel.gif\" alt=\"K\u1ebft n\u1ed1i Textbox v\u00e0 v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh\" width=\"500\" height=\"400\" title=\"ket-noi-textbox-va-o-tren-excel\"><\/a><figcaption id=\"caption-attachment-31624\" class=\"wp-caption-text\">K\u1ebft n\u1ed1i Textbox v\u00e0 v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_vung_chua_ket_qua_loc\"><\/span><span style=\"font-size: 12pt\">C\u00e1ch thi\u1ebft l\u1eadp v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 l\u1ecdc<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi thi\u1ebft l\u1eadp v\u00e0 k\u1ebft n\u1ed1i xong v\u1edbi Textbox, ch\u00fang ta s\u1ebd \u0111i chu\u1ea9n b\u1ecb v\u00f9ng ch\u1ee9a k\u1ebft qu\u1ea3 l\u1ecdc v\u00e0 so\u1ea1n c\u00f4ng th\u1ee9c cho v\u00f9ng n\u00e0y nh\u01b0 sau:<\/p>\n<figure id=\"attachment_31625\" aria-describedby=\"caption-attachment-31625\" style=\"width: 1858px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cach-su-dung-ham-filter-de-loc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31625\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-ham-filter-de-loc.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u\" width=\"1858\" height=\"462\" title=\"cach-su-dung-ham-filter-de-loc\"><\/a><figcaption id=\"caption-attachment-31625\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c FILTER trong phi\u00ean b\u1ea3n Excel 365 nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=FILTER(A9:D1008,ISNUMBER(SEARCH(F1,D9:D1008)),\"Not found\")<\/code><\/p>\n<p>Khi ch\u00fang ta thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c FILTER nh\u01b0 tr\u00ean, c\u1ed9t \u0111\u01b0\u1ee3c FILTER s\u1ebd l\u00e0 c\u1ed9t D ch\u1ee9a email.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n l\u1ecdc v\u00e0 t\u00ecm ki\u1ebfm email b\u1eaft \u0111\u1ea7u b\u1eb1ng chu\u1ed7i ch\u00fang ta g\u00f5 v\u00e0o Textbox, th\u00ec ch\u00fang ta c\u1ea7n s\u1eeda l\u1ea1i c\u00f4ng th\u1ee9c nh\u01b0 sau<\/p>\n<p><code class=\"excel-formula\">=FILTER(A9:D1008,LEFT(D9:D1008,LEN(F1))=F1,\"Not found\")<\/code><\/p>\n<p>Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u ngay l\u1eadp t\u1ee9c khi g\u00f5 v\u00e0o Textbox. C\u00e1ch n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng cho nh\u1eefng b\u1ea1n n\u00e0o c\u00f3 s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Excel 365 c\u1ee7a Microsoft. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng Office 365 th\u00ec c\u00e1ch sau \u0111\u00e2y s\u1eed d\u1ee5ng VBA k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng Table trong Excel c\u0169ng s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tao_chuc_nang_loc_du_lieu_su_dung_Table_va_lap_trinh_VBA\"><\/span><span style=\"font-size: 14pt\">C\u00e1ch t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Table v\u00e0 l\u1eadp tr\u00ecnh VBA<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng Table v\u00e0 code VBA \u0111\u1ec3 t\u1ea1o ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u si\u00eau t\u1ed1c, b\u1ea1n s\u1ebd v\u1eabn thi\u1ebft l\u1eadp Textbox v\u00e0 k\u1ebft n\u1ed1i v\u1edbi \u00f4 F1 nh\u01b0 b\u00ecnh th\u01b0\u1eddng. Sau \u0111\u00f3, b\u1ea1n c\u1ea7n \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng b\u1eb1ng c\u00e1ch:<\/p>\n<ul style=\"list-style-type: square\">\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 (A8:D1008 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y)<\/li>\n<li>B\u1ea5m ph\u00edm t\u1eaft CTRL + T \u0111\u1ec3 t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u, nh\u1edb ch\u1ecdn \u1edf m\u1ee5c\u00a0<em>My table has headers\u00a0<\/em>r\u1ed3i b\u1ea5m OK\n<p><figure id=\"attachment_31627\" aria-describedby=\"caption-attachment-31627\" style=\"width: 228px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cach-tao-bang-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31627\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-bang-trong-excel.png\" alt=\"C\u00e1ch t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u trong Excel\" width=\"228\" height=\"152\" title=\"cach-tao-bang-trong-excel\"><\/a><figcaption id=\"caption-attachment-31627\" class=\"wp-caption-text\">C\u00e1ch t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u trong Excel<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<\/ul>\n<p>Sau \u0111\u00f3, trong th\u1ebb <em>Table Design\u00a0<\/em>(Th\u1ebb n\u00e0y ch\u1ec9 xu\u1ea5t hi\u1ec7n khi b\u1ea1n \u0111ang ch\u1ecdn b\u1ea3ng), m\u1ee5c\u00a0<em>Table name,\u00a0<\/em>ch\u00fang ta s\u1ebd \u0111\u1eb7t t\u00ean l\u1ea1i cho b\u1ea3ng l\u00e0\u00a0<strong>database\u00a0<\/strong>(t\u00ean c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn)<\/p>\n<p>B\u01b0\u1edbc ti\u1ebfp theo, ch\u00fang ta v\u00e0o l\u1ea1i th\u1ebb\u00a0<strong>Developer\u00a0<\/strong>r\u1ed3i b\u1ea5m v\u00e0o\u00a0<strong>Design Mode<\/strong>, r\u1ed3i nh\u00e1y \u0111\u00fap chu\u1ed9t v\u00e0o Textbox \u0111\u00e3 t\u1ea1o, trong c\u1eeda s\u1ed5 so\u1ea1n th\u1ea3o VBA, b\u1ea1n nh\u1eadp \u0111\u00fang \u0111o\u1ea1n code sau \u0111\u00e2y v\u00e0o<\/p>\n<p><code>Private Sub TextBox1_Change()<\/code><\/p>\n<p><code>Application.ScreenUpdating = False <\/code><\/p>\n<p><code>ActiveSheet.ListObjects(\"database\").Range.AutoFilter Field:=4, Criteria1:=\"*\" &amp; ActiveSheet.Range(\"F1\").Value &amp; \"*\" <\/code><\/p>\n<p><code>Application.ScreenUpdating = True<\/code><\/p>\n<p><code>End Sub<\/code><\/p>\n<p>Ch\u1eef \u201cdatabase\u201d trong ph\u1ea7n ListObjects(\u201cdatabase\u201d) l\u00e0 t\u00ean c\u1ee7a b\u1ea3ng b\u1ea1n \u0111\u1eb7t \u1edf b\u01b0\u1edbc tr\u01b0\u1edbc.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i phi\u00ean b\u1ea3n video c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y \u1edf \u0111\u00e2y:<\/p>\n<p>Link video: <a href=\"https:\/\/youtu.be\/0EuwGBPpw4c\" target=\"_blank\" rel=\"noopener noreferrer\">Xem video<\/a><\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/0EuwGBPpw4c\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>B\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i th\u00eam nh\u1eefng b\u00e0i vi\u1ebft v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter t\u1ea1i trang ch\u1ee7 c\u1ee7a <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online.\u00a0<\/a><\/strong><\/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-280.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3627","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\/3627","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=3627"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3628"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}