{"id":7752,"date":"2024-12-21T18:23:48","date_gmt":"2024-12-21T18:23:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-filter-tra-ket-qua-thoa-man-mot-trong-nhieu-dieu-kien\/"},"modified":"2024-12-21T18:23:48","modified_gmt":"2024-12-21T18:23:48","slug":"huong-dan-su-dung-ham-filter-tra-ket-qua-thoa-man-mot-trong-nhieu-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-filter-tra-ket-qua-thoa-man-mot-trong-nhieu-dieu-kien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Khi\u00a0<strong>Office 365<\/strong> c\u1eadp nh\u1eadt phi\u00ean b\u1ea3n m\u1edbi v\u00e0o n\u0103m ngo\u00e1i, m\u1ed9t lo\u1ea1t t\u00ednh n\u0103ng v\u1ec1\u00a0<strong>h\u00e0m m\u1ea3ng \u0111\u1ed9ng \u2013 dynamic array formulas\u00a0<\/strong>\u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o c\u00f9ng v\u1edbi \u0111\u00f3 l\u00e0 s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a c\u00e1c h\u00e0m m\u1edbi. M\u1ed9t trong s\u1ed1 \u0111\u00f3, <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\"><strong>h\u00e0m\u00a0<\/strong><\/a><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\"><strong>FILTER<\/strong><\/a><strong>\u00a0<\/strong>s\u1ebd thay th\u1ebf to\u00e0n b\u1ed9 nh\u1eefng thao t\u00e1c l\u1ecdc m\u00e0 tr\u01b0\u1edbc \u0111\u00e2y ph\u1ea3i s\u1eed d\u1ee5ng qua <strong>Filt<\/strong><strong>e<\/strong><strong>r<\/strong> ho\u1eb7c <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>. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong\u00a0nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/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-676707b35c0d2\" 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\/filter-thoa-man-mot-trong-nhieu-dieu-kien.html#Ham_FILTER_trong_Excel_365\" title=\"H\u00e0m FILTER trong Excel 365\">H\u00e0m FILTER trong Excel 365<\/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\/filter-thoa-man-mot-trong-nhieu-dieu-kien.html#Su_dung_ham_FILTER_tra_ket_qua_thoa_man_mot_trong_nhieu_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_FILTER_trong_Excel_365\"><\/span>H\u00e0m FILTER trong Excel 365<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m FILTER \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p><em><strong>=FILTER(array,include,[if_empty])<\/strong><\/em><\/p>\n<\/blockquote>\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=\"Su_dung_ham_FILTER_tra_ket_qua_thoa_man_mot_trong_nhieu_dieu_kien\"><\/span>S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta \u0111\u1ebfn v\u1edbi v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30646 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-1-trong-nhieu-dieu-kien-1-2.png\" alt=\"ham-filter-1-trong-nhieu-dieu-kien-1\" width=\"310\" height=\"448\" title=\"ham-filter-1-trong-nhieu-dieu-kien-1-2\"><\/p>\n<p>Y\u00eau c\u1ea7u: L\u1ecdc ra nh\u1eefng m\u1eb7t h\u00e0ng\u00a0lo\u1ea1i\u00a0<strong>A<\/strong>\u00a0<i>ho\u1eb7c<\/i>\u00a0<strong>B<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<p>V\u1edbi y\u00eau c\u1ea7u n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>FILTER<\/strong> l\u1ea5y ra\u00a0<strong>\u0111\u1ed3ng th\u1eddi<\/strong> c\u00e1c \u00f4 ch\u1ee9a\u00a0s\u1ea3n ph\u1ea9m thu\u1ed9c lo\u1ea1i o\u1ea1i\u00a0<strong>A + B<\/strong> nh\u01b0 sau:<\/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-696.gif\" title=\"ex101_92019-nho-696\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p class=\"excel geshifilter-excel\"><span class=\"sy1\">=<\/span><span class=\"kw4\">FILTER<\/span><span class=\"sy0\">(v\u00f9ng c\u1ea7n l\u1ecdc<\/span><span class=\"sy0\">,(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 1<\/span><span class=\"sy1\">=<\/span><span class=\"st0\">\u201c\u0111i\u1ec1u ki\u1ec7n 1\u201d<\/span><span class=\"sy0\">)<\/span><span class=\"sy1\">+<\/span><span class=\"sy0\">(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 1<\/span><span class=\"sy1\">=<\/span><span class=\"st0\">\u201c\u0111i\u1ec1u ki\u1ec7n 2\u201d<\/span><span class=\"sy0\">),<\/span><span class=\"st0\">\u201cKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d<\/span><span class=\"sy0\">)<\/span><\/p>\n<p class=\"excel geshifilter-excel\">C\u1ee5 th\u1ec3:<\/p>\n<p class=\"excel geshifilter-excel\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30647 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-1-trong-nhieu-dieu-kien-2.png\" alt=\"ham-filter-1-trong-nhieu-dieu-kien-2\" width=\"728\" height=\"496\" title=\"ham-filter-1-trong-nhieu-dieu-kien-2\"><\/p>\n<p class=\"excel geshifilter-excel\">V\u1eady l\u00e0 ta \u0111\u00e3 ti\u1ebfn h\u00e0nh xong thao t\u00e1c l\u1ecdc ra gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Trong b\u00e0i vi\u1ebft ti\u1ebfp theo, ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch\u00a0<em><strong>l\u1ecdc d\u1eef li\u1ec7u th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/em> v\u1edbi h\u00e0m FILTER.<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-chi-tiet-tu-dong-voi-ham-filter-trong-excel.html\"><strong>L\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng v\u1edbi h\u00e0m FILTER<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/loc-ra-danh-sach-duy-nhat-voi-advanced-filter.html\">L\u1ecdc ra danh s\u00e1ch duy nh\u1ea5t v\u1edbi ADVANCED FILTER<\/a><\/strong><\/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-696.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7752","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\/7752","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=7752"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7753"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}