{"id":6141,"date":"2024-12-21T13:42:10","date_gmt":"2024-12-21T13:42:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cham-cong-di-lam-muon\/"},"modified":"2024-12-21T13:42:10","modified_gmt":"2024-12-21T13:42:10","slug":"cham-cong-di-lam-muon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cham-cong-di-lam-muon\/","title":{"rendered":"Ch\u1ea5m c\u00f4ng \u0111i l\u00e0m mu\u1ed9n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>S\u00e1ng nay\u00a0\u0111\u1ebfn c\u00f4ng ty, s\u1ebfp t\u1ef1 nhi\u00ean g\u1ecdi v\u00e0o ph\u00f2ng h\u1ecdp v\u00e0 n\u00f3i:<\/p>\n<p>\u2013 D\u1ea1o n\u00e0y nh\u00e2n vi\u00ean c\u00f4ng ty hay\u00a0\u0111i l\u00e0m mu\u1ed9n qu\u00e1. Em l\u00e0m nh\u00e2n s\u1ef1, em ph\u1ea3i theo d\u00f5i cho anh t\u00ecnh h\u00ecnh\u00a0\u0111i mu\u1ed9n c\u1ee7a m\u1ecdi ng\u01b0\u1eddi m\u1edbi\u00a0\u0111\u01b0\u1ee3c. Cu\u1ed1i th\u00e1ng b\u00e1o cho anh k\u1ebft qu\u1ea3 t\u00ecnh h\u00ecnh nh\u00e9.<\/p>\n<p>M\u00ecnh ngh\u0129 th\u1ea7m: \u201cBao l\u00e2u nay ch\u1ea5m c\u00f4ng c\u00f3 bao gi\u1edd theo d\u00f5i\u00a0\u0111i mu\u1ed9n\u00a0\u0111\u00e2u. C\u00f4ng ty th\u00ec ch\u1eb3ng c\u00f3 m\u00e1y ch\u1ea5m c\u00f4ng. Bi\u1ebft l\u00e0m th\u1ebf n\u00e0o b\u00e2y gi\u1edd.\u201d Ngh\u0129 th\u1ebf th\u00f4i ch\u1ee9 v\u1eabn ph\u1ea3i v\u00e2ng d\u1ea1 tr\u01b0\u1edbc m\u1eb7t s\u1ebfp r\u1ed3i tr\u1edf v\u1ec1 b\u00e0n l\u00e0m vi\u1ec7c.<\/p>\n<p>Qu\u1ea3 th\u1ef1c v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y kh\u00f3. L\u00ean m\u1ea1ng t\u00ecm, h\u1ecfi b\u1ea1n b\u00e8 c\u0169ng ch\u1eb3ng ai gi\u00fap.<\/p>\n<p>Ch\u1ee3t nh\u1edb c\u00e2u n\u00f3i \u201c<a href=\"https:\/\/www.hocexcel.online\">Excel ph\u1ea3i bi\u1ebft\u00a0\u0111\u1ebfn HEO<\/a>\u201c, m\u00ecnh l\u00ean <a href=\"https:\/\/www.hocexcel.online\">hocexcel.online<\/a> v\u00e0 t\u00ecm ra b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn n\u00e0y. C\u00e1ch ch\u1ea5m c\u00f4ng\u00a0\u0111i mu\u1ed9n qu\u00e1 d\u1ec5 m\u00e0 l\u1ea1i r\u1ea5t ch\u00ednh x\u00e1c. C\u1ea3 nh\u00e0 c\u00f9ng xem nh\u00e9.<\/p>\n<p>Ban\u00a0\u0111\u1ea7u m\u00ecnh c\u00f3 b\u1ea3ng ch\u1ea5m c\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10398 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-bang-cham-cong.png\" width=\"1302\" height=\"393\" title=\"pic01-bang-cham-cong\"><\/p>\n<p>M\u00ecnh\u00a0\u0111\u00e3 t\u00ednh\u00a0\u0111\u01b0\u1ee3c s\u1ed1 c\u00f4ng\u00a0\u0111i l\u00e0m b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/43-%e2%97%8f-cach-su-dung-ham-countif-trong-excel.html\">h\u00e0m COUNTIF<\/a><\/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-552.gif\" title=\"ex101_92019-nho-552\"><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-233.gif\" title=\"vba101_92019-nho-233\"><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-552.gif\" title=\"ex101_92019-nho-552\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u00e2y gi\u1edd s\u1ebfp mu\u1ed1n bi\u1ebft\u00a0\u0111i mu\u1ed9n theo 3 m\u1ee9c:<\/p>\n<ul>\n<li>Lo\u1ea1i 1:\u00a0\u0111i mu\u1ed9n t\u1eeb 1 \u2013\u00a05 ph\u00fat<\/li>\n<li>Lo\u1ea1i 2:\u00a0\u0111i mu\u1ed9n 6 \u2013 15 ph\u00fat<\/li>\n<li>Lo\u1ea1i 3:\u00a0\u0111i mu\u1ed9n t\u1eeb 16 \u2013 30 ph\u00fat<\/li>\n<\/ul>\n<p>M\u00ecnh x\u00e2y d\u1ef1ng k\u00fd hi\u1ec7u ch\u1ea5m c\u00f4ng th\u1ebf n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10399 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02-ky-hieu-cham-cong-di-muon.png\" width=\"1308\" height=\"456\" title=\"pic02-ky-hieu-cham-cong-di-muon\"><\/p>\n<p>M\u00ecnh x\u00e2y d\u1ef1ng ph\u1ea7n\u00a0\u0111\u1ebfm s\u1ed1 c\u00f4ng\u00a0\u0111i mu\u1ed9n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10400 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-ham-tinh-cong-di-muon.png\" width=\"1189\" height=\"518\" title=\"pic03-ham-tinh-cong-di-muon\"><\/p>\n<p>V\u1edbi c\u00e1c lo\u1ea1i k\u00fd hi\u1ec7u X1, X2, X3 l\u00e0m t\u01b0\u01a1ng t\u1ef1 nhau, v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/43-%e2%97%8f-cach-su-dung-ham-countif-trong-excel.html\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/a><\/p>\n<p>Khi ch\u1ea5m c\u00f4ng b\u1eb1ng c\u00e1c k\u00fd hi\u1ec7u th\u1ec3 hi\u1ec7n\u00a0\u0111i mu\u1ed9n l\u00e0 X1, X2, X3 th\u00ec s\u1ebd kh\u00f4ng ch\u1ea5m c\u00f4ng l\u00e0 X n\u1eefa, nh\u01b0ng v\u1eabn c\u1ea7n ph\u1ea3i t\u00ednh\u00a0\u0111\u01b0\u1ee3c l\u00e0 X1 hay X2 hay X3 v\u1eabn\u00a0\u0111\u1ec1u th\u1ec3 hi\u1ec7n l\u00e0\u00a0\u0111i l\u00e0m\u00a0\u0111\u1ee7 c\u00f4ng (gi\u1ed1ng nh\u01b0 X), v\u00ec v\u1eady c\u00e1ch t\u00ednh\u00a0\u1edf c\u1ed9t L\u00e0m\u00a0\u0111\u1ee7 c\u00f4ng s\u1ebd ph\u1ea3i thay\u00a0\u0111\u1ed5i.<\/p>\n<p>=&gt; C\u00e2u h\u1ecfi kh\u00f3 nh\u1ea5t l\u00e0 : C\u00f4ng th\u1ee9c n\u00e0o\u00a0\u0111\u1ec3 t\u00ednh c\u1ed9t L\u00e0m\u00a0\u0111\u1ee7 c\u00f4ng th\u1ecfa m\u00e3n y\u00eau c\u1ea7u tr\u00ean.<\/p>\n<p><a href=\"https:\/\/www.hocexcel.online\">hocexcel.online<\/a> ch\u1ec9 cho m\u00ecnh quy lu\u1eadt\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0:<\/p>\n<p>D\u00f9 X1, X2 hay X3 th\u00ec k\u00fd t\u1ef1\u00a0\u0111\u1ea7u ti\u00ean v\u1eabn l\u00e0 X.<\/p>\n<p>\u0110\u1ec3\u00a0\u0111\u1ebfm xem c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 X th\u00ec x\u00e1c\u00a0\u0111\u1ecbnh k\u00fd t\u1ef1\u00a0\u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i\u00a0\u00f4 xem c\u00f3 ph\u1ea3i l\u00e0 X kh\u00f4ng<\/p>\n<p>Ta d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">h\u00e0m SUMPRODUCT<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10402 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic04-ham-tinh-cong-di-lam.png\" width=\"1034\" height=\"507\" title=\"pic04-ham-tinh-cong-di-lam\">N\u1ed9i dung h\u00e0m SUMPRODUCT nh\u01b0 sau:<\/p>\n<blockquote>\n<p>SUMPRODUCT((LEFT($E6:$AI6,1)=$A$13)*1)<\/p>\n<\/blockquote>\n<p>LEFT($E6:$AI6,1) l\u00e0 x\u00e9t c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u1ea7u ti\u00ean trong m\u1ed7i\u00a0\u00f4 trong v\u00f9ng t\u1eeb E6\u00a0\u0111\u1ebfn AI6,\u00a0\u1edf\u00a0\u0111\u00e2y c\u1ed1\u00a0\u0111\u1ecbnh $ tr\u01b0\u1edbc m\u1ed7i c\u1ed9t<\/p>\n<p>LEFT($E6:$AI6,1)=$A$13 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u1ea7u ti\u00ean trong m\u1ed7i\u00a0\u00f4 trong v\u00f9ng t\u1eeb E6\u00a0\u0111\u1ebfn AI6 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng\u00a0\u00f4 A13 (l\u00e0 k\u00fd hi\u1ec7u X)<\/p>\n<p>SUMPRODUCT((LEFT($E6:$AI6,1)=$A$13)*1) l\u00e0 m\u1ed7i k\u1ebft qu\u1ea3 t\u00ecm\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf m\u1ec7nh\u00a0\u0111\u1ec1 tr\u00ean s\u1ebd nh\u00e2n v\u1edbi 1 (t\u1ee9c l\u00e0 coi nh\u01b0 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n,\u00a0\u0111i\u1ec1u n\u00e0y gi\u1ed1ng nh\u01b0 vi\u1ec7c ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m\u00a0\u0111\u1ebfm COUNT)<\/p>\n<p>* V\u1eady l\u00e0 xong r\u1ed3i. Th\u1eadt d\u1ec5 ph\u1ea3i kh\u00f4ng n\u00e0o. Nh\u1edd c\u00f3 <a href=\"https:\/\/www.hocexcel.online\">hocexcel.online<\/a> m\u00e0 vi\u1ec7c x\u1eed l\u00fd ch\u1ea5m c\u00f4ng, t\u00ednh ti\u1ec1n l\u01b0\u01a1ng tr\u1edf n\u00ean g\u1ea7n g\u0169i v\u00e0 d\u1ec5 hi\u1ec3u.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o <a href=\"http:\/\/blog.ezworkapp.com\/cham-cong-di-lam-muon.html\">kh\u00f3a h\u1ecdc\u00a0\u00e1p d\u1ee5ng\u00a0Excel v\u00e0 VBA v\u00e0o c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng<\/a>\u00a0\u0111\u1ec3 l\u00e0m vi\u1ec7c t\u1ed1t h\u01a1n nh\u00e9.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng\u00a0Excel trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1,\u00a0c\u00e1c b\u1ea1n c\u00f3 th\u1ec3\u00a0tham gia kh\u00f3a h\u1ecdc<\/p>\n<p><a href=\"http:\/\/excel-ke-toan-tien-luong2.hocexcel.online\/\">TL01 \u2013\u00a0\u1ee9ng d\u1ee5ng\u00a0EXCEL VBA trong TI\u1ec0N L\u01af\u01a0NG \u2013 NH\u00c2N S\u1ef0<\/a><\/p>\n<p>kh\u00f3a h\u1ecdc s\u1ebd cung c\u1ea5p cho b\u1ea1n nh\u1eefng ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh, nh\u00e2n s\u1ef1 trong th\u1ef1c t\u1ebf v\u00e0 c\u00e1c k\u1ef9 n\u0103ng\u00a0excel k\u1ebft h\u1ee3p v\u1edbi VBA\u00a0\u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c, t\u1ed1i\u00a0\u01b0u hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea1n.<\/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-552.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6142,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6141","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\/6141","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=6141"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6142"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}