{"id":2055,"date":"2024-12-02T06:54:51","date_gmt":"2024-12-02T06:54:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/trich-loc-du-lieu-trung-lap-trong-nhieu-cot-nhieu-sheets\/"},"modified":"2024-12-02T06:54:51","modified_gmt":"2024-12-02T06:54:51","slug":"trich-loc-du-lieu-trung-lap-trong-nhieu-cot-nhieu-sheets","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/trich-loc-du-lieu-trung-lap-trong-nhieu-cot-nhieu-sheets\/","title":{"rendered":"Tr\u00edch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong nhi\u1ec1u c\u1ed9t nhi\u1ec1u sheets"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00f4 m\u00e0u d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong 1 c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <strong><code class=\"highlighter-rouge\">Conditional Formatting<\/code><\/strong> \/ <strong><code class=\"highlighter-rouge\">Highlight Cells Rules ...<\/code><\/strong> \/ <strong><code class=\"highlighter-rouge\">Duplicate Values ...<\/code><\/strong>.<\/p>\n<p>Vi\u1ec7c tr\u00edch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong nhi\u1ec1u c\u1ed9t v\u00e0 nhi\u1ec1u b\u1ea3ng t\u00ednh trong Excel v\u00e0 ti\u1ebfn h\u00e0nh ph\u00e2n t\u00edch d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 \u0111\u00f3 l\u00e0 m\u1ed9t ph\u1ea7n t\u1ea5t y\u1ebfu khi c\u00e1c b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel. C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c vi\u1ec7c n\u00e0y, tu\u1ef3 theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c, m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh g\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c mi\u00eau t\u1ea3 trong video sau \u0111\u00e2y, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i v\u00e0 chia s\u1ebb \u00fd ki\u1ebfn \u1edf trong ph\u1ea7n comment.<\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/UfGw1is2wxw?autoplay=1&amp;loop=1&amp;playlist=arCda8sm524&amp;modestbranding=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<h3 id=\"download\">Download:<\/h3>\n<p><a href=\"http:\/\/gofile.me\/5yKFU\/v5RcypMEY\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Download File Excel th\u1ef1c h\u00e0nh theo video<\/strong><\/a><\/p>\n<p>\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u\u00a0nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb c\u1ee7a VBA \u0111\u01b0\u1ee3c r\u1ed3i. VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook \u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p \u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u c\u1ee7a h\u1ec7 th\u1ed1ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><em><strong>H\u1ecdc Excel Online<\/strong><\/em><\/a>. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\"><strong>VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/strong><\/a><\/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":"<p>Ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00f4 m\u00e0u d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong 1..<\/p>\n","protected":false},"author":1,"featured_media":2056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2055","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\/2055","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=2055"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2055\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2056"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}