{"id":4410,"date":"2024-12-05T03:05:45","date_gmt":"2024-12-05T03:05:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter\/"},"modified":"2024-12-05T03:05:45","modified_gmt":"2024-12-05T03:05:45","slug":"loc-ra-danh-sach-duy-nhat-voi-advanced-filter","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter\/","title":{"rendered":"L\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t v\u1edbi Advanced Filter"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong c\u00f4ng vi\u1ec7c nhi\u1ec1u khi ch\u00fang ta ph\u1ea3i l\u1ea5y ra danh s\u00e1ch c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng nh\u01b0 kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p,\u2026.\u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c l\u00e0m c\u00e1c b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p, chi ti\u1ebft.<\/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-6751188838779\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter.html#Loc_ra_danh_sach_duy_nhat_voi_Advanced_Filter\" title=\"L\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t v\u1edbi Advanced Filter\">L\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t v\u1edbi Advanced Filter<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter.html#Buoc_1\" title=\"B\u01b0\u1edbc 1\">B\u01b0\u1edbc 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter.html#Buoc_2\" title=\"B\u01b0\u1edbc 2\">B\u01b0\u1edbc 2<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Loc_ra_danh_sach_duy_nhat_voi_Advanced_Filter\"><\/span>L\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t v\u1edbi Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u1ede c\u00e1c b\u00e0i vi\u1ebft tr\u01b0\u1edbc <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> c\u0169ng \u0111\u00e3 gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 l\u1ecdc tr\u00f9ng v\u00e0 l\u1ea5y ra danh s\u00e1ch duy nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i \u1edf \u0111\u00e2y:<\/p>\n<blockquote>\n<p style=\"text-align: center\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-loc-gia-tri-trung-nhau-tren-excel-2010.html\">H\u01b0\u01a1\u0301ng d\u00e2\u0303n lo\u0323c gia\u0301 tri\u0323 tru\u0300ng nhau tr\u00ean excel 2010<\/a><\/strong><\/p>\n<p style=\"text-align: center\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-bo-gia-tri-trung-trong-vba.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng trong vba<\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t c\u00e1ch n\u1eefa \u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch duy nh\u1ea5t \u0111\u00f3 l\u00e0 d\u00f9ng c\u00f4ng c\u1ee5 Advanced Filter.<\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y m\u00ecnh c\u00f3 m\u1ed9t b\u1ea3ng chi ti\u1ebft b\u00e1n h\u00e0ng v\u00e0 m\u00ecnh c\u1ea7n l\u1ea5y ra danh s\u00e1ch duy nh\u1ea5t c\u1ee7a t\u00ean c\u00e1c s\u1ea3n ph\u1ea9m b\u00e1n \u0111\u01b0\u1ee3c \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho vi\u1ec7c\u00a0 l\u00e0m c\u00e1c b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p. V\u1edbi Advanced Filter ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span>B\u01b0\u1edbc 1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ea7u ti\u00ean b\u1ea1n v\u00e0o Advanced Filter<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/1-13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28792\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-13-1024x767-1.png\" width=\"1024\" height=\"767\" title=\"1-13-1024x767-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span>B\u01b0\u1edbc 2<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1ea1i h\u1ed9p tho\u1ea1i Advanced Filter<\/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-356.gif\" title=\"ex101_92019-nho-356\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28793\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-14.png\" width=\"355\" height=\"375\" title=\"2-14\"><\/p>\n<ul style=\"list-style-type: disc\">\n<li><strong>Action:<\/strong>\u00a0B\u1ea1n ch\u1ecdn Copy to another location.<\/li>\n<li><strong>List range:<\/strong> Ch\u1ecdn d\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t t\u1eeb \u0111\u00f3.<\/li>\n<li><strong>Criteria range:<\/strong>\u00a0M\u1ee5c n\u00e0y b\u1ea1n \u0111\u1ec3 tr\u1ed1ng.<\/li>\n<li><strong>Copy to:<\/strong> B\u1ea1n ch\u1ecdn \u00f4 mu\u1ed1n tr\u00edch xu\u1ea5t k\u1ebft qu\u1ea3 ra.<\/li>\n<li><strong>Unique records Only:<\/strong>\u00a0B\u1ea1n c\u1ea7n Tick ch\u1ecdn m\u1ee5c n\u00e0y \u0111\u1ec3 c\u00f3 c\u00f3 th\u1ec3 tr\u00edch l\u1ecdc ra \u0111\u01b0\u1ee3c danh s\u00e1ch duy nh\u1ea5t.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/3-7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-28836\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-7-1024x636-1.png\" width=\"1024\" height=\"636\" title=\"3-7-1024x636-1\"><\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi 2 b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n tr\u00ean, H\u1ecdc Excel Online hy v\u1ecdng b\u1ea1n \u0111\u00e3 c\u00f3 th\u00eam \u0111\u01b0\u1ee3c 1 c\u00e1ch n\u1eefa \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng v\u00e0 l\u1ea5y ra danh s\u00e1ch duy nh\u1ea5t, nh\u1eb1m\u00a0ph\u1ee5c v\u1ee5 cho c\u00e1c\u00a0m\u1ee5c \u0111\u00edch\u00a0kh\u00e1c nhau c\u1ee7a m\u00ecnh.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 Excel, VBA nh\u1eb1m t\u0103ng hi\u1ec7u qu\u1ea3, n\u0103ng su\u1ea5t trong x\u1eed l\u00fd c\u00f4ng vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online.<\/p>\n<hr>\n<p><a href=\"https:\/\/hocexcel.online\/\">C\u00e1c kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-advanced-filter-de-loc-ra-cac-ngay-cuoi-tuan.html\">S\u1eed d\u1ee5ng Advanced Filter \u0111\u1ec3 l\u1ecdc ra c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/advancedfilter-voi-criteria-range-la-mot-cau-dieu-kien.html\">Advanced Filter v\u1edbi Criteria range l\u00e0 m\u1ed9t c\u00e2u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc tr\u00e1nh d\u1eef li\u1ec7u g\u1ea7n gi\u1ed1ng nhau b\u1eb1ng Advanced Filter<\/a><\/p>\n<p><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>\u00a0<\/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-356.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4411,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4410","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\/4410","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=4410"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4410\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4411"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}