{"id":5918,"date":"2024-12-21T11:19:14","date_gmt":"2024-12-21T11:19:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hoc-excel-nang-cao-ket-hop-ham-offset-match-match\/"},"modified":"2024-12-21T11:19:14","modified_gmt":"2024-12-21T11:19:14","slug":"hoc-excel-nang-cao-ket-hop-ham-offset-match-match","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/hoc-excel-nang-cao-ket-hop-ham-offset-match-match\/","title":{"rendered":"H\u1ecdc Excel N\u00e2ng Cao | K\u1ebft h\u1ee3p h\u00e0m Offset Match Match"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00ecnh th\u01b0\u1eddng khi tra c\u1ee9u 1 b\u1ea3ng theo 2 chi\u1ec1u ho\u1eb7c c\u00f2n t\u00ean kh\u00e1c ph\u1ee9c t\u1ea1p h\u01a1n l\u00e0 tra c\u1ee9u theo ma tr\u1eadn th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m Index Match Match. Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng Index Match Match, trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n s\u1ef1 k\u1ebft h\u1ee3p n\u1eefa c\u0169ng c\u00f3 th\u1ec3 x\u1eed l\u00fd \u0111\u01b0\u1ee3c nhu c\u1ea7u tra c\u1ee9u n\u00e0y:\u00a0K\u1ebft h\u1ee3p h\u00e0m Offset Match Match<\/p>\n<p>Tr\u01b0\u1edbc khi \u0111\u1ecdc ti\u1ebfp, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/ham-offset-va-cac-ket-hop-ham-cua-no-trong-excel-cong-thuc-vi-du.html\"><strong>h\u00e0m Offset<\/strong><\/a> v\u00e0 Match, n\u1ebfu ch\u01b0a hi\u1ec3u, m\u1eddi b\u1ea1n theo d\u00f5i video v\u1ec1 2 h\u00e0m n\u00e0y tr\u01b0\u1edbc:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/DsCzH1x35KQ\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/10\/OFFSETMATCHMATCH_02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11322\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/offsetmatchmatch_02.png\" width=\"561\" height=\"226\" title=\"offsetmatchmatch_02\"><\/a><\/p>\n<p>Y\u00eau c\u1ea7u \u1edf \u0111\u00e2y l\u00e0 ch\u00fang ta c\u1ea7n tra c\u1ee9u doanh thu c\u1ee7a Trung Qu\u1ed1c (China) v\u00e0o n\u0103m 2015. Ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p gi\u1eef Offset v\u00e0 Match nh\u01b0 th\u1ebf n\u00e0o? C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/10\/OFFSETMATCHMATCH_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11323\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/offsetmatchmatch_10.png\" width=\"559\" height=\"404\" title=\"offsetmatchmatch_10\"><\/a><\/p>\n<p>V\u1edbi ki\u1ebfn th\u1ee9c v\u1ec1 offset v\u00e0 match t\u1eeb video v\u00e0 g\u1ee3i \u00fd trong h\u00ecnh minh ho\u1ea1 ph\u00eda tr\u00ean, ch\u1eafc ch\u1eafn c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c s\u1ef1 k\u1ebft h\u1ee3p n\u00e0y \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch t\u1ed1t h\u01a1n. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/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\/2024\/12\/ex101_92019-nho-527.gif\" title=\"ex101_92019-nho-527\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a>\u00a0t\u1ea1i nh\u00e0<\/p>\n<\/blockquote>\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\/2024\/12\/ex101_92019-nho-527.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5919,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5918","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\/5918","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=5918"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5919"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}