{"id":7733,"date":"2024-12-21T18:20:37","date_gmt":"2024-12-21T18:20:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-filter-tra-ket-qua-thoa-man-dong-thoi-nhieu-dieu-kien\/"},"modified":"2024-12-21T18:20:37","modified_gmt":"2024-12-21T18:20:37","slug":"huong-dan-su-dung-ham-filter-tra-ket-qua-thoa-man-dong-thoi-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-dong-thoi-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 \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch\u00a0<strong>s\u1eed d\u1ee5ng FILTER\u00a0tr\u1ea3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong>. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch\u00a0tr\u1ea3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\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-676706f4900e7\" 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-dong-thoi-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-dong-thoi-nhieu-dieu-kien.html#Su_dung_ham_FILTER_tra_ket_qua_thoa_man_dong_thoi_nhieu_dieu_kien\" title=\"S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n\">S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi 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>Tr\u01b0\u1edbc khi \u0111i v\u00e0o v\u00ed d\u1ee5, h\u00e3y nh\u1eafc l\u1ea1i c\u00f4ng th\u1ee9c c\u1ee7a FILTER m\u1ed9t l\u1ea7n n\u1eefa:<\/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_dong_thoi_nhieu_dieu_kien\"><\/span>S\u1eed d\u1ee5ng h\u00e0m FILTER tr\u1ea3\u00a0k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi b\u00e0i tr\u01b0\u1edbc, v\u00ed d\u1ee5 l\u1ea7n n\u00e0y c\u1ee7a ta nh\u01b0 sau:<\/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-1.png\" alt=\"ham-filter-1-trong-nhieu-dieu-kien-1\" width=\"310\" height=\"448\" title=\"ham-filter-1-trong-nhieu-dieu-kien-1-1\"><\/p>\n<p>Y\u00eau c\u1ea7u: L\u1ecdc ra nh\u1eefng s\u1ea3n ph\u1ea9m\u00a0<strong>B\u00fat bi<\/strong> lo\u1ea1i\u00a0<strong>A<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<p>V\u1edbi y\u00eau c\u1ea7u n\u00e0y, h\u00e0m FILTER ta \u0111\u1eb7t trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u00f3 c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t 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-694.gif\" title=\"ex101_92019-nho-694\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><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=\"sy0\">(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 2<\/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>C\u1ee5 th\u1ec3, \u0111i\u1ec1u ki\u1ec7n 1 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0\u00a0<strong>B\u00fat bi<\/strong>, c\u00f2n \u0111i\u1ec1u ki\u1ec7n 2 l\u00e0 lo\u1ea1i\u00a0<strong>A<\/strong>.<\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3 \u0111\u01b0\u1ee3c \u1edf h\u00ecnh d\u01b0\u1edbi:<\/p>\n<p><em>=FILTER(A2:B15,(A2:A15=\u201dB\u00fat bi\u201d)*(B2:B15=\u201dA\u201d),\u201dKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30653 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-thoa-man-dong-thoi-1.png\" alt=\"ham-filter-1-trong-nhieu-dieu-kien-2\" width=\"759\" height=\"495\" title=\"ham-filter-thoa-man-dong-thoi-1\"><\/p>\n<p>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 \u0111\u1ed3ng th\u1eddi\u00a0nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean c\u00f2n nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p \u1ee9ng d\u1ee5ng kh\u00e1c c\u1ee7a h\u00e0m FILTER m\u00e0 ta s\u1ebd t\u00ecm hi\u1ec3u trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u01b0 c\u00e1ch\u00a0<em><strong>l\u1ecdc d\u1eef li\u1ec7u h\u1ed7n h\u1ee3p k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/strong><\/em><\/p>\n<hr>\n<p>Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FILTER<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-tinh-lai-tu-dong-volatile-functions.html\"><strong>C\u00e1c h\u00e0m t\u1ef1 t\u00ednh to\u00e1n l\u1ea1i trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/loc-du-lieu-theo-quy-trong-excel.html\"><strong>L\u1ecdc d\u1eef li\u1ec7u theo ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m FILTER<\/strong><\/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-694.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7733","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\/7733","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=7733"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7734"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}