{"id":7461,"date":"2024-12-21T17:38:36","date_gmt":"2024-12-21T17:38:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/advanced-filter-mot-thu-thuat-ban-chua-biet\/"},"modified":"2024-12-21T17:38:36","modified_gmt":"2024-12-21T17:38:36","slug":"advanced-filter-mot-thu-thuat-ban-chua-biet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/advanced-filter-mot-thu-thuat-ban-chua-biet\/","title":{"rendered":"Advanced filter \u2013 m\u1ed9t th\u1ee7 thu\u1eadt b\u1ea1n ch\u01b0a bi\u1ebft"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong c\u00e1c b\u00e0i h\u01b0\u1edbng d\u1eabn c\u01a1 b\u1ea3n v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter<\/a><\/strong> trong Excel, h\u1ea7u h\u1ebft c\u00e1c b\u1ea1n \u0111\u1ec1u \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn ph\u1ea3i copy y nguy\u00ean ti\u00eau \u0111\u1ec1 c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u. C\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 ch\u00fang ta s\u1eafp x\u1ebfp l\u1ea1i th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t d\u1eef li\u1ec7u n\u00e0y, b\u1ecf b\u1edbt \u0111i 1 s\u1ed1 c\u1ed9t m\u00e0 ch\u00fang ta kh\u00f4ng c\u1ea7n d\u00f9ng kh\u00f4ng? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 c\u00f3, m\u1eddi c\u00e1c b\u1ea1n ti\u1ebfp t\u1ee5c theo d\u00f5i b\u00e0i vi\u1ebft \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi.<\/em><\/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-6766fd1b5ed42\" 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\/thu-thuat-advanced-filter.html#Advanced_Filter_%E2%80%93_cach_thiet_lap\" title=\"Advanced Filter \u2013 c\u00e1ch thi\u1ebft l\u1eadp\">Advanced Filter \u2013 c\u00e1ch thi\u1ebft l\u1eadp<\/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\/thu-thuat-advanced-filter.html#Chuan_bi_du_lieu_de_loc_cho_advanced_filter\" title=\"Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc cho advanced filter\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc cho advanced filter<\/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\/thu-thuat-advanced-filter.html#Advanced_Filter_%E2%80%93_Thiet_lap_vung_dieu_kien_loc\" title=\"Advanced Filter \u2013 Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc\">Advanced Filter \u2013 Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc<\/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\/thu-thuat-advanced-filter.html#Thiet_lap_vung_copy_du_lieu_toi\" title=\"Thi\u1ebft l\u1eadp v\u00f9ng copy d\u1eef li\u1ec7u t\u1edbi\">Thi\u1ebft l\u1eadp v\u00f9ng copy d\u1eef li\u1ec7u t\u1edbi<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Filter_%E2%80%93_cach_thiet_lap\"><\/span><span id=\"Lam_the_nao_de_su_dung_Advanced_Filter_trong_Excel\" style=\"font-size: 14pt\">Advanced Filter \u2013 c\u00e1ch thi\u1ebft l\u1eadp<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Chuan_bi_du_lieu_de_loc_cho_advanced_filter\"><\/span><span id=\"Chuan_bi_du_lieu_de_loc\" style=\"font-size: 12pt\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc cho advanced filter<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 l\u1ecdc ch\u00ednh x\u00e1c nh\u1ea5t, c\u00f3 2 \u0111i\u1ec1u b\u1ea1n c\u1ea7n ph\u1ea3i ch\u00fa \u00fd:<\/p>\n<ul>\n<li>Ti\u00eau \u0111\u1ec1 c\u00e1c c\u1ed9t d\u1eef li\u1ec7u trong b\u1ea3ng d\u1eef li\u1ec7u l\u00e0 duy nh\u1ea5t, kh\u00f4ng c\u00f3 2 hay nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u c\u00f3 ti\u00eau \u0111\u1ec1 gi\u1ed1ng nhau.<\/li>\n<li>Kh\u00f4ng c\u00f3 d\u00f2ng tr\u1ed1ng trong b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_%E2%80%93_Thiet_lap_vung_dieu_kien_loc\"><\/span><span id=\"Thiet_lap_vung_dieu_kien_loc\" style=\"font-size: 12pt\">Advanced Filter \u2013 Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t v\u00e0i \u0111i\u1ec3m l\u01b0u \u00fd khi chu\u1ea9n b\u1ecb v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc:<\/p>\n<ul>\n<li>Ti\u00eau \u0111\u1ec1 c\u1ee7a v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc v\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n ph\u1ea3i \u0111\u1ed3ng nh\u1ea5t.<\/li>\n<li>2 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00ean c\u00f9ng m\u1ed9t d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n V\u00c0 \u2013 ngh\u0129a l\u00e0 nh\u1eefng d\u00f2ng tho\u1ea3 m\u00e3n c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac s\u1ebd c\u00f3 m\u1eb7t trong k\u1ebft qu\u1ea3<\/li>\n<li>2 \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00ean 2 d\u00f2ng kh\u00e1c nhau t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C \u2013 ngh\u0129a l\u00e0 nh\u1eefng d\u00f2ng tho\u1ea3 m\u00e3n 1 trong 2 \u0111i\u1ec1u ki\u1ec7n s\u1ebd c\u00f3 m\u1eb7t trong k\u1ebft qu\u1ea3<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5, ch\u00fang ta c\u1ea7n l\u1ecdc ra nh\u1eefng d\u00f2ng c\u1ee7a Mi\u1ec1n B\u1eafc v\u00e0 c\u00f3 Sub-total l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 900, th\u00ec ch\u00fang ta c\u1ea7n thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n cho Advanced Filter nh\u01b0 sau:<\/p>\n<div id=\"attachment_31484\" class=\"wp-caption aligncenter\">\n<p id=\"caption-attachment-31484\" class=\"wp-caption-text\"><strong>Ch\u00fa \u00fd: <\/strong>b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o ti\u00eau \u0111\u1ec1 c\u1ee7a v\u00f9ng \u0111i\u1ec1u ki\u1ec7n v\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t t\u01b0\u01a1ng \u1ee9ng trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t, gi\u1ed1ng nhau ho\u00e0n to\u00e0n, v\u1eady n\u00ean, khi chu\u1ea9n b\u1ecb v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 copy ti\u00eau \u0111\u1ec1 c\u1ed9t \u1edf v\u00f9ng d\u1eef li\u1ec7u v\u00e0 d\u00e1n v\u00e0o ti\u00eau \u0111\u1ec1 \u1edf v\u00f9ng \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_vung_copy_du_lieu_toi\"><\/span><span id=\"Thiet_lap_vung_dieu_kien_loc\" style=\"font-size: 12pt\">Thi\u1ebft l\u1eadp v\u00f9ng copy d\u1eef li\u1ec7u t\u1edbi<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta v\u1eabn s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c thi\u1ebft l\u1eadp Advanced Filter nh\u01b0 b\u00ecnh th\u01b0\u1eddng. Sau \u0111\u00f3 \u1edf ph\u1ea7n chu\u1ea9n b\u1ecb ti\u00eau \u0111\u1ec1 \u0111\u1ec3 copy d\u1eef li\u1ec7u l\u1ecdc ra, ta s\u1ebd ch\u1ee7 \u0111\u1ed9ng ch\u1ec9 ch\u1ecdn nh\u1eefng c\u1ed9t m\u00e0 ch\u00fang ta c\u1ea7n v\u00e0 c\u0169ng ch\u1ee7 \u0111\u1ed9ng lu\u00f4n trong vi\u1ec7c s\u1eafp x\u1ebfp c\u00e1c c\u1ed9t \u1edf b\u01b0\u1edbc n\u00e0y. Sau khi Advanced Filter ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u th\u00ec v\u00f9ng k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp v\u00e0 ch\u1ec9 bao g\u1ed3m nh\u1eefng c\u1ed9t m\u00e0 ch\u00fang ta c\u1ea7n.<\/p>\n<p>M\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o video h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y \u0111\u1ec3 h\u00ecnh dung r\u00f5 h\u01a1n v\u1ec1 k\u1ef9 thu\u1eadt r\u1ea5t h\u1eefu \u00edch <a href=\"https:\/\/www.youtube.com\/watch?time_continue=2&amp;v=HOholNrluzA&amp;feature=emb_logo\" target=\"_blank\" rel=\"noopener noreferrer\">n\u00e0y<\/a>.<\/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-668.gif\" title=\"ex101_92019-nho-668\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/HOholNrluzA\" width=\"720\" height=\"480\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>\u0110\u1ed9i ng\u0169<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong><\/a> hy v\u1ecdng b\u1ea1n \u0111\u00e3 c\u00f3 m\u1ed9t bu\u1ed5i ti\u1ebfp thu ki\u1ebfn th\u1ee9c tuy\u1ec7t v\u1eddi. H\u00e3y chia s\u1ebb b\u00e0i vi\u1ebft n\u00e0y cho nhi\u1ec1u ng\u01b0\u1eddi 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-668.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7462,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7461","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\/7461","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=7461"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7461\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7462"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}