{"id":9080,"date":"2025-01-01T13:36:51","date_gmt":"2025-01-01T13:36:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc\/"},"modified":"2025-01-01T13:36:51","modified_gmt":"2025-01-01T13:36:51","slug":"huong-dan-so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn so s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch so s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc. T\u1eeb v\u00ed d\u1ee5 n\u00e0y, ta c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng ra cho nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p h\u01a1n trong th\u1ef1c t\u1ebf.<\/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-677544f324a01\" 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\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html#So_sanh_ki_tu_dau_tien_cua_chuoi_voi_dieu_kien_cho_truoc\" title=\"So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc\">So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html#Cong_thuc\" title=\"C\u00f4ng th\u1ee9c\">C\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/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\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html#So_sanh_nhieu_ki_tu_cua_chuoi_voi_dieu_kien_cho_truoc\" title=\"So s\u00e1nh nhi\u1ec1u k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc\">So s\u00e1nh nhi\u1ec1u k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<\/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\/so-sanh-ki-tu-dau-tien-cua-chuoi-voi-dieu-kien-cho-truoc.html#So_sanh_ki_tu_dau_tien_cua_chuoi_voi_nhieu_dieu_kien_cho_truoc\" title=\"So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc\">So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"So_sanh_ki_tu_dau_tien_cua_chuoi_voi_dieu_kien_cho_truoc\"><\/span>So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25743\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/so-sanh-ki-tu-dau-tien-1.png\" width=\"220\" height=\"443\" title=\"so-sanh-ki-tu-dau-tien-1\"><\/p>\n<p>T\u1eeb danh s\u00e1ch\u00a0<strong>M\u00e3 s\u1ea3n ph\u1ea9m<\/strong>, \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 s\u1ea3n ph\u1ea9m\u00a0<strong>M\u00e3 A<\/strong> (k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean l\u00e0\u00a0<strong>A<\/strong>).<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc\"><\/span>C\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u tr\u00ean ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau, b\u1eaft \u0111\u1ea7u t\u1eeb \u00f4 B2:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A2,\u201dA*\u201d)<\/strong><\/p>\n<\/blockquote>\n<p><em>C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd \u0111\u1ebfm nh\u1eefng \u00f4 b\u1eaft \u0111\u1ea7u v\u1edbi k\u00ed t\u1ef1\u00a0<strong>A<\/strong>. \u1ede \u0111\u00e2y, v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u1ee7a ta ch\u1ec9 bao g\u1ed3m\u00a0<strong>01<\/strong> \u00f4, v\u1eady n\u00ean c\u00f4ng th\u1ee9c s\u1ebd ki\u1ec3m tra xem li\u1ec7u \u00f4 \u0111\u00f3 c\u00f3 b\u1eaft \u0111\u1ea7u v\u1edbi\u00a0<strong>A<\/strong> kh\u00f4ng.\u00a0<\/em><\/p>\n<p><em>N\u1ebfu chu\u1ed7i b\u1eaft \u0111\u1ea7u v\u1edbi\u00a0<strong>A<\/strong>, tr\u1ea3 v\u1ec1\u00a0<strong>1.<\/strong><\/em><\/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\/2025\/01\/ex101_92019-nho-3.gif\" title=\"ex101_92019-nho-3\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><em>N\u1ebfu chu\u1ed7i kh\u00f4ng b\u1eaft \u0111\u1ea7u v\u1edbi\u00a0<strong>A<\/strong>, tr\u1ea3 v\u1ec1\u00a0<strong>0.<\/strong><\/em><\/p>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html\">AutoFill<\/a><\/strong> \u0111\u1ec3 \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o nh\u1eefng \u00f4 c\u00f2n l\u1ea1i. K\u1ebft qu\u1ea3 ta thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25746\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/so-sanh-ki-tu-dau-tien-2.png\" width=\"218\" height=\"439\" title=\"so-sanh-ki-tu-dau-tien-2\"><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng? Gi\u1edd ta s\u1ebd m\u1edf r\u1ed9ng ra cho c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_sanh_nhieu_ki_tu_cua_chuoi_voi_dieu_kien_cho_truoc\"><\/span>So s\u00e1nh nhi\u1ec1u k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thay v\u00ec so s\u00e1nh 1 k\u00ed t\u1ef1, ta c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng ra 2, 3,\u2026 k\u00ed t\u1ef1 c\u1ee7a chu\u1ed7i. Trong v\u00ed d\u1ee5 tr\u00ean, ta s\u1ebd t\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u00e3 h\u00e0ng\u00a0<strong>A1.<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 \u0111\u01b0\u1ee3c thay b\u1eb1ng:<\/p>\n<blockquote>\n<p><strong>=COUNTIF(A2,\u201dA1*\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>Sau \u0111\u00f3 filldown:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25749\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/so-sanh-ki-tu-dau-tien-3.png\" width=\"294\" height=\"436\" title=\"so-sanh-ki-tu-dau-tien-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"So_sanh_ki_tu_dau_tien_cua_chuoi_voi_nhieu_dieu_kien_cho_truoc\"><\/span>So s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi so s\u00e1nh 1 \u0111i\u1ec1u ki\u1ec7n, ta c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng\u00a0so s\u00e1nh v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. V\u1edbi v\u00ed d\u1ee5 tr\u00ean, ta s\u1ebd t\u00ecm nh\u1eefng m\u00e3 h\u00e0ng b\u1eaft \u0111\u1ea7u v\u1edbi <strong>A<\/strong> ho\u1eb7c\u00a0<strong>B<\/strong> b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a01 trong 2 c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p><strong>=OR(COUNTIF(A2,\u201dA*\u201d),COUNTIF(A2,\u201dB*\u201d))<\/strong><\/p>\n<\/blockquote>\n<p>Ho\u1eb7c:<\/p>\n<blockquote>\n<p><strong>=SUM(COUNTIF(A2,\u201dA*\u201d),COUNTIF(A2,\u201dB*\u201d))<\/strong><\/p>\n<\/blockquote>\n<p>C\u00f4ng th\u1ee9c th\u1ee9 nh\u1ea5t s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\u00a0<strong>TRUE<\/strong> n\u1ebfu th\u1ecfa m\u00e3n 1 trong 2 ho\u1eb7c c\u1ea3 2 \u0111i\u1ec1u ki\u1ec7n<strong>, FALSE<\/strong> n\u1ebfu kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o th\u1ecfa m\u00e3n.<\/p>\n<p>C\u00f4ng th\u1ee9c th\u1ee9 hai s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3\u00a0<strong>1\u00a0<\/strong>n\u1ebfu th\u1ecfa m\u00e3n 1 trong 2 \u0111i\u1ec1u ki\u1ec7n,\u00a0<strong>0<\/strong> n\u1ebfu kh\u00f4ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n n\u00e0o th\u1ecfa m\u00e3n.<\/p>\n<p>V\u1edbi c\u00f4ng th\u1ee9c th\u1ee9 hai, ta c\u00f3 th\u1ec3 vi\u1ebft g\u1ecdn l\u1ea1i \u0111\u1ec3 m\u1edf r\u1ed9ng cho nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=SUM(COUNTIF(A2,{\u201cA*\u201d,\u201dB*\u201d}))<\/strong><\/p>\n<\/blockquote>\n<p>Nh\u1eadp c\u00f4ng th\u1ee9c, sau \u0111\u00f3 s\u1eed d\u1ee5ng Filldown v\u00e0 ta thu \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25751\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/so-sanh-ki-tu-dau-tien-4.png\" width=\"562\" height=\"516\" title=\"so-sanh-ki-tu-dau-tien-4\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3\u00a0so s\u00e1nh k\u00ed t\u1ef1 \u0111\u1ea7u ti\u00ean c\u1ee7a chu\u1ed7i v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc r\u1ed3i.<br \/>\nC\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 b\u1eb1ng c\u00e1ch click v\u00e0o ti\u00eau \u0111\u1ec1 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-countif-trong-ke-toan-excel.html\">H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m COUNTIF trong k\u1ebf to\u00e1n<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/kiem-tra-ma-hang-hoa-bi-trung-trong-quan-ly-kho.html\"><strong>Ki\u1ec3m tra m\u00e3 h\u00e0ng b\u1ecb tr\u00f9ng trong qu\u1ea3n l\u00fd kho<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ky-tu-dai-dien-trong-tim-kiem-wildcard.html\">K\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n * trong Excel<\/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\/2025\/01\/ex101_92019-nho-3.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9081,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9080","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\/9080","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=9080"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9080\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9081"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}