{"id":6120,"date":"2024-12-21T13:38:26","date_gmt":"2024-12-21T13:38:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tinh-cong-khi-cham-cong-bang-so-xen-lan-ky-hieu\/"},"modified":"2024-12-21T13:38:26","modified_gmt":"2024-12-21T13:38:26","slug":"tinh-cong-khi-cham-cong-bang-so-xen-lan-ky-hieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tinh-cong-khi-cham-cong-bang-so-xen-lan-ky-hieu\/","title":{"rendered":"T\u00ednh c\u00f4ng khi ch\u1ea5m c\u00f4ng b\u1eb1ng s\u1ed1 xen l\u1eabn k\u00fd hi\u1ec7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u1ea7u h\u1ebft khi thi\u1ebft l\u1eadp <a href=\"http:\/\/blog.ezworkapp.com\/tao-bang-cham-cong-tren-excel.html\">b\u1ea3ng ch\u1ea5m c\u00f4ng tr\u00ean Excel<\/a>, ng\u01b0\u1eddi k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng th\u01b0\u1eddng kh\u00f4ng x\u00e2y d\u1ef1ng theo m\u1ed9t ti\u00eau th\u1ee9c, ti\u00eau chu\u1ea9n c\u1ee5 th\u1ec3 n\u00e0o. M\u1ed7i n\u01a1i ch\u1ea5m c\u00f4ng m\u1ed9t ki\u1ec3u. Hay th\u1eadm ch\u00ed c\u00f9ng 1 ng\u01b0\u1eddi l\u1ea1i ch\u1ea5m c\u00f4ng m\u1ed7i l\u00fac m\u1ed9t ki\u1ec3u.<\/p>\n<p><strong>C\u00f3 m\u1ed9t s\u1ed1 quy\u00a0\u01b0\u1edbc ch\u1ea5m c\u00f4ng m\u00e0 ch\u00fang ta v\u1eabn th\u01b0\u1eddng l\u00e0m theo nh\u01b0:<\/strong><\/p>\n<ul style=\"list-style-type: square\">\n<li>K\u00fd hi\u1ec7u X : ch\u1ea5m cho 1 c\u00f4ng l\u00e0m vi\u1ec7c\u00a0\u0111\u1ee7 8 ti\u1ebfng.<\/li>\n<li>N\u1ebfu\u00a0\u00edt h\u01a1n 8 gi\u1edd c\u00f4ng\u00a0\u0111\u00f3, th\u00ec ghi s\u1ed1 gi\u1edd.<\/li>\n<li>L\u00e0m n\u1eeda ng\u00e0y th\u00ec k\u00fd hi\u1ec7u N, t\u1ee9c l\u00e0 4 ti\u1ebfng m\u1ed9t ng\u00e0y.<\/li>\n<\/ul>\n<p>V\u1eady ch\u00fang ta t\u00ednh t\u1ed5ng s\u1ed1 gi\u1edd c\u00f4ng nh\u01b0 th\u1ebf n\u00e0o, khi m\u00e0 b\u1ea3ng ch\u1ea5m c\u00f4ng s\u1eed d\u1ee5ng\u00a0\u0111\u1ed3ng th\u1eddi\u00a0c\u1ea3 k\u00fd t\u1ef1 X, N v\u00e0 c\u1ea3 s\u1ed1 gi\u1edd c\u00f4ng?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10751 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01_c491e1bb81-bc3a0i.png\" width=\"771\" height=\"384\" title=\"pic01_c491e1bb81-bc3a0i\"><\/p>\n<p><strong>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/strong><\/p>\n<p><em>\u0110\u1ebfm s\u1ed1 gi\u1edd c\u00f4ng l\u1ebb b\u1eb1ng h\u00e0m<\/em><\/p>\n<blockquote>\n<p>SUM(E6:N6)<\/p>\n<\/blockquote>\n<p><em>\u0110\u1ebfm s\u1ed1 ng\u00e0y ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u X (h\u00e0m Countif), sau\u00a0\u0111\u00f3 quy\u00a0\u0111\u1ed5i ra gi\u1edd b\u1eb1ng c\u00e1ch nh\u00e2n v\u1edbi 8<\/em><\/p>\n<blockquote>\n<p>COUNTIF(E6:N6,$A$13)*8<\/p>\n<\/blockquote>\n<p><em>\u0110\u1ebfm s\u1ed1 ng\u00e0y ch\u1ea5m c\u00f4ng b\u1eb1ng k\u00fd hi\u1ec7u\u00a0N (h\u00e0m Countif), sau\u00a0\u0111\u00f3 quy\u00a0\u0111\u1ed5i ra gi\u1edd b\u1eb1ng c\u00e1ch nh\u00e2n v\u1edbi\u00a04<\/em><\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-549.gif\" title=\"ex101_92019-nho-549\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-232.gif\" title=\"vba101_92019-nho-232\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-549.gif\" title=\"ex101_92019-nho-549\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>COUNTIF(E6:N6,$A$14)*4<\/p>\n<\/blockquote>\n<p><em>K\u1ebft h\u1ee3p c\u1ea3 3 h\u00e0m n\u00e0y v\u00e0o\u00a01 \u00f4 x\u00e1c\u00a0\u0111\u1ecbnh k\u1ebft qu\u1ea3:<\/em><\/p>\n<blockquote>\n<p>O6 =\u00a0SUM(E6:N6)+COUNTIF(E6:N6,$A$13)*8+COUNTIF(E6:N6,$A$14)*4<\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">l\u01a1\u0301p h\u1ecdc Excel k\u1ebf to\u00e1n<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10752 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02_ke1babft-que1baa3.png\" width=\"773\" height=\"429\" title=\"pic02_ke1babft-que1baa3\"><\/p>\n<p>Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>C\u00e1c b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n g\u00ec trong vi\u1ec7c ch\u1ea5m c\u00f4ng h\u00e3y chia s\u1ebb va\u0300 bi\u0300nh lu\u00e2\u0323n ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 HEO s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft mo\u0323i th\u0103\u0301c m\u0103\u0301c nhe\u0301.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng\u00a0Excel trong c\u00f4ng vi\u1ec7c ha\u0303y \u0111\u00ea\u0301n v\u01a1\u0301i Blog ho\u0323c Excel Online la\u0300 m\u00f4\u0323t trong nh\u01b0\u0303ng <a href=\"http:\/\/blog.ezworkapp.com\">\u0111i\u0323a chi\u0309 ho\u0323c excel ta\u0323i Ha\u0300 N\u00f4\u0323i<\/a> \u0111a\u0309m ba\u0309o uy ti\u0301n, ch\u00e2\u0301t l\u01b0\u01a1\u0323ng v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam v\u01a1\u0301i nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t cho ca\u0301c ba\u0323n co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng Excel m\u00f4\u0323t ca\u0301ch tha\u0300nh tha\u0323o nh\u00e2\u0301t.<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-549.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6121,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6120","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\/6120","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=6120"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6120\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6121"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}