{"id":11596,"date":"2025-01-15T04:26:22","date_gmt":"2025-01-15T04:26:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-hop-nhat-hai-danh-sach-va-loai-bo-het-gia-tri-trung-trong-excel\/"},"modified":"2025-01-15T04:26:22","modified_gmt":"2025-01-15T04:26:22","slug":"cach-hop-nhat-hai-danh-sach-va-loai-bo-het-gia-tri-trung-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-hop-nhat-hai-danh-sach-va-loai-bo-het-gia-tri-trung-trong-excel\/","title":{"rendered":"C\u00e1ch h\u1ee3p nh\u1ea5t hai danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf h\u1ebft gi\u00e1 tr\u1ecb tr\u00f9ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">C\u00f3 hai danh s\u00e1ch trong trang t\u00ednh, m\u1ed9t v\u00e0i gi\u00e1 tr\u1ecb trong c\u00e1c danh s\u00e1ch b\u1ecb tr\u00f9ng l\u1eb7p. N\u1ebfu b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p hai danh s\u00e1ch n\u00e0y v\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n nh\u01b0 h\u00ecnh sau, b\u1ea1n ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7181\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-33.png\" width=\"399\" height=\"229\" title=\"untitled-33\"><\/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-678738ed9b75f\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-hop-nhat-hai-danh-sach-va-loai-bo-het-gia-tri-trung-trong-excel.html#Hop_nhat_cac_danh_sach_va_loai_bo_cac_gia_tri_trung_lap_bang_Remove_Duplicates\" title=\"H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p b\u1eb1ng Remove Duplicates\">H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p b\u1eb1ng Remove Duplicates<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-hop-nhat-hai-danh-sach-va-loai-bo-het-gia-tri-trung-trong-excel.html#Hop_nhat_cac_danh_sach_va_loai_bo_gia_tri_trung_bang_VBA\" title=\"H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng VBA\">H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hop_nhat_cac_danh_sach_va_loai_bo_cac_gia_tri_trung_lap_bang_Remove_Duplicates\"><\/span><strong>H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p b\u1eb1ng Remove Duplicates<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft h\u1ee3p hai danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">1. Sao ch\u00e9p m\u1ed9t trong hai danh s\u00e1ch v\u00e0 d\u00e1n n\u00f3 v\u00e0o cu\u1ed1i danh s\u00e1ch c\u00f2n l\u1ea1i nh\u01b0 h\u00ecnh sau:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7182\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/untitled-34.png\" width=\"405\" height=\"283\" title=\"untitled-34\"><\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn danh s\u00e1ch v\u00e0 nh\u1ea5p v\u00e0o\u00a0<em><strong>Data &gt; Remove Duplicates<\/strong><\/em><\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7183\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-4.png\" width=\"532\" height=\"116\" title=\"doc-combine-lists-without-dulicates-4\"><\/p>\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\/2025\/01\/vba101_92019-nho-50.gif\" title=\"vba101_92019-nho-50\"><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\/2025\/01\/ex101_92019-nho-310.gif\" title=\"ex101_92019-nho-310\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">3. Trong h\u1ed9p tho\u1ea1i <em><strong>Remove Duplicates<\/strong><\/em>, n\u1ebfu c\u1ed9t kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1, b\u1ecf ch\u1ecdn <em><strong>My data has headers<\/strong><\/em>\u00a0v\u00e0 nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7184\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-5.png\" width=\"600\" height=\"321\" title=\"doc-combine-lists-without-dulicates-5\"><\/p>\n<p style=\"text-align: justify\">4. Sau \u0111\u00f3, h\u1ed9p tho\u1ea1i hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh s\u1ebd cho b\u1ea1n bi\u1ebft nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eafp n\u00e0o v\u1eeba \u0111\u01b0\u1ee3c x\u00f3a, nh\u1ea5n OK.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-6.png\" title=\"doc-combine-lists-without-dulicates-6\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/imgseo\/doc-combine-lists-without-dulicates-2.png\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Hop_nhat_cac_danh_sach_va_loai_bo_gia_tri_trung_bang_VBA\"><\/span><strong>H\u1ee3p nh\u1ea5t c\u00e1c danh s\u00e1ch v\u00e0 lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng b\u1eb1ng VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Excel, <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-lap-trinh-vba-tu-dong-hoa-excel-voi-hoc-excel-online.html\" target=\"_blank\">VBA<\/a> c\u0169ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y.<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0<em><strong>Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 <em><strong>Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5p <em><strong>Insert &gt; Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o <em><strong>Module Window<\/strong><\/em>.<\/p>\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">FindUniques()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"vb comments\">'Updateby20140313<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rng <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">InputRng <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range, OutRng <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb plain\">xTitleId = <\/code><code class=\"vb string\">\"KutoolsforExcel\"<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">InputRng = Application.Selection<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">InputRng = Application.InputBox(<\/code><code class=\"vb string\">\"Range :\"<\/code><code class=\"vb plain\">, xTitleId, InputRng.Address, Type:=8)<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">OutRng = Application.InputBox(<\/code><code class=\"vb string\">\"Out put to (single cell):\"<\/code><code class=\"vb plain\">, xTitleId, Type:=8)<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">dic = CreateObject(<\/code><code class=\"vb string\">\"Scripting.Dictionary\"<\/code><code class=\"vb plain\">)<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"vb keyword\">For<\/code> <code class=\"vb plain\">j = 1 <\/code><code class=\"vb keyword\">To<\/code> <code class=\"vb plain\">InputRng.Columns.Count<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb plain\">i = 1 <\/code><code class=\"vb keyword\">To<\/code> <code class=\"vb plain\">InputRng.Rows.Count<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">xValue = InputRng.Cells(i, j).Value<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb plain\">xValue &lt;&gt; <\/code><code class=\"vb string\">\"\"<\/code> <code class=\"vb keyword\">And<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">dic.Exists(xValue) <\/code><code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">OutRng.Value = xValue<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">dic(xValue) = <\/code><code class=\"vb string\">\"\"<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">OutRng = OutRng.Offset(1, 0)<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"vb keyword\">Next<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<p style=\"text-align: justify\">3. Nh\u1ea5n\u00a0<em><strong>F5 <\/strong><\/em>ho\u1eb7c\u00a0<em><strong>Run\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, trong h\u1ed9p tho\u1ea1i hi\u1ec7n ra, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-7.png\" title=\"doc-combine-lists-without-dulicates-7\"><\/p>\n<p style=\"text-align: justify\">4. Nh\u1ea5n OK, m\u1ed9t h\u1ed9p tho\u1ea1i kh\u00e1c hi\u1ec7n ra cho b\u1ea1n ch\u1ecdn \u00f4 t\u00ednh \u0111\u1ec3 xu\u1ea5t k\u1ebft qu\u1ea3 h\u1ee3p nh\u1ea5t nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-8.png\" title=\"doc-combine-lists-without-dulicates-8\"><\/p>\n<p style=\"text-align: justify\">6. Nh\u1ea5n OK.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-combine-lists-without-dulicates-13.png\" title=\"doc-combine-lists-without-dulicates-13\"><\/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<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\/2025\/01\/vba101_92019-nho-50.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11597,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11596","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11596","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=11596"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11596\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11597"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}