{"id":4420,"date":"2024-12-05T07:03:32","date_gmt":"2024-12-05T07:03:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/advanced-filter-voi-criteria-range-la-mot-cau-dieu-kien\/"},"modified":"2024-12-05T07:03:32","modified_gmt":"2024-12-05T07:03:32","slug":"advanced-filter-voi-criteria-range-la-mot-cau-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/advanced-filter-voi-criteria-range-la-mot-cau-dieu-kien\/","title":{"rendered":"Advanced Filter v\u1edbi Criteria Range l\u00e0 m\u1ed9t c\u00e2u \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong c\u00f4ng vi\u1ec7c nhi\u1ec1u khi\u00a0ch\u00fang\u00a0ta c\u1ea7n ph\u1ea3i l\u1ea5y ra d\u1eef li\u1ec7u t\u1eeb Data g\u1ed1c theo nh\u1eefng\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau ph\u1ee5c v\u1ee5 cho vi\u1ec7c ki\u1ec3m tra, ph\u00e2n t\u00edch<\/p>\n<h1>Advanced Filter v\u1edbi Criteria Range l\u00e0 m\u1ed9t c\u00e2u \u0111i\u1ec1u ki\u1ec7n<\/h1>\n<p style=\"text-align: justify\"><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 m\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh \u0111\u01b0\u1ee3c Excel h\u1ed7 tr\u1ee3, gi\u00fap cho ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3\u00a0l\u1ea5y ra d\u1eef li\u1ec7u theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/p>\n<p style=\"text-align: justify\">Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 h\u00ecnh, v\u1edbi y\u00eau c\u1ea7u l\u00e0 l\u1ea5y ra th\u00f4ng tin c\u1ee7a nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f3 s\u1ed1 l\u01b0\u1ee3ng <strong>&gt;50<\/strong> v\u00e0 doanh thu <strong>&gt;=60.000<\/strong>. V\u1edbi\u00a0y\u00eau c\u1ea7u \u0111\u00f3\u00a0ta s\u1ebd s\u1eed d\u1ee5ng\u00a0h\u00e0m AND\u00a0\u0111\u1ec3 k\u1ebft h\u1ee3p 2\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u0111\u00f3 l\u1ea1i trong 1 c\u00f4ng th\u1ee9c, v\u00e0 l\u1ea5y n\u00f3 l\u00e0m Criteria Range<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u\u00a0\u00fd:<\/strong> Ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t t\u00ean b\u1ea5t k\u1ef3 tuy nhi\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng (\u1edf\u00a0\u0111\u00e2y m\u00ecnh ghi l\u00e0 DKTL \u2013\u00a0\u0110i\u1ec1u Ki\u1ec7n Tr\u00edch L\u1ecdc)<\/p>\n<p style=\"text-align: justify\">T\u1ea1i m\u1ed9t\u00a0\u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh\u00a0Excel b\u1ea1n g\u00f5 v\u00e0o h\u00e0m nh\u01b0 sau v\u00e0\u00a0\u0111\u1eebng qu\u00ean\u00a0\u0111\u1eb7t cho n\u00f3 1 c\u00e1i ti\u00eau\u00a0\u0111\u1ec1<\/p>\n<blockquote>\n<p><strong>=AND(B5&gt;50,C5&gt;=60000)<\/strong><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28376\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-8-1024x576-1.png\" width=\"1024\" height=\"576\" title=\"1-8-1024x576-1\"><\/p>\n<p style=\"text-align: justify\">T\u1ea1i h\u1ed9p tho\u1ea1i Advanced Filter:<\/p>\n<ul style=\"list-style-type: disc;text-align: justify\">\n<li><strong>List range:<\/strong> ban ch\u1ecdn v\u00f9ng t\u1eeb A4:C16<\/li>\n<li><strong>Criteria range:<\/strong> b\u1ea1n ch\u1ecdn v\u00f9ng ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n tr\u00edch l\u1ecdc (\u1edf\u00a0\u0111\u00e2y l\u00e0 v\u00f9ng E4:E5)<\/li>\n<li><strong>Copy to:<\/strong> b\u1ea1n ch\u1ecdn v\u1ecb tr\u00ed\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 v\u1ec1 k\u1ebft qu\u1ea3\u00a0 sau khi tr\u00edch l\u1ecdc (b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ecdn v\u00f9ng n\u00e0y n\u1ebfu m\u1ee5c <strong>Action<\/strong> l\u00e0 <em>Copy to another location<\/em>)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Ngo\u00e0i ra b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u tr\u00ean v\u1edbi Criteria range nh\u01b0 sau:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/07\/2-8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28378\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-8-3.png\" width=\"433\" height=\"131\" title=\"2-8-3\"><\/a>H\u1ecdc\u00a0Excel Online hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y\u00a0\u0111\u00e3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 n\u1eafm\u00a0\u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m AND trong Criteria range khi\u00a0s\u1eed d\u1ee5ng Advanced Filter\u00a0trong tr\u01b0\u1eddng h\u1ee3p\u00a0c\u1ea7n tr\u00edch l\u1ecdc d\u1eef li\u1ec7u th\u1ea3o m\u00e3n\u00a0\u0111\u1ed3ng th\u1eddi c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau.<\/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-358.gif\" title=\"ex101_92019-nho-358\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<hr>\n<p>\u00a0<\/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-358.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4421,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4420","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\/4420","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=4420"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4420\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4421"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}