{"id":4838,"date":"2024-12-08T10:56:24","date_gmt":"2024-12-08T10:56:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter\/"},"modified":"2024-12-08T10:56:24","modified_gmt":"2024-12-08T10:56:24","slug":"huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc tr\u00e1nh d\u1eef li\u1ec7u g\u1ea7n gi\u1ed1ng nhau b\u1eb1ng advanced filter"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Advanced filter l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu\u00a0\u00edch trong\u00a0Excel trong vi\u1ec7c tr\u00edch l\u1ecdc d\u1eef li\u1ec7u. Tuy nhi\u00ean\u00a0trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html\"><strong>Advanced Filter<\/strong><\/a> l\u1ecdc kh\u00f4ng ra\u00a0\u0111\u00fang theo\u00a0\u00fd mu\u1ed1n,\u00a0\u0111\u00f3 l\u00e0 khi d\u1eef li\u1ec7u g\u1ea7n gi\u1ed1ng nhau. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc\u00a0Excel Online<\/a> t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u00e9.<\/em><\/p>\n<p>D\u01b0\u1edbi\u00a0\u0111\u00e2y l\u00e0 1 v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter tr\u00edch l\u1ecdc d\u1eef li\u1ec7u v\u00e0o b\u00e1o c\u00e1o chi ti\u1ebft:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23552\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-advanced-filter-loc-bcct.png\" width=\"1184\" height=\"537\" title=\"su-dung-advanced-filter-loc-bcct\"><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 to\u00e0n b\u1ed9 nh\u1eefng ng\u01b0\u1eddi c\u00f3 b\u1ed9 ph\u1eadn c\u00f3 ch\u1eef \u201cK\u1ebf to\u00e1n\u201d, g\u1ed3m c\u1ea3 \u201cK\u1ebf to\u00e1n tr\u01b0\u1edfng\u201d v\u00e0 \u201cK\u1ebf to\u00e1n th\u1ef1c t\u1eadp\u201d.<\/p>\n<p>C\u00e2u h\u1ecfi\u00a0\u0111\u1eb7t ra l\u00e0: L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 <strong>ch\u1ec9 tr\u00edch l\u1ecdc\u00a0nh\u1eefng ng\u01b0\u1eddi c\u00f3 b\u1ed9 ph\u1eadn\u00a0\u0111\u00fang l\u00e0 \u201cK\u1ebf to\u00e1n\u201d<\/strong> m\u00e0 kh\u00f4ng bao g\u1ed3m K\u1ebf to\u00e1n tr\u01b0\u1edfng hay k\u1ebf to\u00e1n th\u1ef1c t\u1eadp?<\/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-67557b57633e8\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter.html#Giai_thich_ket_qua_cua_Advanced_Filter\" title=\"Gi\u1ea3i th\u00edch k\u1ebft qu\u1ea3 c\u1ee7a Advanced Filter\">Gi\u1ea3i th\u00edch k\u1ebft qu\u1ea3 c\u1ee7a Advanced Filter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter.html#Cach_giup_Advanced_Filter_tranh_duoc_gia_tri_gan_giong_nhau\" title=\"C\u00e1ch gi\u00fap Advanced Filter tr\u00e1nh\u00a0\u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau\">C\u00e1ch gi\u00fap Advanced Filter tr\u00e1nh\u00a0\u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Giai_thich_ket_qua_cua_Advanced_Filter\"><\/span>Gi\u1ea3i th\u00edch k\u1ebft qu\u1ea3 c\u1ee7a Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c k\u00fd t\u1ef1 \u201cK\u1ebf to\u00e1n tr\u01b0\u1edfng\u201d hay \u201cK\u1ebf to\u00e1n th\u1ef1c t\u1eadp\u201d th\u00ec\u00a0\u0111\u1ec1u c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 \u201cK\u1ebf to\u00e1n\u201d v\u00e0 b\u1eaft\u00a0\u0111\u1ea7u b\u1edfi k\u00fd t\u1ef1 n\u00e0y.\u00a0Excel coi c\u00e1c gi\u00e1 tr\u1ecb b\u1eaft\u00a0\u0111\u1ea7u b\u1edfi ch\u1eef \u201cK\u1ebf to\u00e1n\u201d l\u00e0 gi\u1ed1ng nhau khi\u00a0\u00e1p d\u1ee5ng\u00a0\u0111i\u1ec1u ki\u1ec7n l\u00e0 \u201cK\u1ebf to\u00e1n\u201d. Do\u00a0\u0111\u00f3 tr\u01b0\u1eddng h\u1ee3p n\u00e0y Advanced Filter\u00a0\u0111\u00e3 ho\u1ea1t\u00a0\u0111\u1ed9ng\u00a0\u0111\u00fang nguy\u00ean t\u1eafc. Nh\u01b0ng kh\u00f4ng ph\u1ea3i k\u1ebft qu\u1ea3 ch\u00fang ta mong mu\u1ed1n trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/p>\n<p>\u0110\u00e2y\u00a0\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 c\u00e1c k\u1ef9 thu\u1eadt \u201cL\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau\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\/2024\/12\/ex101_92019-nho-397.gif\" title=\"ex101_92019-nho-397\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_giup_Advanced_Filter_tranh_duoc_gia_tri_gan_giong_nhau\"><\/span>C\u00e1ch gi\u00fap Advanced Filter tr\u00e1nh\u00a0\u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb g\u1ea7n gi\u1ed1ng nhau<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, ch\u00fang ta b\u1eaft bu\u1ed9c ph\u1ea3i h\u1ed7 tr\u1ee3 th\u00eam 1 y\u1ebfu t\u1ed1 gi\u00fap ph\u00e2n bi\u1ec7t s\u1ef1 kh\u00e1c nhau. V\u1eady theo b\u1ea1n ch\u1eef \u201cK\u1ebf to\u00e1n\u201d v\u1edbi \u201cK\u1ebf to\u00e1n tr\u01b0\u1edfng\u201d kh\u00e1c nhau\u00a0\u1edf\u00a0\u0111i\u1ec3m n\u00e0o?<\/p>\n<p>3..2..1.. C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 <strong>S\u1ed1 k\u00fd t\u1ef1<\/strong>. Ch\u00ednh x\u00e1c r\u1ed3i. Khi d\u00f9ng h\u00e0m Len\u00a0\u0111\u1ec3\u00a0\u0111o\u00a0\u0111\u1ed9 d\u00e0i s\u1ed1 k\u00fd t\u1ef1 ch\u00fang ta s\u1ebd th\u1ea5y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23553\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-len-phan-biet-do-dai-ky-tu.png\" width=\"643\" height=\"267\" title=\"ham-len-phan-biet-do-dai-ky-tu\"><\/p>\n<p>Ch\u1eef \u201cK\u1ebf to\u00e1n\u201d ch\u1ec9 c\u00f3 7 k\u00fd t\u1ef1<\/p>\n<p>Ch\u1eef \u201cK\u1ebf to\u00e1n tr\u01b0\u1edfng\u201d c\u00f3 t\u1edbi 14 k\u00fd t\u1ef1<\/p>\n<p>Ch\u1eef \u201cK\u1ebf to\u00e1n th\u1ef1c t\u1eadp\u201d c\u00f3 16 k\u00fd t\u1ef1.<\/p>\n<p>V\u1eady ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam\u00a0\u0111i\u1ec1u ki\u1ec7n S\u1ed1\u00a0k\u00fd t\u1ef1\u00a0cho Advanced Filter nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23554\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/them-dieu-kien-so-ki-tu-cho-adf.png\" width=\"987\" height=\"151\" title=\"them-dieu-kien-so-ki-tu-cho-adf\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u00fang ta s\u1eed d\u1ee5ng Advanced Filter c\u00f3 th\u00eam n\u1ed9i dung v\u1ec1 S\u1ed1 k\u00fd t\u1ef1 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23555\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/su-dung-advanced-filter-loc-bcct-tranh-du-lieu-gan-giong.png\" width=\"1223\" height=\"538\" title=\"su-dung-advanced-filter-loc-bcct-tranh-du-lieu-gan-giong\"><\/p>\n<p>K\u1ebft qu\u1ea3 sau khi nh\u1ea5n OK s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c l\u00e0 ch\u1ec9 nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 b\u1ed9 ph\u1eadn l\u00e0 \u201cK\u1ebf to\u00e1n\u201d theo\u00a0\u0111\u00fang y\u00eau c\u1ea7u.<\/p>\n<p>Advanced Filter c\u0169ng kh\u00e1 th\u00fa v\u1ecb ph\u1ea3i kh\u00f4ng n\u00e0o? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Advanced Filter n\u00e0o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft NXT kho b\u1eb1ng Advanced Filter trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-chuc-nang-advanced-filter-trong-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Advanced Filter trong VBA<\/a><\/p>\n<p style=\"padding-left: 30px\"><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<\/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-397.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4839,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4838","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\/4838","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=4838"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4838\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4839"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}