{"id":5228,"date":"2024-12-10T02:18:02","date_gmt":"2024-12-10T02:18:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tim-doanh-thu-ban-hang-ngay-cuoi-cung-trong-thang\/"},"modified":"2024-12-10T02:18:02","modified_gmt":"2024-12-10T02:18:02","slug":"tim-doanh-thu-ban-hang-ngay-cuoi-cung-trong-thang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tim-doanh-thu-ban-hang-ngay-cuoi-cung-trong-thang\/","title":{"rendered":"T\u00ecm doanh thu b\u00e1n h\u00e0ng ng\u00e0y cu\u1ed1i c\u00f9ng trong th\u00e1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i v\u1ec1\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang.html\">T\u00ecm doanh thu b\u00e1n h\u00e0ng ng\u00e0y \u0111\u1ea7u ti\u00ean trong th\u00e1ng<\/a> , ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m INDEX+MATCH\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c doanh thu c\u1ee7a ng\u00e0y\u00a0\u0111\u1ea7u ti\u00ean c\u00f3 doanh thu trong th\u00e1ng v\u1edbi m\u1ed7i nh\u00e2n vi\u00ean. H\u1eb3n b\u1ea1n s\u1ebd th\u1eafc m\u1eafc: T\u00ecm doanh thu b\u00e1n h\u00e0ng ng\u00e0y cu\u1ed1i c\u00f9ng trong th\u00e1ng th\u00ec l\u00e0m th\u1ebf n\u00e0o, n\u1ebfu nh\u01b0 th\u1eddi\u00a0\u0111i\u1ec3m ng\u00e0y cu\u1ed1i c\u00f9ng c\u00f3 doanh thu c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean l\u00e0 kh\u00e1c nhau? Ch\u00fang ta s\u1ebd c\u00f9ng nhau t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi cho y\u00eau c\u1ea7u n\u00e0y th\u00f4ng qua v\u00ed d\u1ee5:<\/p>\n<p>B\u1ea3ng b\u00e1o c\u00e1o doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean 10 ng\u00e0y\u00a0\u0111\u1ea7u th\u00e1ng 8 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14718\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-last_value-01.png\" width=\"518\" height=\"286\" title=\"heo-last_value-01\"><\/p>\n<p>Th\u1eddi\u00a0\u0111i\u1ec3m ng\u00e0y cu\u1ed1i c\u00f3 ph\u00e1t sinh doanh thu c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean l\u00e0:<\/p>\n<ul>\n<li>Nh\u00e2n vi\u00ean A: Ng\u00e0y 08\/08, doanh thu = 16<\/li>\n<li>Nh\u00e2n vi\u00ean B: Ng\u00e0y 10\/8, doanh thu = 66<\/li>\n<li>Nh\u00e2n vi\u00ean C: Ng\u00e0y 09\/08, doanh thu = 93<\/li>\n<\/ul>\n<p>Ph\u01b0\u01a1ng ph\u00e1p\u00a0\u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng INDEX + MATCH m\u00e0 ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOOKUP<\/p>\n<p>B\u1ea1n c\u00f3 ngh\u0129 r\u1eb1ng LOOKUP l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y? H\u00e3y c\u00f9ng xem t\u1ea1i sao c\u00f3 th\u1ec3\u00a0\u1ee9ng d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c h\u00e0m LOOKUP nh\u00e9:<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u1ea5u tr\u00fac c\u1ee7a h\u00e0m LOOKUP, b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/ham-lookup-va-cong-thuc-vi-du-trong-excel-2016-2013-2010-2007-2003.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m LOOKUP<\/a><\/p>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u00fang ta khai th\u00e1c m\u1ed9t th\u1ee7 thu\u1eadt c\u1ee7a h\u00e0m LOOKUP\u00a0\u0111\u00f3 l\u00e0:<\/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-446.gif\" title=\"ex101_92019-nho-446\"><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-176.gif\" title=\"vba101_92019-nho-176\"><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-446.gif\" title=\"ex101_92019-nho-446\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>V\u1edbi <strong>gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/strong> (lookup_value) lu\u00f4n l\u1edbn h\u01a1n <strong>V\u00e9c t\u01a1 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm<\/strong> th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 lu\u00f4n l\u00e0 gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong <strong>V\u00e9c t\u01a1 ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1<\/strong>.<\/p>\n<p>V\u1eady b\u00ed quy\u1ebft\u00a0\u1edf ch\u1ed7 ch\u00fang ta ch\u1ec9 c\u1ea7n thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c LOOKUP trong v\u00f9ng B2:B11 sao cho gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm lu\u00f4n l\u1edbn h\u01a1n m\u1ed7i gi\u00e1 tr\u1ecb trong V\u00e9c t\u01a1 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm.<\/p>\n<p>V\u00e9c t\u01a1 ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u1edbi nh\u00e2n vi\u00ean A l\u00e0 v\u00f9ng B2:B11.\u00a0V\u00e9c t\u01a1 ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u0169ng l\u00e0 v\u00f9ng B2:B11, nh\u01b0ng\u00a0\u0111\u1ec3 tr\u00e1nh vi\u1ec7c c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb r\u1ed7ng, ch\u00fang ta s\u1ebd x\u00e9t v\u1edbi B2:B11&lt;&gt;\u201d\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14719\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-last_value-02.png\" width=\"796\" height=\"290\" title=\"heo-last_value-02\"><\/p>\n<p>Tuy nhi\u00ean n\u1ebfu ch\u1ec9 x\u00e9t c\u00e1c gi\u00e1 tr\u1ecb TRUE\/FALSE th\u00ec kh\u00f4ng th\u1ec3\u00a0\u0111\u1ed1i chi\u1ebfu\u00a0\u0111\u01b0\u1ee3c v\u1edbi Gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm c\u1ee5 th\u1ec3 n\u00e0o\u00a0\u0111\u00f3, do v\u1eady ch\u00fang ta s\u1ebd chuy\u1ec3n c\u00e1c gi\u00e1 tr\u1ecb TRUE\/FALSE v\u1ec1 d\u1ea1ng s\u1ed1 b\u1eb1ng c\u00e1ch l\u1ea5y 1 chia cho\u00a0\u0111i\u1ec1u ki\u1ec7n TRUE\/FALSE.<\/p>\n<ul>\n<li>V\u1edbi c\u00e1c gi\u00e1 tr\u1ecb TRUE s\u1ebd ra k\u1ebft qu\u1ea3 l\u00e0 1 (TRUE\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u01b0\u1edbc\u00a0l\u00e0 1)<\/li>\n<li>V\u1edbi c\u00e1c gi\u00e1 tr\u1ecb FALSE s\u1ebd ra k\u1ebft qu\u1ea3 l\u00e0 #DIV\/0! l\u00e0 ph\u00e9p chia cho m\u1eabu s\u1ed1 = 0 (FALSE\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u01b0\u1edbc l\u00e0 0)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14720\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-last_value-03.png\" width=\"954\" height=\"287\" title=\"heo-last_value-03\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 ta c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb Doanh thu b\u00e1n h\u00e0ng s\u1ebd t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi c\u00e1c k\u1ebft qu\u1ea3 l\u00e0 1<\/p>\n<p>V\u1eady ch\u1ec9 c\u1ea7n\u00a0\u0111\u1eb7t gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u1edbn h\u01a1n 1 l\u00e0 ta s\u1ebd lu\u00f4n c\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m LOOKUP l\u00e0 gi\u00e1 tr\u1ecb cu\u1ed1i c\u00f9ng trong V\u00e9c t\u01a1 ch\u1ee9a k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 (B2:B11)<\/p>\n<p>H\u00e0m LOOKUP\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=LOOKUP(2,1\/(B2:B11&lt;&gt;\u201d\u201d),B2:B11)<\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14721\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-last_value-04.png\" width=\"570\" height=\"380\" title=\"heo-last_value-04\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00e3\u00a0\u0111\u00fang nh\u01b0 y\u00eau c\u1ea7u.<\/p>\n<p>* L\u01b0u\u00a0\u00fd: H\u00e0m LOOKUP l\u00e0 h\u00e0m cho ph\u00e9p s\u1eed d\u1ee5ng m\u1ea3ng n\u00ean ch\u00fang ta kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng Ctrl+Shift+Enter\u00a0\u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c v\u1ec1 d\u1ea1ng m\u1ea3ng. Ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng LOOKUP nh\u01b0 c\u00f4ng th\u1ee9c b\u00ecnh th\u01b0\u1eddng l\u00e0\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c nh\u00e2n vi\u00ean B, C ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\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<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-446.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5229,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5228","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\/5228","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=5228"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5228\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5229"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}