{"id":3610,"date":"2024-12-03T03:07:36","date_gmt":"2024-12-03T03:07:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the\/"},"modified":"2024-12-03T03:07:36","modified_gmt":"2024-12-03T03:07:36","slug":"cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng Advanced Filter trong Excel k\u00e8m c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd h\u1ecdc <strong>c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter trong Excel<\/strong> qua c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3. Ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u n\u00e2ng cao Advanced Filter gi\u00fap ch\u00fang ta l\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u1eeb \u0111\u01a1n gi\u1ea3n t\u1edbi ph\u1ee9c t\u1ea1p.<\/em><\/p>\n<p>C\u00f3 th\u1ec3 c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft <strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-du-lieu-trong-excel.html\">ch\u1ee9c n\u0103ng l\u1ecdc Auto Filter trong Excel<\/a><\/strong> a cung c\u1ea5p cho ch\u00fang ta r\u1ea5t nhi\u1ec1u ch\u1ee9c n\u0103ng l\u1ecdc nhi\u1ec1u ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau nh\u01b0 l\u1ecdc theo chu\u1ed7i, l\u1ecdc theo s\u1ed1, l\u1ecdc ng\u00e0y th\u00e1ng v\u00e0 c\u00f3 th\u1ec3 x\u1eed l\u00fd v\u00e0 tho\u1ea3 m\u00e3n r\u1ea5t nhi\u1ec1u t\u00ecnh hu\u1ed1ng trong c\u00f4ng vi\u1ec7c. Tuy nhi\u00ean, v\u1eabn c\u00f3 nh\u1eefng t\u00ecnh hu\u1ed1ng ch\u00fang ta kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng Auto Filter \u0111\u1ec3 gi\u1ea3i quy\u1ebft, Advanced Filter c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft nh\u1eefng t\u00ecnh hu\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y.<\/p>\n<p>Ch\u1ee9c n\u0103ng Advanced Filter c\u00f3 m\u1eb7t trong c\u00e1c phi\u00ean b\u1ea3n Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007 v\u00e0 Excel 2003.<\/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-674e75f6b9f2f\" 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\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Su_khac_biet_giua_Advanced_Filter_va_AutoFilter\" title=\"S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa Advanced Filter v\u00e0 AutoFilter\">S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa Advanced Filter v\u00e0 AutoFilter<\/a><\/li>\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\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Lam_the_nao_de_su_dung_Advanced_Filter_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Advanced Filter trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Advanced Filter trong Excel<\/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\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Chuan_bi_du_lieu_de_loc\" title=\"Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 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\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Thiet_lap_vung_dieu_kien_loc\" title=\"Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc\">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-5\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Ap_dung_Advanced_Filter\" title=\"\u00c1p d\u1ee5ng Advanced Filter\">\u00c1p d\u1ee5ng Advanced Filter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Thiet_lap_cho_Advanced_Filter\" title=\"Thi\u1ebft l\u1eadp cho Advanced Filter\">Thi\u1ebft l\u1eadp cho Advanced Filter<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Su_dung_Advanced_Filter_%E2%80%93_vung_dieu_kien\" title=\"S\u1eed d\u1ee5ng Advanced Filter \u2013 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng Advanced Filter \u2013 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_dieu_kien_so_sanh_so_va_ngay_thang\" title=\"Advanced Filter \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng\">Advanced Filter \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_%E2%80%93_Loc_du_lieu_chuoi\" title=\"Advanced Filter \u2013 L\u1ecdc d\u1eef li\u1ec7u chu\u1ed7i\">Advanced Filter \u2013 L\u1ecdc d\u1eef li\u1ec7u chu\u1ed7i<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Vi_du_1_Loc_du_lieu_text_chinh_xac\" title=\"V\u00ed d\u1ee5 1. L\u1ecdc d\u1eef li\u1ec7u text ch\u00ednh x\u00e1c\">V\u00ed d\u1ee5 1. L\u1ecdc d\u1eef li\u1ec7u text ch\u00ednh x\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Vi_du_2_Loc_du_lieu_text_bat_dau_boi\" title=\"V\u00ed d\u1ee5 2. L\u1ecdc d\u1eef li\u1ec7u text b\u1eaft \u0111\u1ea7u b\u1edfi\">V\u00ed d\u1ee5 2. L\u1ecdc d\u1eef li\u1ec7u text b\u1eaft \u0111\u1ea7u b\u1edfi<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Su_dung_cong_thuc_trong_vung_dieu_kien_Advanced_Filter\" title=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n Advanced Filter\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n Advanced Filter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_voi_dieu_kien_VA\" title=\"Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n V\u00c0\">Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n V\u00c0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_voi_dieu_kien_HOAC\" title=\"Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C\">Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_voi_dieu_kien_hon_hop\" title=\"Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n h\u1ed7n h\u1ee3p\">Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n h\u1ed7n h\u1ee3p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-su-dung-advanced-filter-trong-excel-kem-cac-vi-du-cu-the.html#Advanced_Filter_de_sap_xep_lai_cac_cot_trong_bang_du_lieu\" title=\"Advanced Filter \u0111\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u\">Advanced Filter \u0111\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Su_khac_biet_giua_Advanced_Filter_va_AutoFilter\"><\/span>S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa Advanced Filter v\u00e0 AutoFilter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu so s\u00e1nh gi\u1eefa ch\u1ee9c n\u0103ng l\u1ecdc c\u01a1 b\u1ea3n AutoFilter, ch\u1ee9c n\u0103ng l\u1ecdc <strong>Advanced Filter<\/strong> kh\u00e1c bi\u1ec7t \u1edf m\u1ed9t v\u00e0i \u0111i\u1ec3m quan tr\u1ecdng nh\u01b0 sau<\/p>\n<ul style=\"list-style-type: square\">\n<li><strong>Ch\u1ee9c n\u0103ng l\u1ecdc n\u00e2ng cao Advanced Filter<\/strong> s\u1ebd y\u00eau c\u1ea7u ch\u00fang ta ph\u1ea3i c\u00f3 m\u1ed9t s\u1ed1 thi\u1ebft l\u1eadp v\u1ec1 v\u00f9ng d\u1eef li\u1ec7u, v\u00f9ng \u0111i\u1ec1u ki\u1ec7n tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng.<br \/>\n<strong>Ch\u1ee9c n\u0103ng l\u1ecdc AutoFilter<\/strong> cho ph\u00e9p ch\u00fang ta l\u1ecdc d\u1eef li\u1ec7u d\u1ef1a tr\u00ean nh\u1eefng b\u1ed9 l\u1ecdc \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a s\u1eb5n.<\/li>\n<li><strong>Ch\u1ee9c n\u0103ng l\u1ecdc AutoFilter\u00a0<\/strong>c\u00f3 gi\u1edbi h\u1ea1n t\u1ed1i \u0111a 2 \u0111i\u1ec1u ki\u1ec7n l\u1ecdc, th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a trong h\u1ed9p tho\u1ea1i\u00a0<em>Custom AutoFilter.<br \/>\n<\/em>S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao Advanced Filter cho ph\u00e9p ch\u00fang ta l\u1ecdc d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong nhi\u1ec1u c\u1ed9t, ngo\u00e0i ra, Advanced Filter c\u00f2n cho ch\u00fang ta l\u1ef1a ch\u1ecdn copy d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc ra m\u1ed9t v\u00f9ng kh\u00e1c.<\/li>\n<\/ul>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\">c\u00e1ch s\u1eed d\u1ee5ng filter trong excel<\/a> 365 c\u01a1 b\u1ea3n<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_su_dung_Advanced_Filter_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Advanced Filter trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng l\u1ecdc n\u00e2ng cao Advanced Filter s\u1ebd kh\u00f3 h\u01a1n AutoFilter m\u1ed9t ch\u00fat (th\u1ebf m\u1edbi g\u1ecdi l\u00e0 n\u00e2ng cao). Tuy nhi\u00ean, m\u1ed9t khi \u0111\u00e3 th\u00e0nh th\u1ea1o, b\u1ea1n s\u1ebd th\u1ea5y Advanced Filter l\u1ee3i h\u1ea1i t\u1edbi m\u1ee9c n\u00e0o. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter trong ph\u1ea7n sau \u0111\u00e2y c\u1ee7a b\u00e0i vi\u1ebft.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chuan_bi_du_lieu_de_loc\"><\/span>Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ecdc<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<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-279.gif\" title=\"ex101_92019-nho-279\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"list-style-type: square\">\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<figure id=\"attachment_31483\" aria-describedby=\"caption-attachment-31483\" style=\"width: 392px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-advanced-filter-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31483\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-advanced-filter-01.png\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng Advanced Filter\" width=\"392\" height=\"167\" title=\"cach-su-dung-advanced-filter-01\"><\/a><figcaption id=\"caption-attachment-31483\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng Advanced Filter<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_vung_dieu_kien_loc\"><\/span>Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n l\u1ecdc<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 style=\"list-style-type: square\">\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<figure id=\"attachment_31484\" aria-describedby=\"caption-attachment-31484\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-advanced-filter-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31484\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-advanced-filter-02.png\" alt=\"Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n Advanced Filter\" width=\"439\" height=\"220\" title=\"cach-su-dung-advanced-filter-02\"><\/a><figcaption id=\"caption-attachment-31484\" class=\"wp-caption-text\">Thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n Advanced Filter<\/figcaption><\/figure>\n<p><strong>Ch\u00fa \u00fd:\u00a0<\/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<h3><span class=\"ez-toc-section\" id=\"Ap_dung_Advanced_Filter\"><\/span>\u00c1p d\u1ee5ng Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi \u0111\u00e3 chu\u1ea9n b\u1ecb xong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng Advanced Filter nh\u01b0 sau:<\/p>\n<ul style=\"list-style-type: square\">\n<li>Ch\u1ecdn 1 \u00f4 b\u1ea5t k\u00ec trong v\u00f9ng d\u1eef li\u1ec7u<\/li>\n<li>Trong Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, ch\u1ecdn th\u1ebb\u00a0<em>Data\u00a0<\/em>&gt;\u00a0<em>Nh\u00f3m l\u1ec7nh Sort &amp; Filter\u00a0<\/em>sau \u0111\u00f3 b\u1ea5m <strong>Advanced<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_31486\" aria-describedby=\"caption-attachment-31486\" style=\"width: 356px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/thiet-lap-advanced-filter.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31486\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-advanced-filter.png\" alt=\"Thi\u1ebft l\u1eadp advanced filter\" width=\"356\" height=\"90\" title=\"thiet-lap-advanced-filter\"><\/a><figcaption id=\"caption-attachment-31486\" class=\"wp-caption-text\">Thi\u1ebft l\u1eadp advanced filter<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_cho_Advanced_Filter\"><\/span>Thi\u1ebft l\u1eadp cho Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u1eeda s\u1ed5 Advanced Filter, b\u1ea1n c\u00f3 c\u00e1c l\u1ef1a ch\u1ecdn v\u1ec1 thi\u1ebft l\u1eadp sau \u0111\u00e2y:<\/p>\n<figure id=\"attachment_31487\" aria-describedby=\"caption-attachment-31487\" style=\"width: 415px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/thiet-lap-advanced-filter-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31487\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-advanced-filter-01.png\" alt=\"Thi\u1ebft l\u1eadp advanced filter trong Excel\" width=\"415\" height=\"275\" title=\"thiet-lap-advanced-filter-01\"><\/a><figcaption id=\"caption-attachment-31487\" class=\"wp-caption-text\">Thi\u1ebft l\u1eadp advanced filter trong Excel<\/figcaption><\/figure>\n<ul style=\"list-style-type: square\">\n<li><strong>Action:\u00a0<\/strong>l\u1ef1a ch\u1ecdn l\u1ecdc \u201ct\u1ea1i ch\u1ed7\u201d \u2013\u00a0<em>Filter the list, in-place<\/em> hay l\u1ecdc d\u1eef li\u1ec7u r\u1ed3i copy ra n\u01a1i kh\u00e1c tr\u00ean b\u1ea3ng t\u00ednh \u2013\u00a0<em>Copy to another location<br \/>\n<\/em>N\u1ebfu b\u1ea1n ch\u1ecdn l\u1ecdc \u201ct\u1ea1i ch\u1ed7\u201d \u2013\u00a0<em>Filter the list, in-place\u00a0<\/em>th\u00ec sau khi l\u1ecdc, c\u00e1c d\u00f2ng kh\u00f4ng tho\u1ea3 m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc s\u1ebd \u0111\u01b0\u1ee3c \u1ea9n \u0111i.<\/li>\n<li><strong>List range:\u00a0<\/strong>V\u00f9ng d\u1eef li\u1ec7u b\u1ea1n s\u1ebd l\u1ecdc, bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1<br \/>\nTr\u01b0\u1edbc khi b\u1ea1n m\u1edf c\u1eeda s\u1ed5 thi\u1ebft l\u1eadp Advanced Filter, n\u1ebfu b\u1ea1n \u0111ang \u0111\u1ec3 chu\u1ed9t trong v\u00f9ng d\u1eef li\u1ec7u, th\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng thi\u00eat l\u1eadp\u00a0<em>List Range\u00a0<\/em>m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng. Trong tr\u01b0\u1eddng h\u1ee3p Excel l\u00e0m \u0111i\u1ec1u n\u00e0y kh\u00f4ng ch\u00ednh x\u00e1c, b\u1ea1n h\u00e3y l\u1ef1a ch\u1ecdn l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch b\u1ea5m n\u00fat ch\u1ecdn l\u1ea1i d\u1eef li\u1ec7u \u1edf b\u00ean tay ph\u1ea3i \u00f4\u00a0<em>List Range\u00a0<\/em>sau \u0111\u00f3 ch\u1ecdn l\u1ea1i v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng chu\u1ed9t<\/li>\n<li><strong>Criteria range:\u00a0<\/strong>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n ch\u00fang ta v\u1eeba thi\u1ebft l\u1eadp nh\u01b0 \u0111o\u1ea1n ph\u00eda tr\u00ean \u0111\u00e3 vi\u1ebft<\/li>\n<li><strong>Copy to:\u00a0<\/strong>N\u1ebfu trong ph\u1ea7n\u00a0<em>Action\u00a0<\/em>b\u1ea1n ch\u1ecdn\u00a0<em>Copy to another location\u00a0<\/em>th\u00ec l\u1ef1a ch\u1ecdn n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn v\u00f9ng b\u1ea1n mu\u1ed1n copy k\u1ebft qu\u1ea3 l\u1ecdc t\u1edbi. N\u1ebfu trong ph\u1ea7n\u00a0<em>Action\u00a0<\/em>b\u1ea1n ch\u1ecdn\u00a0<em>Filter the list, in-place\u00a0<\/em>th\u00ec l\u1ef1a ch\u1ecdn n\u00e0y s\u1ebd b\u1ecb m\u1edd \u0111i, kh\u00f4ng \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t.<\/li>\n<li><strong>Unique records only:\u00a0<\/strong>N\u1ebfu ch\u1ecdn h\u1ed9p ki\u1ec3m n\u00e0y,\u00a0<em>Advanced Filter\u00a0<\/em>s\u1ebd l\u1ecdc ra nh\u1eefng k\u1ebft qu\u1ea3 duy nh\u1ea5t cho b\u1ea1n.<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 sau khi b\u1ea5m n\u00fat OK \u1edf h\u1ed9p tho\u1ea1i thi\u1ebft l\u1eadp Advanced Filter<\/p>\n<figure id=\"attachment_31488\" aria-describedby=\"caption-attachment-31488\" style=\"width: 429px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/thiet-lap-advanced-filter-ket-qua.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31488\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-advanced-filter-ket-qua.png\" alt=\"K\u1ebft qu\u1ea3 c\u1ee7a advanced filter\" width=\"429\" height=\"167\" title=\"thiet-lap-advanced-filter-ket-qua\"><\/a><figcaption id=\"caption-attachment-31488\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 c\u1ee7a advanced filter<\/figcaption><\/figure>\n<p>B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u1ecdc n\u00e0y v\u1edbi ch\u1ee9c n\u0103ng AutoFilter, \u0110\u00fang! Tuy nhi\u00ean \u0111\u1ebfn \u0111\u00e2y, b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter m\u1ed9t c\u00e1ch c\u01a1 b\u1ea3n, \u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 \u0111\u1ebfn v\u1edbi nh\u1eefng v\u00ed d\u1ee5 n\u00e2ng cao h\u01a1n \u1edf ph\u1ea7n ti\u1ebfp theo.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_Advanced_Filter_%E2%80%93_vung_dieu_kien\"><\/span>S\u1eed d\u1ee5ng Advanced Filter \u2013 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u00ednh n\u00e2ng cao c\u1ee7a ch\u1ee9c n\u0103ng l\u1ecdc Advanced Filter n\u1eb1m \u1edf vi\u1ec7c thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n, n\u1eafm \u0111\u01b0\u1ee3c ki\u1ebfn th\u1ee9c n\u00e0y, b\u1ea1n s\u1ebd \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c Advanced Filter trong r\u1ea5t nhi\u1ec1u t\u00ecnh hu\u1ed1ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_dieu_kien_so_sanh_so_va_ngay_thang\"><\/span>Advanced Filter \u0111i\u1ec1u ki\u1ec7n so s\u00e1nh s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t s\u1ed1 to\u00e1n t\u1eed so s\u00e1nh v\u00e0 \u00fd ngh\u0129a \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong b\u1ea3ng sau \u0111\u00e2y<\/p>\n<figure id=\"attachment_31489\" aria-describedby=\"caption-attachment-31489\" style=\"width: 382px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-advanced-filter-toan-tu-so-sanh.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31489\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-advanced-filter-toan-tu-so-sanh.png\" alt=\"C\u00e1c to\u00e1n t\u1eed so s\u00e1nh\" width=\"382\" height=\"189\" title=\"cach-su-dung-advanced-filter-toan-tu-so-sanh\"><\/a><figcaption id=\"caption-attachment-31489\" class=\"wp-caption-text\">C\u00e1c to\u00e1n t\u1eed so s\u00e1nh<\/figcaption><\/figure>\n<p>V\u00ed d\u1ee5 sau \u0111\u00e2y, ch\u00fang ta c\u1ea7n l\u1ecdc ra nh\u1eefng d\u00f2ng tho\u1ea3 m\u00e3n t\u1ea5t c\u1ea3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<ul style=\"list-style-type: square\">\n<li>V\u00f9ng: Mi\u1ec1n B\u1eafc<\/li>\n<li>Ng\u00e0y \u0111\u1eb7t: trong kho\u1ea3ng 01\/07\/2020 v\u00e0 30\/07\/2020<\/li>\n<li>Th\u00e0nh ti\u1ec1n: l\u1edbn h\u01a1n 800<\/li>\n<\/ul>\n<p>C\u00e1ch thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u01b0 h\u00ecnh minh ho\u1ea1. Nh\u01b0 \u0111\u00e3 n\u00f3i ph\u00eda tr\u00ean, \u0111i\u1ec1u ki\u1ec7n tr\u00ean c\u00f9ng 1 d\u00f2ng l\u00e0 \u0111i\u1ec1u ki\u1ec7n V\u00c0. \u0110i\u1ec1u ki\u1ec7n trong kho\u1ea3ng ng\u00e0y, \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1edfi 2 c\u1ed9t\u00a0<em>Ng\u00e0y \u0111\u1eb7t\u00a0<\/em>nh\u01b0 trong h\u00ecnh.<\/p>\n<figure id=\"attachment_31490\" aria-describedby=\"caption-attachment-31490\" style=\"width: 345px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/cach-su-dung-advanced-filter-vi-du-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31490\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-su-dung-advanced-filter-vi-du-1.png\" alt=\"V\u00ed d\u1ee5 v\u1ec1 advanced filter trong Excel\" width=\"345\" height=\"249\" title=\"cach-su-dung-advanced-filter-vi-du-1\"><\/a><figcaption id=\"caption-attachment-31490\" class=\"wp-caption-text\">V\u00ed d\u1ee5 v\u1ec1 advanced filter trong Excel<\/figcaption><\/figure>\n<p><strong>Ch\u00fa \u00fd:\u00a0<\/strong>khi l\u1ecdc d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1edbi\u00a0<em>Advanced Filter,\u00a0<\/em>b\u1ea1n c\u1ea7n ch\u00fa \u00fd t\u1edbi 2 \u0111i\u1ec1u:<\/p>\n<ul style=\"list-style-type: square\">\n<li>Ng\u00e0y th\u00e1ng trong b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u00fang l\u00e0 ng\u00e0y th\u00e1ng hay ch\u01b0a<\/li>\n<li>C\u00e1ch nh\u1eadp ng\u00e0y th\u00e1ng trong Excel c\u1ee7a b\u1ea1n cho \u0111\u00fang<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html\">Tham kh\u1ea3o b\u00e0i vi\u1ebft v\u1ec1 thi\u1ebft l\u1eadp ng\u00e0y th\u00e1ng trong Excel \u0111\u1ec3 x\u1eed l\u00fd khi g\u1eb7p l\u1ed7i<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_%E2%80%93_Loc_du_lieu_chuoi\"><\/span>Advanced Filter \u2013 L\u1ecdc d\u1eef li\u1ec7u chu\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng Advanced Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 l\u1ecdc chu\u1ed7i.<\/p>\n<figure id=\"attachment_31491\" aria-describedby=\"caption-attachment-31491\" style=\"width: 410px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-loc-du-lieu-dang-text.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31491\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-loc-du-lieu-dang-text.png\" alt=\"Advanced Filter l\u1ecdc d\u1eef li\u1ec7u d\u1ea1ng text\" width=\"410\" height=\"116\" title=\"advanced-filter-loc-du-lieu-dang-text\"><\/a><figcaption id=\"caption-attachment-31491\" class=\"wp-caption-text\">Advanced Filter l\u1ecdc d\u1eef li\u1ec7u d\u1ea1ng text<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_1_Loc_du_lieu_text_chinh_xac\"><\/span>V\u00ed d\u1ee5 1. L\u1ecdc d\u1eef li\u1ec7u text ch\u00ednh x\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u1ed9t S\u1ea3n Ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c l\u00e0 \u201cChu\u1ed1i\u201d. \u0110i\u1ec1u ki\u1ec7n l\u1ecdc trong A2 m\u00e0 b\u1ea1n c\u1ea7n g\u00f5 v\u00e0o l\u00e0 <strong>=\u201d=Chu\u1ed1i\u201d\u00a0<\/strong>trong \u00f4 A2 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0\u00a0<strong>=Chu\u1ed1i\u00a0<\/strong><\/p>\n<figure id=\"attachment_31492\" aria-describedby=\"caption-attachment-31492\" style=\"width: 381px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-loc-du-lieu-text-vd1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31492\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-loc-du-lieu-text-vd1.png\" alt=\"Advanced Filter l\u1ecdc chu\u1ed7i ch\u00ednh x\u00e1c\" width=\"381\" height=\"260\" title=\"advanced-filter-loc-du-lieu-text-vd1\"><\/a><figcaption id=\"caption-attachment-31492\" class=\"wp-caption-text\">Advanced Filter l\u1ecdc chu\u1ed7i ch\u00ednh x\u00e1c<\/figcaption><\/figure>\n<h4><span class=\"ez-toc-section\" id=\"Vi_du_2_Loc_du_lieu_text_bat_dau_boi\"><\/span>V\u00ed d\u1ee5 2. L\u1ecdc d\u1eef li\u1ec7u text b\u1eaft \u0111\u1ea7u b\u1edfi<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>L\u1ecdc ra nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u1ed9t S\u1ea3n Ph\u1ea9m c\u00f3 gi\u00e1 tr\u1ecb b\u1eaft \u0111\u1ea7u b\u1edfi ch\u1eef <strong>C<\/strong><\/p>\n<figure id=\"attachment_31493\" aria-describedby=\"caption-attachment-31493\" style=\"width: 362px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-bat-dau-boi.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31493\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-bat-dau-boi.png\" alt=\"L\u1ecdc d\u1eef li\u1ec7u b\u1eaft \u0111\u1ea7u b\u1edfi\" width=\"362\" height=\"248\" title=\"advanced-filter-bat-dau-boi\"><\/a><figcaption id=\"caption-attachment-31493\" class=\"wp-caption-text\">L\u1ecdc d\u1eef li\u1ec7u b\u1eaft \u0111\u1ea7u b\u1edfi<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_cong_thuc_trong_vung_dieu_kien_Advanced_Filter\"><\/span>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y th\u1ef1c s\u1ef1 l\u00e0 t\u00ednh n\u0103ng m\u00e0 m\u00ecnh th\u00edch nh\u1ea5t khi s\u1eed d\u1ee5ng Advanced Filter v\u00e0 \u0111\u00e2y c\u0169ng l\u00e0 ch\u1ee9c n\u0103ng m\u00e0 AutoFilter kh\u00f4ng c\u00f3, \u0111\u00f3 ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Advanced Filter. \u0110\u1ec3 Advanced Filter ho\u1ea1t \u0111\u1ed9ng \u0111\u00fang, ch\u00fang ta c\u1ea7n l\u01b0u \u00fd nh\u01b0 sau:<\/p>\n<ul style=\"list-style-type: square\">\n<li>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng cho v\u00f9ng \u0111i\u1ec1u ki\u1ec7n tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 TRUE ho\u1eb7c FALSE<\/li>\n<li>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n bao g\u1ed3m \u00edt nh\u1ea5t 2 \u00f4: \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 \u00f4 ti\u00eau \u0111\u1ec1<\/li>\n<li>\u00d4 ti\u00eau \u0111\u1ec1 c\u1ee7a v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i c\u00f3 n\u1ed9i dung kh\u00e1c v\u1edbi ti\u00eau \u0111\u1ec1 c\u00e1c c\u1ed9t trong v\u00f9ng d\u1eef li\u1ec7u<\/li>\n<li>N\u1ebfu c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng cho m\u1ed7i d\u00f2ng d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tham chi\u1ebfu t\u1edbi d\u00f2ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean trong v\u00f9ng d\u1eef li\u1ec7u<\/li>\n<li>Tham chi\u1ebfu t\u1edbi v\u00f9ng d\u1eef li\u1ec7u lu\u00f4n l\u00e0 tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i (n\u00ean \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u \u2013\u00a0s\u1eed d\u1ee5ng\u00a0<em>Named Range)<\/em><\/li>\n<\/ul>\n<p>Trong v\u00ed d\u1ee5 sau, ch\u00fang ta c\u1ea7n l\u1ecdc ra c\u00e1c d\u00f2ng d\u1eef li\u1ec7u m\u00e0 doanh thu th\u00e1ng 7 l\u1edbn h\u01a1n doanh thu th\u00e1ng 8. V\u00f9ng \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp v\u1edbi c\u00f4ng th\u1ee9c\u00a0<strong>=C7&gt;D7\u00a0<\/strong>nh\u01b0 trong h\u00ecnh, v\u00e0 d\u00f2ng th\u1ee9 7 c\u0169ng l\u00e0 d\u00f2ng \u0111\u1ea7u ti\u00ean trong v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n<figure id=\"attachment_31494\" aria-describedby=\"caption-attachment-31494\" style=\"width: 358px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-su-dung-cong-thuc-trong-dieu-kien.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31494\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-su-dung-cong-thuc-trong-dieu-kien.png\" alt=\"S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n\" width=\"358\" height=\"266\" title=\"advanced-filter-su-dung-cong-thuc-trong-dieu-kien\"><\/a><figcaption id=\"caption-attachment-31494\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_voi_dieu_kien_VA\"><\/span>Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n V\u00c0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong h\u00ecnh minh ho\u1ea1 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n V\u00c0 v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft tr\u00ean c\u00f9ng 1 d\u00f2ng.<\/p>\n<figure id=\"attachment_31495\" aria-describedby=\"caption-attachment-31495\" style=\"width: 406px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-and-logic.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31495\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-and-logic.png\" alt=\"Advanced Filter v\u00e0 \u0111i\u1ec1u ki\u1ec7n V\u00c0\" width=\"406\" height=\"239\" title=\"advanced-filter-and-logic\"><\/a><figcaption id=\"caption-attachment-31495\" class=\"wp-caption-text\">Advanced Filter v\u00e0 \u0111i\u1ec1u ki\u1ec7n V\u00c0<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_voi_dieu_kien_HOAC\"><\/span>Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong h\u00ecnh minh ho\u1ea1 d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft tr\u00ean nhi\u1ec1u d\u00f2ng kh\u00e1c nhau<\/p>\n<figure id=\"attachment_31496\" aria-describedby=\"caption-attachment-31496\" style=\"width: 405px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/advanced-filter-dieu-kien-hoac.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31496\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-dieu-kien-hoac.png\" alt=\"Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C\" width=\"405\" height=\"240\" title=\"advanced-filter-dieu-kien-hoac\"><\/a><figcaption id=\"caption-attachment-31496\" class=\"wp-caption-text\">Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_voi_dieu_kien_hon_hop\"><\/span>Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n h\u1ed7n h\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u1ea3 \u0111i\u1ec1u ki\u1ec7n V\u00c0 v\u00e0 \u0111i\u1ec1u ki\u1ec7n HO\u1eb6C nh\u01b0 sau<\/p>\n<figure id=\"attachment_31497\" aria-describedby=\"caption-attachment-31497\" style=\"width: 382px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/02\/Advanced-filter-dieu-kien-hon-hop.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-31497\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/advanced-filter-dieu-kien-hon-hop.png\" alt=\"Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n h\u1ed7n h\u1ee3p\" width=\"382\" height=\"217\" title=\"advanced-filter-dieu-kien-hon-hop\"><\/a><figcaption id=\"caption-attachment-31497\" class=\"wp-caption-text\">Advanced Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n h\u1ed7n h\u1ee3p<\/figcaption><\/figure>\n<p>\u0110i\u1ec1u ki\u1ec7n n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecdc ra l\u00e0: l\u1ecdc d\u1eef li\u1ec7u c\u1ee7a<\/p>\n<p>(v\u00f9ng Mi\u1ec1n B\u1eafc <strong>v\u00e0<\/strong> Sub-total &gt;= 900) <strong>ho\u1eb7c <\/strong>\u00a0(v\u00f9ng Mi\u1ec1n B\u1eafc <strong>v\u00e0<\/strong> Trung b\u00ecnh &gt;=300)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Advanced_Filter_de_sap_xep_lai_cac_cot_trong_bang_du_lieu\"><\/span>Advanced Filter \u0111\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t C\u00e1ch s\u1eed d\u1ee5ng Advanced Filter r\u1ea5t hay m\u00e0 m\u00ecnh r\u1ea5t th\u00edch v\u00e0 hay s\u1eed d\u1ee5ng l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u r\u1ea5t nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i video sau \u0111\u00e2y c\u1ee7a \u0110T Nguy\u1ec5n<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/HOholNrluzA\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><em><strong> Advanced Filter<\/strong> l\u00e0 m\u1ed9t h\u00e0m m\u1edbi nh\u01b0ng \u1ee9ng d\u1ee5ng kh\u00e1 tuy\u1ec7t v\u1eddi. <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>xin ch\u00fac c\u00e1c b\u1ea1n nhanh ch\u00f3ng l\u00e0m ch\u1ee7 <strong>c\u00e1ch s\u1eed d\u1ee5ng Advanced Filter<\/strong> s\u1edbm nh\u1ea5t.\u00a0<\/em><\/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-279.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3611,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3610","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\/3610","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=3610"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3610\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3611"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}