{"id":12648,"date":"2025-01-15T10:49:55","date_gmt":"2025-01-15T10:49:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel\/"},"modified":"2025-01-15T10:49:55","modified_gmt":"2025-01-15T10:49:55","slug":"tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel\/","title":{"rendered":"T\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u si\u00eau t\u1ed1c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>V\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, Blog <strong>ho\u0323c Excel Online <\/strong>se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n <strong>ca\u0301ch t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u si\u00eau t\u1ed1c<\/strong> ngay khi b\u1ea1n search\/\u0111\u00e1nh ch\u1eef v\u00e0o h\u1ed9p t\u00ecm ki\u1ebfm. Ngay sau khi g\u00f5 ch\u1eef v\u00e0o h\u1ed9p t\u00ecm ki\u1ebfm, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c.<\/em><\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/AL4uicmlNoQ?autoplay=1&amp;loop=1&amp;playlist=AL4uicmlNoQ&amp;modestbranding=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>B\u1ea1n c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u r\u1ea5t d\u00e0i? B\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 nh\u00ecn nh\u1ea5t? \u0110\u00e2y l\u00e0 video d\u00e0nh cho b\u1ea1n. K\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm hi\u1ec7n ra ngay khi b\u1ea1n g\u00f5 ch\u1eef v\u00e0o h\u1ed9p t\u00ecm ki\u1ebfm.<\/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-678792d16dbf1\" 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<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel.html#Code_VBA_trong_video\" title=\"Code VBA trong video:\">Code VBA trong video:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\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\/tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel.html#Tim_kiem_cot_luu_so\" title=\"T\u00ecm ki\u1ebfm c\u1ed9t l\u01b0u s\u1ed1\">T\u00ecm ki\u1ebfm c\u1ed9t l\u01b0u s\u1ed1<\/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\/tim-kiem-va-loc-du-lieu-sieu-toc-trong-excel.html#Download_tai_lieu_Excel_kem_theo_video\" title=\"Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video\">Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4 id=\"code-vba-trong-video\"><span class=\"ez-toc-section\" id=\"Code_VBA_trong_video\"><\/span>Code VBA trong video:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<figure class=\"highlight\">\n<pre><code class=\"language-php\" data-lang=\"php\">Private Sub TextBox1_Change()\r\n    ActiveSheet.ListObjects(\"bang\").Range.AutoFilter Field:=1, _\r\n        Criteria1:=\"*\" <span class=\"err\">&amp;<\/span> [b2] <span class=\"err\">&amp;<\/span> \"*\", Operator:=xlFilterValues\r\nEnd Sub<\/code><\/pre>\n<\/figure>\n<p>V\u1edbi \u0111o\u1ea1n code n\u00e0y, n\u1ebfu c\u1ed9t t\u00ecm ki\u1ebfm l\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean th\u00ec ta \u0111\u1ec3 Field:=1, n\u1ebfu l\u00e0 c\u1ed9t th\u1ee9 2 th\u00ec ta \u0111\u1ec3 Field:=2 \u2026<\/p>\n<p>B\u1ea3ng c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean t\u01b0\u01a1ng \u1ee9ng v\u1edbi chu\u1ed7i trong code: ActiveSheet.ListObjects(\u201cbang\u201d)<\/p>\n<p>thay \u201cbang\u201d b\u1eb1ng t\u00ean b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<h2 id=\"tm-kim-ct-lu-s\"><span class=\"ez-toc-section\" id=\"Tim_kiem_cot_luu_so\"><\/span>T\u00ecm ki\u1ebfm c\u1ed9t l\u01b0u s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c c\u1ed9t l\u01b0u s\u1ed1, VD: s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, s\u1ed1 t\u00e0i kho\u1ea3n. Ta nh\u1eadn th\u1ea5y c\u00e1c s\u1ed1 n\u00e0y \u0111\u1ec1u kh\u00f4ng d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u1eady n\u00ean, \u0111\u1ec3 \u00e1p d\u1ee5ng k\u0129 thu\u1eadt n\u00e0y cho vi\u1ec7c t\u00ecm s\u1ed1, ch\u00fang ta s\u1ebd chuy\u1ec3n s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c s\u1ed1 t\u00e0i kho\u1ea3n sang d\u1ea1ng <strong><code class=\"highlighter-rouge\">text<\/code><\/strong>.<\/p>\n<p>C\u00e1ch l\u00e0m b\u1eb1ng tay khi nh\u1eadp c\u00f4ng th\u1ee9c cho 1 \u00f4 c\u00f3 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i l\u00e0 <strong><code class=\"highlighter-rouge\">='09812345678<\/code><\/strong>. Ch\u00fa \u00fd d\u1ea5u <strong><code class=\"highlighter-rouge\">'<\/code><\/strong> sau d\u1ea5u <strong><code class=\"highlighter-rouge\">=<\/code><\/strong>.<\/p>\n<p>C\u00e1ch l\u00e0m b\u1edbt th\u1ee7 c\u00f4ng h\u01a1n l\u00e0 th\u00eam 1 c\u1ed9t ph\u1ee5 c\u00f3 n\u1ed9i dung l\u00e0 1 k\u00ed t\u1ef1 b\u1ea5t k\u00ec VD <strong><code class=\"highlighter-rouge\">n<\/code><\/strong> ch\u1eb3ng h\u1ea1n. N\u1ed1i c\u1ed9t ph\u1ee5 n\u00e0y v\u1edbi c\u1ed9t s\u1ed1 ra 1 c\u1ed9t m\u1edbi, sau \u0111\u00f3 d\u00f9ng c\u1ed9t m\u1edbi l\u00e0 c\u1ed9t \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u.<\/p>\n<p>K\u0129 thu\u1eadt s\u1eed d\u1ee5ng trong b\u00e0i n\u00e0y c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 \u00e1p d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm \u1edf nhi\u1ec1u h\u01a1n m\u1ed9t c\u1ed9t, ph\u1ea7n n\u00e0y s\u1ebd \u0111\u1ec3 d\u00e0nh l\u1ea1i cho c\u00e1c b\u1ea1n.<\/p>\n<h3 id=\"download-ti-liu-excel-km-theo-video\"><span class=\"ez-toc-section\" id=\"Download_tai_lieu_Excel_kem_theo_video\"><\/span>Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>[sociallocker id=457]<\/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\/2025\/01\/vba101_92019-nho-82.gif\" title=\"vba101_92019-nho-82\"><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\/2025\/01\/ex101_92019-nho-418.gif\" title=\"ex101_92019-nho-418\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/www.dropbox.com\/s\/shkm27f5c5asgta\/EXCEL%2064%20tim%20kiem%20va%20loc%20du%20lieu%20sieu%20toc.xlsm?dl=1\">Download Excel File<\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<p>\u2014\u2014\u2014<\/p>\n<p style=\"text-align: justify\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">ho\u0323c Excel c\u01a1 ba\u0309n<\/a>\u00a0cho \u0111\u00ea\u0301n n\u00e2ng cao v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u00ea\u0309u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u01b0\u0300ng tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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\/2025\/01\/vba101_92019-nho-82.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12649,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12648","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\/12648","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=12648"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12648\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12649"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}