{"id":1869,"date":"2024-12-02T06:20:34","date_gmt":"2024-12-02T06:20:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365\/"},"modified":"2024-12-02T06:20:34","modified_gmt":"2024-12-02T06:20:34","slug":"huong-dan-cach-su-dung-ham-filter-trong-excel-office-365","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel Office 365"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>N\u1ebfu nh\u01b0 tr\u01b0\u1edbc \u0111\u00e2y khi mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u v\u00e0 k\u1ebft xu\u1ea5t d\u1eef li\u1ec7u ra m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c th\u00ec ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 Filter, Advanced Filter, c\u00f4ng th\u1ee9c m\u1ea3ng. Tuy nhi\u00ean nh\u1eefng c\u00f4ng vi\u1ec7c n\u00e0y khi\u1ebfn ch\u00fang ta t\u1ed1n nhi\u1ec1u thao t\u00e1c, nhi\u1ec1u th\u1eddi gian v\u00e0\u00a0\u0111\u00f4i khi kh\u00f3\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n. C\u00f3 ph\u1ea3i b\u1ea1n mong mu\u1ed1n c\u00f3 1 h\u00e0m trong\u00a0Excel gi\u00fap l\u00e0m vi\u1ec7c n\u00e0y th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n, th\u1eadt d\u1ec5 d\u00e0ng? Tin vui l\u00e0\u00a0Office 365\u00a0\u0111\u00e3 cung c\u1ea5p cho ch\u00fang ta <strong>h\u00e0m Filter<\/strong>\u00a0\u0111\u1ec3 l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y. V\u1eady h\u00e0m n\u00e0y c\u00f3 g\u00ec\u00a0\u0111\u1eb7c bi\u1ec7t v\u00e0 c\u00e1ch d\u00f9ng n\u00f3 nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> kh\u00e1m ph\u00e1 n\u00e0o.<\/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-674d51b1712c7\" 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\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Cau_truc_ham_Filter_Filter_function\" title=\"C\u1ea5u tr\u00fac h\u00e0m Filter (Filter function)\">C\u1ea5u tr\u00fac h\u00e0m Filter (Filter function)<\/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\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Cau_truc_cua_ham\" title=\"C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m:\">C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m:<\/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\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Nhung_chu_y_ve_dac_diem_cua_ham\" title=\"Nh\u1eefng ch\u00fa\u00a0\u00fd v\u1ec1 \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a h\u00e0m:\">Nh\u1eefng ch\u00fa\u00a0\u00fd v\u1ec1 \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a h\u00e0m:<\/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\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Nhung_truong_hop_xay_ra_loi\" title=\"Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i\">Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Ham_FILTER_%E2%80%93_cac_vi_du\" title=\"H\u00e0m FILTER \u2013 c\u00e1c v\u00ed d\u1ee5\">H\u00e0m FILTER \u2013 c\u00e1c v\u00ed d\u1ee5<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Loc_theo_1_dieu_kien\" title=\"L\u1ecdc theo 1 \u0111i\u1ec1u ki\u1ec7n\">L\u1ecdc theo 1 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Loc_theo_nhieu_dieu_kien\" title=\"L\u1ecdc theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">L\u1ecdc theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#Ham_Filter_co_gi_dac_biet\" title=\"H\u00e0m Filter c\u00f3 g\u00ec\u00a0\u0111\u1eb7c bi\u1ec7t\">H\u00e0m Filter c\u00f3 g\u00ec\u00a0\u0111\u1eb7c bi\u1ec7t<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#So_voi_AutoFilter_giam_thoi_gian_thao_tac\" title=\"So v\u1edbi AutoFilter: gi\u1ea3m th\u1eddi gian thao t\u00e1c\">So v\u1edbi AutoFilter: gi\u1ea3m th\u1eddi gian thao t\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#So_voi_Advanced_Filter_tu_dong_hoan_toan_khong_can_VBA_va_hon_the_nua\" title=\"So v\u1edbi Advanced Filter: t\u1ef1\u00a0\u0111\u1ed9ng ho\u00e0n to\u00e0n kh\u00f4ng c\u1ea7n VBA v\u00e0 h\u01a1n th\u1ebf n\u1eefa\">So v\u1edbi Advanced Filter: t\u1ef1\u00a0\u0111\u1ed9ng ho\u00e0n to\u00e0n kh\u00f4ng c\u1ea7n VBA v\u00e0 h\u01a1n th\u1ebf n\u1eefa<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html#So_voi_cong_thuc_mang_Don_gian_hon_rat_nhieu\" title=\"So v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng:\u00a0\u0110\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u\">So v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng:\u00a0\u0110\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cau_truc_ham_Filter_Filter_function\"><\/span>C\u1ea5u tr\u00fac h\u00e0m Filter (Filter function)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y c\u00f3 t\u00e1c d\u1ee5ng l\u1ecdc d\u1eef li\u1ec7u\u00a0\u0111\u1ed3ng th\u1eddi k\u1ebft xu\u1ea5t d\u1eef li\u1ec7u l\u1ecdc\u00a0\u0111\u01b0\u1ee3c sang 1 v\u1ecb tr\u00ed kh\u00e1c (\u00f4 kh\u00e1c, sheet kh\u00e1c,\u00a0workbook kh\u00e1c).<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t \u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m Filter \u2013 ham loc gi\u00fap l\u1ecdc ra c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 t\u00ean l\u00e0 T\u00e1o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23161\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-su-dung-ham-filter.png\" width=\"591\" height=\"300\" title=\"ket-qua-su-dung-ham-filter\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cau_truc_cua_ham\"><\/span>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>=FILTER(array,include,[if_empty])<\/p>\n<ul>\n<li><strong>array<\/strong>: v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc (<em>kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 ti\u00eau\u00a0\u0111\u1ec1<\/em>)<\/li>\n<li><strong>include<\/strong>:\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n l\u1ecdc l\u00e0 g\u00ec, n\u1eb1m trong c\u1ed9t n\u00e0o (x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u1ed3ng th\u1eddi c\u1ea3 2 y\u1ebfu t\u1ed1\u00a0n\u00e0y)<\/li>\n<li><strong>if_empty<\/strong>:\u00a0N\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u00ec tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb g\u00ec? (kh\u00f4ng b\u1eaft bu\u1ed9c nh\u1eadp)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nhung_chu_y_ve_dac_diem_cua_ham\"><\/span>Nh\u1eefng ch\u00fa\u00a0\u00fd v\u1ec1 \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a h\u00e0m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau \u0111\u00e2y l\u00e0 nh\u1eefng ch\u00fa \u00fd v\u1ec1 <strong>ch\u1ee9c n\u0103ng filter trong excel<\/strong>:<\/p>\n<ul>\n<li>H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 <strong>d\u1ea1ng m\u1ea3ng<\/strong>, d\u1ef1a theo <strong>s\u1ed1 c\u1ed9t c\u1ee7a\u00a0array<\/strong> v\u00e0 <strong>s\u1ed1 d\u00f2ng k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c<\/strong><\/li>\n<li>Kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u.<\/li>\n<li>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 kh\u00f4ng k\u00e8m theo\u00a0\u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u g\u1ed1c<\/li>\n<li>Kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nhung_truong_hop_xay_ra_loi\"><\/span>Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Tr\u01b0\u1eddng h\u1ee3p 1<\/strong>: Kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 l\u1ecdc theo\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00eau ra<\/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-136.gif\" title=\"ex101_92019-nho-136\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>N\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 ph\u00f9 h\u1ee3p v\u00e0 kh\u00f4ng quy\u00a0\u0111\u1ecbnh t\u1ea1i\u00a0<strong>if_empty<\/strong>, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i <strong>#CALC!<\/strong> (kh\u00f4ng t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23162\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-khong-co-ket-qua-loc-ham-filter.png\" width=\"592\" height=\"298\" title=\"loi-khong-co-ket-qua-loc-ham-filter\"><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1ebd c\u1ea7n x\u00e1c\u00a0\u0111\u1ecbnh gi\u00e1 tr\u1ecb t\u1ea1i tham s\u1ed1\u00a0<strong>if_empty<\/strong>\u00a0l\u00e0 r\u1ed7ng (hai d\u1ea5u nh\u00e1y k\u00e9p li\u1ec1n nhau)\u00a0\u0111\u1ec3 kh\u00f4ng th\u1ec3 hi\u1ec7n l\u1ed7i, ho\u1eb7c th\u00f4ng b\u00e1o v\u1ec1 vi\u1ec7c kh\u00f4ng t\u00ecm th\u1ea5y k\u1ebft qu\u1ea3.<\/p>\n<p><strong>Tr\u01b0\u1eddng h\u1ee3p 2<\/strong>: C\u00f3 xen l\u1eabn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c trong v\u00f9ng k\u1ebft qu\u1ea3<\/p>\n<p>V\u00ec k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Filter tr\u1ea3 v\u1ec1 d\u1ea1ng m\u1ea3ng, n\u00ean khi c\u00f3 l\u1eabn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c trong v\u00f9ng n\u00e0y (do ng\u01b0\u1eddi d\u00f9ng t\u1ef1 nh\u1eadp v\u00e0o)\u00a0th\u00ec s\u1ebd b\u00e1o l\u1ed7i #SPILL! (k\u1ebft qu\u1ea3 s\u1ebd tr\u00e0n l\u00ean d\u1eef li\u1ec7u\u00a0\u0111\u00e3 c\u00f3)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23163\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-co-xen-lan-noi-dung-khac-trong-vung-ket-qua-ham-filter.png\" width=\"717\" height=\"302\" title=\"loi-co-xen-lan-noi-dung-khac-trong-vung-ket-qua-ham-filter\"><\/p>\n<p>Do\u00a0\u0111\u00f3 khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y c\u1ea7n\u00a0\u0111\u1ea3m b\u1ea3o kho\u1ea3ng tr\u1ed1ng cho v\u00f9ng k\u1ebft qu\u1ea3, kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u n\u00e0o n\u1eb1m l\u1eabn v\u00e0o v\u00f9ng n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_FILTER_%E2%80%93_cac_vi_du\"><\/span><span style=\"font-size: 14pt\">H\u00e0m FILTER \u2013 c\u00e1c v\u00ed d\u1ee5<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Loc_theo_1_dieu_kien\"><\/span><span style=\"font-size: 12pt\">L\u1ecdc theo 1 \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong \u1ea3nh v\u00ed d\u1ee5 \u1edf \u0111\u1ea7u b\u00e0i vi\u1ebft, c\u00f4ng th\u1ee9c trong \u00f4 G5 l\u00e0<\/p>\n<p><code class=\"excel-formula\">=FILTER(B5:D13,D5:D13=H2,\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 di\u1ec5n gi\u1ea3i c\u00f4ng th\u1ee9c n\u00e0y ra m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u l\u00e0: l\u1ecdc trong v\u00f9ng B5:D13 nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t D c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 Red.<\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c tr\u00ean nh\u01b0 sau (vi\u1ebft \u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c)<\/p>\n<p><code class=\"excel-formula\">=FILTER(B5:D13,D5:D13=\"Red\",\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/p>\n<p>Tuy nhi\u00ean vi\u1ec7c vi\u1ebft \u0111i\u1ec1u ki\u1ec7n tr\u1ef1c ti\u1ebfp v\u00e0o c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 kh\u00f4ng n\u00ean, b\u1edfi v\u00ec khi \u0111i\u1ec1u ki\u1ec7n thay \u0111\u1ed5i, ch\u00fang ta ph\u1ea3i v\u00e0o trong c\u00f4ng th\u1ee9c \u0111\u1ec3 ch\u1ec9nh s\u1eeda. Do v\u1eady, vi\u1ec7c \u0111\u1ec3 \u0111i\u1ec1u ki\u1ec7n \u1edf 1 \u00f4 b\u00ean ngo\u00e0i c\u00f4ng th\u1ee9c, sau \u0111\u00f3 tham chi\u1ebfu t\u1edbi \u00f4 \u0111\u00f3 s\u1ebd gi\u00fap ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c linh ho\u1ea1t h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loc_theo_nhieu_dieu_kien\"><\/span><span style=\"font-size: 12pt\">L\u1ecdc theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u v\u1edbi h\u00e0m FILTER. Gi\u1ea3 s\u1eed, trong v\u00f9ng d\u1eef li\u1ec7u B5:D13, ch\u00fang ta mu\u1ed1n gi\u1eef l\u1ea1i nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u tho\u1ea3 m\u00e3n 2 ti\u00eau ch\u00ed sau \u0111\u00e2y c\u00f9ng l\u00fac:<\/p>\n<ul style=\"list-style-type: square\">\n<li>C\u1ed9t D c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 Red<\/li>\n<li>C\u1ed9t C c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 80<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0:<\/p>\n<p><code class=\"excel-formula\">=FILTER(B5:D13,(D5:D13=H2)*(C5:C13&gt;=80),\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/p>\n<p>C\u00e1ch vi\u1ebft v\u00e0 hi\u1ec3u \u0111o\u1ea1n\u00a0<code class=\"excel-formula\">(D5:D13=H2)*(C5:C13&gt;=80)<\/code> , b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam trong b\u00e0i vi\u1ebft v\u1ec1 SUMPRODUCT sau \u0111\u00e2y:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_Filter_co_gi_dac_biet\"><\/span>H\u00e0m Filter c\u00f3 g\u00ec\u00a0\u0111\u1eb7c bi\u1ec7t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ph\u1ea3i n\u00f3i l\u00e0 r\u1ea5t \u0111\u1eb7c bi\u1ec7t, r\u1ea5t tuy\u1ec7t v\u1eddi. N\u1ebfu nh\u01b0 b\u1ea1n \u0111\u00e3 t\u1eebng v\u1ea5t v\u1ea3 v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, t\u1ed1n th\u1eddi gian v\u1edbi ham loc Filter, kh\u00f3 ch\u1ecbu v\u1edbi k\u1ebft qu\u1ea3 c\u1ee7a Advanced Filter th\u00ec khi s\u1eed d\u1ee5ng h\u00e0m Filter s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c s\u1ef1 kh\u00e1c bi\u1ec7t r\u1ea5t l\u1edbn.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_voi_AutoFilter_giam_thoi_gian_thao_tac\"><\/span>So v\u1edbi AutoFilter: gi\u1ea3m th\u1eddi gian thao t\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu nh\u01b0 b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1c s\u1eed d\u1ee5ng Filter hay c\u00e1c t\u00ednh\u00a0n\u0103ng c\u1ee7a Filter th\u00ec c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-trong-excel.html\"><strong>C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/strong><\/a><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3\u00a0\u0111\u01b0a ra\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 cho b\u00e1o c\u00e1o chi ti\u1ebft, c\u00e1c thao t\u00e1c th\u01b0\u1eddng d\u00f9ng l\u00e0:<\/p>\n<ul>\n<li>\u00c1p d\u1ee5ng AutoFilter cho b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>L\u1ecdc d\u1eef li\u1ec7u theo t\u1eebng v\u1ecb tr\u00ed d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1<\/li>\n<li>Copy k\u1ebft qu\u1ea3 l\u1ecdc\u00a0\u0111\u01b0\u1ee3c<\/li>\n<li>D\u00e1n ph\u1ea7n gi\u00e1 tr\u1ecb\u00a0(Paste Special \/ Value) c\u1ee7a nh\u1eefng gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i sau khi l\u1ecdc v\u00e0o v\u1ecb tr\u00ed c\u1ea7n b\u00e1o c\u00e1o<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u thao t\u00e1c v\u00e0 t\u1ed1n th\u1eddi gian ph\u1ea3i kh\u00f4ng n\u00e0o.\u00a0\u0110\u1ec3 kh\u1eafc ph\u1ee5c nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m t\u1ed1n th\u1eddi gian v\u00e0 nhi\u1ec1u thao t\u00e1c n\u00e0y, ch\u00fang ta c\u00f3 th\u00eam AdvancedFilter, c\u00f3 c\u00f4ng th\u1ee9c m\u1ea3ng h\u1ed7 tr\u1ee3. Tuy nhi\u00ean nh\u1eefng c\u00f4ng c\u1ee5 n\u00e0y v\u1eabn c\u00f3 nh\u1eefng nh\u01b0\u1ee3c\u00a0\u0111i\u1ec3m.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_voi_Advanced_Filter_tu_dong_hoan_toan_khong_can_VBA_va_hon_the_nua\"><\/span>So v\u1edbi Advanced Filter: t\u1ef1\u00a0\u0111\u1ed9ng ho\u00e0n to\u00e0n kh\u00f4ng c\u1ea7n VBA v\u00e0 h\u01a1n th\u1ebf n\u1eefa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Advanced Filter l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00e1 t\u1ed1t\u00a0\u0111\u1ec3 tr\u00edch l\u1ecdc d\u1eef li\u1ec7u theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. L\u00fd do n\u00f3 ch\u1ec9 \u201ckh\u00e1 t\u1ed1t\u201d l\u00e0:<\/p>\n<ul>\n<li>Ti\u1ebft ki\u1ec7m th\u1eddi gian l\u1ecdc d\u1eef li\u1ec7u, nh\u01b0ng kh\u00f4ng t\u1ef1\u00a0\u0111\u1ed9ng ho\u00e0n to\u00e0n. N\u1ebfu mu\u1ed1n t\u1ef1\u00a0\u0111\u1ed9ng th\u00ec ph\u1ea3i\u00a0\u00e1p d\u1ee5ng th\u00eam VBA<\/li>\n<li>Kh\u00f4ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00ean kh\u00f4ng t\u1ed1n t\u00e0i nguy\u00ean, nh\u01b0ng vi\u1ec7c x\u00e2y d\u1ef1ng v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n c\u0169ng ph\u1ee9c t\u1ea1p.<\/li>\n<li>Ph\u1ee5 thu\u1ed9c ho\u00e0n to\u00e0n v\u00e0o ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. Do\u00a0\u0111\u00f3 n\u00f3 h\u1ea1n ch\u1ebf nhi\u1ec1u n\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 ti\u00eau\u00a0\u0111\u1ec1 s\u1ebd kh\u00f4ng l\u00e0m\u00a0\u0111\u00fang.<\/li>\n<li>K\u1ebft qu\u1ea3 l\u1ecdc mang\u00a0\u0111\u00fang\u00a0\u0111\u1ecbnh d\u1ea1ng c\u1ee7a d\u1eef li\u1ec7u g\u1ed1c.\u00a0\u0110i\u1ec1u n\u00e0y khi\u1ebfn ch\u00fang ta kh\u00f4ng th\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo\u00a0\u00fd mu\u1ed1n.<\/li>\n<\/ul>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 th\u1ea5y t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Advanced Filter:<\/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<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\/huong-dan-cach-loc-du-lieu-sang-sheet-khac-bang-advanced-filter-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u sang sheet kh\u00e1c b\u1eb1ng Advanced Filter trong Excel<\/a><\/p>\n<p>Do\u00a0\u0111\u00f3 khi s\u1eed d\u1ee5ng h\u00e0m Filter, ch\u00fang ta s\u1ebd th\u1ea5y kh\u00f4ng c\u1ea7n t\u1ea1o v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n, kh\u00f4ng c\u1ea7n c\u00f3 VBA, k\u1ebft qu\u1ea3\u00a0\u0111\u1ecbnh d\u1ea1ng theo\u00a0\u00fd mu\u1ed1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_voi_cong_thuc_mang_Don_gian_hon_rat_nhieu\"><\/span>So v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng:\u00a0\u0110\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta t\u1eebng bi\u1ebft t\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u1ea1ng m\u1ea3ng nh\u01b0 OFFSET \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o chi ti\u1ebft nh\u01b0 v\u1edbi b\u00e0i sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-viet-cong-thuc-lap-bao-cao-chi-tiet-tu-dong-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch vi\u1ebft c\u00f4ng th\u1ee9c l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng trong Excel<\/a><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c r\u1ea5t d\u00e0i v\u00e0 kh\u00f3. B\u1edfi v\u00ec ch\u00fang ta ph\u1ea3i th\u1ef1c hi\u1ec7n 2 y\u00eau c\u1ea7u\u00a0\u0111\u1ed3ng th\u1eddi trong 1\u00a0 c\u00e2u l\u1ec7nh:<\/p>\n<ul>\n<li>L\u1ecdc ra c\u00e1c k\u1ebft qu\u1ea3\u00a0\u0111\u00fang<\/li>\n<li>Tr\u00edch xu\u1ea5t c\u00e1c k\u1ebft qu\u1ea3 ra b\u00e1o c\u00e1o, m\u00e0 c\u00e1c n\u1ed9i dung ph\u1ea3i li\u1ec1n nhau<\/li>\n<\/ul>\n<p>V\u1edbi nh\u1eefng h\u00e0m\u00a0tr\u01b0\u1edbc\u00a0\u0111\u00e2y,\u00a0\u0111\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c tr\u00ean c\u1ea7n d\u00f9ng nhi\u1ec1u h\u00e0m, ph\u00e2n t\u00edch logic kh\u00e1 ph\u1ee9c t\u1ea1p. Nh\u01b0ng nay v\u1edbi h\u00e0m Filter, vi\u1ec7c n\u00e0y tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23164\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-nhieu-dieu-kien.png\" width=\"885\" height=\"386\" title=\"ham-filter-nhieu-dieu-kien\"><\/p>\n<p>\u0110\u00f3 l\u00e0 nh\u1eefng h\u01b0\u1edbng d\u1eabn s\u01a1 qua v\u1ec1 <strong>c\u00e1ch s\u1eed d\u1ee5ng filter trong Excel.<\/strong> Trong c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd gi\u00fap c\u00e1c b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o chi ti\u1ebft. C\u00e1c b\u1ea1n ch\u00fa \u00fd \u0111\u00f3n xem nh\u00e9.<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-136.gif\" title=\"ex101_92019-nho-136\"><\/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-136.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1870,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1869","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\/1869","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=1869"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1870"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}