{"id":7709,"date":"2024-12-21T18:18:37","date_gmt":"2024-12-21T18:18:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-filter-nhieu-dieu-kien-tra-ket-qua-hon-hop\/"},"modified":"2024-12-21T18:18:37","modified_gmt":"2024-12-21T18:18:37","slug":"huong-dan-su-dung-ham-filter-nhieu-dieu-kien-tra-ket-qua-hon-hop","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-ham-filter-nhieu-dieu-kien-tra-ket-qua-hon-hop\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FILTER nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u1ea3 k\u1ebft qu\u1ea3 h\u1ed7n h\u1ee3p"},"content":{"rendered":"
\n

L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 h\u1ed7n h\u1ee3p b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong>? B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n.<\/em><\/p>\n

H\u00e0m FILTER nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u1ea3 k\u1ebft qu\u1ea3 h\u1ed7n h\u1ee3p<\/h2>\n

Trong 2 b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ta \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m FILTER<\/strong><\/a> tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<\/p>\n

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<\/a><\/strong><\/p>\n

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<\/a><\/strong><\/p>\n

Ta v\u1eabn s\u1eed d\u1ee5ng d\u1eef li\u1ec7u c\u0169 sau:<\/p>\n

\"huong-dan-su-dung-ham-filter-nhieu-dieu-kien-1\"<\/p>\n

Y\u00eau c\u1ea7u l\u1ea7n n\u00e0y l\u00e0: L\u1ecdc ra nh\u1eefng s\u1ea3n ph\u1ea9m\u00a0B\u00fat bi<\/strong> lo\u1ea1i\u00a0A<\/strong>\u00a0ho\u1eb7c<\/em>\u00a0B.<\/strong><\/p>\n

\u0110\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n 2 y\u00eau c\u1ea7u tr\u00ean, ta s\u1ebd ti\u1ebfn h\u00e0nh k\u1ebft h\u1ee3p 2 thao t\u00e1c \u0111\u00e3 s\u1eed d\u1ee5ng trong 2 b\u00e0i tr\u01b0\u1edbc.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

C\u00f4ng th\u1ee9c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau:<\/p>\n

=<\/span>FILTER<\/span>(v\u00f9ng c\u1ea7n l\u1ecdc<\/span>,(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 1<\/span>=<\/span>\u201c\u0111i\u1ec1u ki\u1ec7n 1\u201d<\/span>)*<\/span>(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 2<\/span>=<\/span>\u201c\u0111i\u1ec1u ki\u1ec7n 2\u201d<\/span>)+(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 1=\u201d\u0111i\u1ec1u ki\u1ec7n 1\u2033)*(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 2=\u201d\u0111i\u1ec1u ki\u1ec7n 3\u2033),<\/span>\u201cKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d<\/span>)<\/span><\/em><\/p>\n

Ho\u1eb7c vi\u1ebft g\u1ecdn l\u1ea1i:<\/p>\n

=FILTER(v\u00f9ng c\u1ea7n l\u1ecdc,(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 1=\u201d\u0111i\u1ec1u ki\u1ec7n 1\u2033)*((v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 2=\u201d\u0111i\u1ec1u ki\u1ec7n 2\u2033)+(v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u 2=\u201d\u0111i\u1ec1u ki\u1ec7n 3\u2033)),\u201dKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d)<\/strong><\/em><\/p>\n

C\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta s\u1ebd thay c\u00e1c v\u00f9ng v\u00e0o nh\u01b0 sau:<\/p>\n

=FILTER(A2:B15,(A2:A15=\u201dB\u00fat bi\u201d)*((B2:B15=\u201dA\u201d)+(B2:B15=\u201dB\u201d)),\u201dKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d)<\/strong><\/p>\n

K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n

\"huong-dan-su-dung-ham-filter-nhieu-dieu-kien-2\"<\/p>\n

\u00a0<\/p>\n

M\u1edf r\u1ed9ng h\u01a1n, ta c\u00f3 y\u00eau c\u1ea7u sau:\u00a0L\u1ecdc ra nh\u1eefng s\u1ea3n ph\u1ea9m\u00a0B\u00fat bi<\/strong>\u00a0<\/strong>ho\u1eb7c\u00a0<\/em>Th\u01b0\u1edbc k\u1ebb<\/strong>,\u00a0lo\u1ea1i\u00a0A<\/strong>\u00a0ho\u1eb7c<\/em>\u00a0B.<\/strong><\/p>\n

\u0110\u1ebfn \u0111\u00e2y, ch\u1eafc h\u1eb3n ta \u0111\u1ec1u \u0111\u00e3 nh\u00ecn ra quy lu\u1eadt k\u1ebft h\u1ee3p \u0111i\u1ec1u ki\u1ec7n trong h\u00e0m FILTER r\u1ed3i. \u0110\u1ed1i v\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng\u00a0V\u00c0 (AND)<\/strong>, ta s\u1eed d\u1ee5ng ph\u00e9p nh\u00e2n \u0111\u1ec3 li\u00ean k\u1ebft (th\u1ecfa m\u00e3n \u0111\u1ed3ng th\u1eddi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/em>). Ng\u01b0\u1ee3c l\u1ea1i, v\u1edbi nh\u1eefng \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng\u00a0HO\u1eb6C (OR)<\/strong>, ta li\u00ean k\u1ebft b\u1edfi ph\u00e9p c\u1ed9ng (th\u1ecfa m\u00e3n m\u1ed9t trong nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/em>).<\/p>\n

Vi\u1ebft ng\u1eafn g\u1ecdn h\u01a1n, \u0111i\u1ec1u ki\u1ec7n ta c\u1ea7n c\u00f3 \u1edf \u0111\u00e2y l\u00e0:\u00a0(B\u00fat bi + Th\u01b0\u1edbc k\u1ebb)*(A+B)<\/strong><\/p>\n

K\u1ebft qu\u1ea3:<\/p>\n

=FILTER(A2:B15,((A2:A15=\u201dB\u00fat bi\u201d)+(A2:A15=\u201dTh\u01b0\u1edbc k\u1ebb\u201d))*((B2:B15=\u201dA\u201d)+(B2:B15=\u201dB\u201d)),\u201dKh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 th\u1ecfa m\u00e3n\u201d)<\/strong><\/em><\/p>\n

\"huong-dan-su-dung-ham-filter-nhieu-dieu-kien-3\"<\/p>\n

\n

Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau trong kh\u00f3a h\u1ecdc Excel k\u1ebf to\u00e1n<\/strong><\/a> c\u1ee7a ch\u00fang t\u00f4i:<\/p>\n

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FILTER<\/strong><\/a><\/p>\n

L\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft t\u1ef1 \u0111\u1ed9ng v\u1edbi h\u00e0m FILTER<\/strong><\/a><\/p>\n

L\u1ecdc d\u1eef li\u1ec7u theo ng\u00e0y th\u00e1ng v\u1edbi h\u00e0m FILTER<\/strong><\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7710,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7709","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\/7709","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=7709"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7709\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7710"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}