{"id":2057,"date":"2024-12-02T06:55:25","date_gmt":"2024-12-02T06:55:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-dung-advanced-filter-de-loc-du-lieu-trung-trong-excel\/"},"modified":"2024-12-02T06:55:25","modified_gmt":"2024-12-02T06:55:25","slug":"su-dung-advanced-filter-de-loc-du-lieu-trung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/su-dung-advanced-filter-de-loc-du-lieu-trung-trong-excel\/","title":{"rendered":"S\u1eed d\u1ee5ng Advanced Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u trong Excel th\u00ec vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u trong c\u00e1c b\u1ea3ng l\u00e0 vi\u1ec7c l\u00e0m r\u1ea5t c\u1ea7n thi\u1ebft v\u00e0 hay \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n. Ch\u1ee9c n\u0103ng <strong>Advanced Filter<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng ch\u1ee9c n\u0103ng gi\u00fap c\u00e1c b\u1ea1n l\u1ecdc d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/em><\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u ki\u1ec7n \u0111\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c\u00a0n\u0103ng <strong>Advanced Filter<\/strong>:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ti\u00eau \u0111\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ed9t d\u00f2ng duy nh\u1ea5t.<\/li>\n<li>Trong b\u1ea3ng, kh\u00f4ng \u0111\u01b0\u1ee3c <strong>merge<\/strong> b\u1ea5t k\u00ec m\u1ed9t \u00f4 n\u00e0o.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Cho b\u1ea3ng s\u1ed1 li\u1ec7u sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3721 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-4.png\" width=\"600\" height=\"368\" title=\"chia-o-tam-giac-4\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ed9t c\u1ea7n l\u00e0m \u0111i\u1ec1u ki\u1ec7n l\u1ecdc, sau \u0111\u00f3 copy, nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl<\/strong> + <strong>C<\/strong>\u00a0r\u1ed3i sau \u0111\u00f3 d\u00e1n, <strong>Ctrl+V<\/strong> v\u00e0o \u00f4\u00a0<strong>\u00a0<\/strong>\u0111i\u1ec1u ki\u1ec7n c\u00f3 m\u00e0u v\u00e0ng \u1edf tr\u00ean.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, ch\u1ecdn c\u1ed9t n\u0103m sinh l\u00e0m c\u1ed9t \u0111i\u1ec1u ki\u1ec7n, ta copy ti\u00eau \u0111\u1ec1 <strong>N\u0103m sinh<\/strong> v\u00e0 d\u00e1n v\u00e0o \u00f4 \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u v\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3723 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-5.png\" width=\"600\" height=\"399\" title=\"chia-o-tam-giac-5\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1eadp \u0111i\u1ec1u ki\u1ec7n l\u1ecdc.<\/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-157.gif\" title=\"ex101_92019-nho-157\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0110i\u1ec1u ki\u1ec7n l\u00e0 sinh n\u0103m 1992 v\u00e0 gi\u1edbi t\u00ednh l\u00e0 Nam<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3725 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-6.png\" width=\"600\" height=\"375\" title=\"chia-o-tam-giac-6\"><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 3<\/strong>: V\u00e0o <strong>Data -&gt; Advanced=&gt; <\/strong>H\u1ed9p tho\u1ea1i <strong>Advanced Filter <\/strong>xu\u1ea5t hi\u1ec7n.<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3 c\u1ea7n quan t\u00e2m \u0111\u1ebfn:<\/p>\n<p style=\"text-align: justify\">\u2013 Ph\u1ea7n Action.<\/p>\n<p style=\"text-align: justify\">\u2013 List range: V\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">\u2013 Criteria range: V\u00f9ng ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn <strong>Filter the list, in place\u00a0<\/strong>t\u1ea1i m\u1ee5c <strong>Action, <\/strong>l\u1ecdc d\u1eef li\u1ec7u ngay tr\u00ean b\u1ea3ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3728 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-9.png\" width=\"600\" height=\"354\" title=\"chia-o-tam-giac-9\"><\/p>\n<p style=\"text-align: justify\">=&gt; Nh\u1ea5p OK \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3729 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-10.png\" width=\"600\" height=\"394\" title=\"chia-o-tam-giac-10\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn\u00a0<strong>Copy to another location<\/strong>\u00a0t\u1ea1i m\u1ee5c <strong>Action\u00a0<\/strong>khi mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u sang m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c ngo\u00e0i b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 cho. Ph\u1ea7n <strong>Copy to\u00a0<\/strong>l\u00e0 n\u01a1i m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u01b0a d\u1eef li\u1ec7u m\u1edbi \u0111\u1ebfn.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3726 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-7.png\" width=\"600\" height=\"370\" title=\"chia-o-tam-giac-7\"><\/p>\n<p style=\"text-align: justify\">=&gt; Nh\u1ea5p OK ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3730 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chia-o-tam-giac-11.png\" width=\"600\" height=\"402\" title=\"chia-o-tam-giac-11\"><\/p>\n<p>V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 hi\u1ec3u h\u01a1n v\u1ec1 ch\u1ee9c n\u0103ng Advanced Filter r\u1ed3i \u0111\u00f3. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng ngay n\u00f3 v\u00f2a trong c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. \u0110\u1ec3 hi\u1ec3u th\u00eam v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\"><strong>c\u00e1ch s\u1eed d\u1ee5ng Filter trong Excel<\/strong><\/a> h\u00e3y theo d\u00f5i <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> nh\u00e9!<\/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-157.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2058,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2057","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\/2057","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=2057"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2057\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2058"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}