{"id":5250,"date":"2024-12-10T05:52:54","date_gmt":"2024-12-10T05:52:54","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang\/"},"modified":"2024-12-10T05:52:54","modified_gmt":"2024-12-10T05:52:54","slug":"tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang\/","title":{"rendered":"T\u00ecm doanh thu b\u00e1n h\u00e0ng ng\u00e0y \u0111\u1ea7u ti\u00ean trong th\u00e1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 m\u1ed9t c\u1eeda h\u00e0ng nh\u1ecf v\u1edbi m\u1ed9t v\u00e0i nh\u00e2n vi\u00ean. Nh\u1eefng nh\u00e2n vi\u00ean n\u00e0y c\u00f3 ca l\u00e0m vi\u1ec7c kh\u00e1c nhau. Sau 10 ng\u00e0y\u00a0b\u1ea1n nh\u1eadn\u00a0\u0111\u01b0\u1ee3c b\u00e1o c\u00e1o v\u1ec1 doanh thu\u00a0b\u00e1n h\u00e0ng c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14710\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-first-value.png\" width=\"507\" height=\"287\" title=\"heo-first-value\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng ng\u00e0y\u00a0\u0111\u1ea7u ti\u00ean c\u00f3 doanh thu c\u1ee7a c\u00e1c nh\u00e2n vi\u00ean l\u00e0 kh\u00e1c nhau:<\/p>\n<ul>\n<li>Nh\u00e2n vi\u00ean A c\u00f3 ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u l\u00e0 02\/08, doanh thu = 68<\/li>\n<li>Nh\u00e2n vi\u00ean B c\u00f3 ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u l\u00e0 04\/08, doanh thu = 66<\/li>\n<li>Nh\u00e2n vi\u00ean C c\u00f3 ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u l\u00e0 03\/08, doanh thu = 49<\/li>\n<\/ul>\n<p>V\u00e0\u00a0\u0111\u00e2y l\u00e0\u00a0\u0111i\u1ec1u m\u00e0 b\u1ea1n\u00a0\u0111ang quan t\u00e2m. L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ef1 nh\u1eadn di\u1ec7n\u00a0\u0111\u01b0\u1ee3c doanh thu c\u1ee7a ng\u00e0y b\u1eaft\u00a0\u0111\u1ea7u t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi m\u1ed7i nh\u00e2n vi\u00ean? Sau\u00a0\u0111\u00e2y h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online\u00a0\u0111i t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi.<\/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-6757d735661f1\" 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\/tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang.html#1_Phan_tich_yeu_cau\" title=\"1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u\">1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tim-doanh-thu-ban-hang-ngay-dau-tien-trong-thang.html#2_Xay_dung_cong_thuc\" title=\"2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c\">2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau\"><\/span>1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh ng\u00e0y\u00a0\u0111\u1ea7u ti\u00ean c\u00f3 d\u1eef li\u1ec7u ph\u00e1t sinh, ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadn ra quy lu\u1eadt nh\u01b0 sau:<\/p>\n<ul>\n<li>Nh\u00e2n vi\u00ean A: X\u00e9t trong c\u1ed9t B, t\u1eeb B2:B11 ch\u00fang ta th\u1ea5y v\u1ecb tr\u00ed\u00a0\u0111\u1ea7u ti\u00ean c\u00f3 d\u1eef li\u1ec7u l\u00e0 B3.\u00a0\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u kh\u00e1c r\u1ed7ng<\/li>\n<li>\u0110\u1ec3 t\u00ecm v\u1ecb tr\u00ed c\u1ee7a 1 n\u1ed9i dung trong 1 m\u1ea3ng, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m MATCH<\/li>\n<li>N\u1ed9i dung t\u00ecm ki\u1ebfm\u00a0c\u1ee7a h\u00e0m MATCH l\u00e0 d\u1eef li\u1ec7u kh\u00e1c r\u1ed7ng. N\u00f3i c\u00e1ch kh\u00e1c l\u00e0 t\u00ecm gi\u00e1 tr\u1ecb TRUE v\u1edbi m\u1ea3ng B2:B11 kh\u00e1c r\u1ed7ng. Ch\u00fang ta c\u1ea7n x\u00e9t t\u1eebng\u00a0\u00f4 trong m\u1ea3ng v\u1edbi c\u1ea3 m\u1ea3ng n\u00e0y, do\u00a0\u0111\u00f3 c\u00f4ng th\u1ee9c c\u1ea7n l\u00e0m s\u1ebd l\u00e0 d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<li>H\u00e0m MATCH ch\u1ec9 cho ra k\u1ebft qu\u1ea3 l\u00e0 th\u1ee9 t\u1ef1 c\u1ee7a\u00a0\u00f4 k\u1ebft qu\u1ea3 trong m\u1ea3ng. Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 l\u1ea5y n\u1ed9i dung t\u1ea1i\u00a0\u00f4\u00a0\u0111\u00f3 th\u00ec ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p th\u00eam l\u00e0m INDEX<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Xay_dung_cong_thuc\"><\/span>2. X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb ph\u00e2n t\u00edch\u00a0\u1edf tr\u00ean, ch\u00fang ta s\u1ebd c\u1ea7n s\u1eed d\u1ee5ng t\u1edbi h\u00e0m INDEX v\u00e0 h\u00e0m MATCH. Th\u1ee9 t\u1ef1 vi\u1ebft c\u00e1c h\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>H\u00e0m MATCH s\u1ebd vi\u1ebft tr\u01b0\u1edbc:<\/strong><\/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-448.gif\" title=\"ex101_92019-nho-448\"><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-178.gif\" title=\"vba101_92019-nho-178\"><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-448.gif\" title=\"ex101_92019-nho-448\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u00ecm gi\u00e1 tr\u1ecb TRUE v\u1edbi m\u1ea3ng B2:B11 kh\u00e1c r\u1ed7ng = X\u00e9t t\u1eebng gi\u00e1 tr\u1ecb\u00a0\u1edf m\u1ea3ng B2:B11, n\u1ebfu gi\u00e1 tr\u1ecb n\u00e0o r\u1ed7ng th\u00ec l\u00e0 FALSE, gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c r\u1ed7ng th\u00ec l\u00e0 TRUE<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14711\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-first-value-02.png\" width=\"788\" height=\"284\" title=\"heo-first-value-02\"><\/p>\n<p>Nh\u01b0 v\u1eady gi\u00e1 tr\u1ecb TRUE\u00a0\u0111\u1ea7u ti\u00ean trong v\u00f9ng F2:F11 l\u00e0\u00a0\u00f4 F3, t\u01b0\u01a1ng\u00a0\u1ee9ng gi\u00e1 tr\u1ecb\u00a0\u1edf B3&lt;&gt;\u201d\u201d<\/p>\n<p>H\u00e0m MATCH c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=MATCH(TRUE,B2:B11&lt;&gt;\u201d\u201d,0)<\/p>\n<\/blockquote>\n<p>Tuy nhi\u00ean\u00a0\u0111\u00e2y ch\u01b0a ph\u1ea3i k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng, ch\u00fang ta c\u00f2n 2 y\u00eau c\u1ea7u n\u1eefa:<\/p>\n<ul>\n<li>K\u1ebft h\u1ee3p th\u00eam h\u00e0m Index<\/li>\n<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng do B2:B11&lt;&gt;\u201d\u201d l\u00e0 m\u1ea3ng. Mu\u1ed1n s\u1eed d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung n\u00e0y trong h\u00e0m Match th\u00ec ph\u1ea3i s\u1eed d\u1ee5ng d\u1ea5u c\u00f4ng th\u1ee9c m\u1ea3ng (K\u1ebft th\u00fac c\u00f4ng th\u1ee9c b\u1eb1ng ph\u00edm Ctrl+Shift+Enter)<\/li>\n<\/ul>\n<p><strong>K\u1ebft h\u1ee3p h\u00e0m INDEX<\/strong><\/p>\n<p>\u0110\u1ec3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung\u00a0\u1edf\u00a0\u00f4 B3 (k\u1ebft qu\u1ea3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf h\u00e0m Match), ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p th\u00eam h\u00e0m INDEX nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=<strong>INDEX(B2:B11,<\/strong><em>MATCH(TRUE,B2:B11&lt;&gt;\u201d\u201d,0)<\/em><strong>)<\/strong><\/p>\n<\/blockquote>\n<p>Khi\u00a0\u0111\u00f3\u00a0k\u1ebft qu\u1ea3 x\u00e1c\u00a0\u0111\u1ecbnh nh\u01b0 sau:<\/p>\n<ul>\n<li>H\u00e0m MATCH s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 2 (t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1ecb tr\u00ed th\u1ee9 hai, t\u00ednh t\u1eeb\u00a0\u00f4 B2, l\u00e0\u00a0\u00f4 B3). H\u00e0m Match ch\u1ec9 gi\u00fap x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed th\u1ee9 m\u1ea5y trong m\u1ea3ng n\u00e0y.<\/li>\n<li>Trong v\u00f9ng B2:B11 th\u00ec v\u1ecb tr\u00ed th\u1ee9 hai s\u1ebd l\u00e0\u00a0\u00f4 B3. Khi\u00a0\u0111\u00f3 h\u00e0m Index s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 B3<\/li>\n<\/ul>\n<p>K\u1ebft th\u00fac h\u00e0m INDEX+MATCH ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng: b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm\u00a0Ctrl+Shift+Enter<\/p>\n<p>H\u00e3y xem k\u1ebft qu\u1ea3 khi c\u00f3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng (\u00f4 B13) v\u00e0 kh\u00f4ng s\u1eed d\u1ee5ng d\u1ea5u c\u00f4ng th\u1ee9c m\u1ea3ng (\u00f4 B14):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14712\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-first-value-03.png\" width=\"1004\" height=\"356\" title=\"heo-first-value-03\"><\/p>\n<p>\u00d4 B13 ra k\u1ebft qu\u1ea3 l\u00e0 68, ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 B3<\/p>\n<p>\u00d4 B14 kh\u00f4ng ra k\u1ebft qu\u1ea3, b\u00e1o l\u1ed7i. B\u1edfi v\u00ec h\u00e0m MATCH c\u00f3 s\u1eed d\u1ee5ng m\u1ea3ng nh\u01b0ng kh\u00f4ng th\u1ef1c hi\u1ec7n t\u00ednh theo c\u00f4ng th\u1ee9c m\u1ea3ng m\u00e0 t\u00ednh b\u00ecnh th\u01b0\u1eddng.<\/p>\n<p>\u00c1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 cho nh\u00e2n vi\u00ean B v\u00e0 nh\u00e2n vi\u00ean C ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14713\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-first-value-04.png\" width=\"795\" height=\"380\" title=\"heo-first-value-04\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/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-448.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5251,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5250","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\/5250","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=5250"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5250\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5251"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}