{"id":801,"date":"2024-12-02T02:51:18","date_gmt":"2024-12-02T02:51:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/so-sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau\/"},"modified":"2024-12-02T02:51:18","modified_gmt":"2024-12-02T02:51:18","slug":"so-sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/so-sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau\/","title":{"rendered":"So s\u00e1nh hai danh s\u00e1ch v\u00e0 t\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n gi\u1ed1ng nhau, kh\u00e1c nhau"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u1eeba r\u1ed3i <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> c\u00f3 nh\u1eadn\u00a0\u0111\u01b0\u1ee3c 1 c\u00e2u h\u1ecfi kh\u00e1 th\u00fa v\u1ecb nh\u01b0 sau:<\/p>\n<ul>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 so s\u00e1nh 2 danh s\u00e1ch\u00a0\u1edf 2 sheet kh\u00e1c nhau?<\/li>\n<li>L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 t\u00e1ch (l\u1ea5y) ra\u00a0\u0111\u01b0\u1ee3c nh\u1eefng n\u1ed9i dung xu\u1ea5t hi\u1ec7n\u00a0\u0111\u1ed3ng th\u1eddi trong c\u1ea3 2 danh s\u00e1ch n\u00e0y?<\/li>\n<li>L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 t\u00e1ch (l\u1ea5y) ra\u00a0\u0111\u01b0\u1ee3c nh\u1eefng n\u1ed9i dung ch\u1ec9 c\u00f3\u00a0\u1edf danh s\u00e1ch A m\u00e0 kh\u00f4ng c\u00f3 trong danh s\u00e1ch B?<\/li>\n<li>L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 t\u00e1ch (l\u1ea5y) ra\u00a0\u0111\u01b0\u1ee3c nh\u1eefng n\u1ed9i dung ch\u1ec9 c\u00f3\u00a0\u1edf danh s\u00e1ch B m\u00e0 kh\u00f4ng c\u00f3 trong danh s\u00e1ch A?<\/li>\n<\/ul>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 m\u00ecnh tr\u1ea3 l\u1eddi\u00a0\u0111\u01b0\u1ee3c c\u00e2u h\u1ecfi n\u00e0y kh\u00f4ng?\u00a0H\u00e3y\u00a0\u0111\u1ec3 H\u1ecdc\u00a0Excel Online g\u1ee3i\u00a0\u00fd cho b\u1ea1n 1 c\u00e1ch l\u00e0m nh\u00e9:<\/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-674d20a58b384\" 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\/sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau.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-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau.html#2_Cach_lam\" title=\"2. C\u00e1ch l\u00e0m\">2. C\u00e1ch l\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau.html#21_Xay_dung_ham_COUNTIF\" title=\"2.1. X\u00e2y d\u1ef1ng h\u00e0m COUNTIF\">2.1. X\u00e2y d\u1ef1ng h\u00e0m COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau.html#22_Thao_tac_loc\" title=\"2.2. Thao t\u00e1c l\u1ecdc\">2.2. Thao t\u00e1c l\u1ecdc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/sanh-hai-danh-sach-va-tach-cac-thanh-phan-giong-nhau-khac-nhau.html#23_Thao_tac_lay_du_lieu\" title=\"2.3. Thao t\u00e1c l\u1ea5y d\u1eef li\u1ec7u\">2.3. Thao t\u00e1c l\u1ea5y d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><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><\/h2>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 2 danh s\u00e1ch n\u1eb1m tr\u00ean 2 sheet kh\u00e1c nhau, g\u1ecdi l\u00e0 Sheet A v\u00e0 Sheet B, t\u01b0\u01a1ng\u00a0\u1ee9ng l\u00e0 Danh s\u00e1ch A n\u1eb1m\u00a0\u1edf Sheet A, Danh s\u00e1ch B n\u1eb1m\u00a0\u1edf Sheet B<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15736\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-so-sanh-01.png\" width=\"409\" height=\"295\" title=\"heo-so-sanh-01\"><\/p>\n<p>Th\u1ef1c hi\u1ec7n so s\u00e1nh 2 danh s\u00e1ch = so s\u00e1nh t\u1eebng gi\u00e1 tr\u1ecb trong danh s\u00e1ch n\u00e0y v\u1edbi to\u00e0n b\u1ed9 danh s\u00e1ch kia.\u00a0\u0110\u00e2y l\u00e0 vi\u1ec7c thay\u00a0\u0111\u1ed5i c\u00e1ch di\u1ec5n\u00a0\u0111\u1ea1t\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 h\u00ecnh dung ra\u00a0\u0111\u01b0\u1ee3c c\u00e2u l\u1ec7nh s\u1ebd s\u1eed d\u1ee5ng (L\u1ec7nh COUNTIF)<\/p>\n<p>Vi\u1ec7c t\u00e1ch (l\u1ea5y) d\u1eef li\u1ec7u s\u1ebd bao g\u1ed3m 2 th\u1ee7 t\u1ee5c:<\/p>\n<ul>\n<li>L\u1ecdc d\u1eef li\u1ec7u d\u1ef1a v\u00e0o k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c so s\u00e1nh. T\u00f9y t\u1eebng y\u00eau c\u1ea7u d\u1eef li\u1ec7u c\u1ea7n l\u1ea5y s\u1ebd th\u1ef1c hi\u1ec7n l\u1ecdc theo n\u1ed9i dung t\u01b0\u01a1ng\u00a0\u1ee9ng.<\/li>\n<li>L\u1ea5y d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch Copy+Paste ho\u1eb7c k\u1ef9 thu\u1eadt l\u1ecdc d\u1eef li\u1ec7u kh\u00e1c (v\u00ed d\u1ee5 nh\u01b0 Advanced Filter)<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"2_Cach_lam\"><\/span>2. C\u00e1ch l\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"21_Xay_dung_ham_COUNTIF\"><\/span>2.1. X\u00e2y d\u1ef1ng h\u00e0m COUNTIF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Mu\u1ed1n so s\u00e1nh n\u1ed9i dung\u00a0\u1edf Danh s\u00e1ch B v\u1edbi danh s\u00e1ch A, ch\u00fang ta\u00a0\u0111\u1eb7t h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\">COUNTIF <\/a>t\u1ea1i sheet A nh\u01b0 sau:<\/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\/2024\/12\/vba101_92019-nho-16.gif\" title=\"vba101_92019-nho-16\"><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-46.gif\" title=\"ex101_92019-nho-46\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15737\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-so-sanh-02.png\" width=\"427\" height=\"296\" title=\"heo-so-sanh-02\"><\/p>\n<p>Trong\u00a0\u0111\u00f3 c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee7a h\u00e0m COUNTIF g\u1ed3m:<\/p>\n<p><strong>Range: V\u00f9ng c\u1ea7n so s\u00e1nh<\/strong> \u2013 l\u00e0 danh s\u00e1ch\u00a0\u1edf Sheet B, c\u1ed9t A. Khi\u00a0\u00e1p d\u1ee5ng tr\u00ean to\u00e0n b\u1ed9 c\u1ed9t A\u00a0\u1edf sheet B th\u00ec c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau: B!A:A<\/p>\n<p><strong>Criteria:\u00a0\u0110i\u1ec1u ki\u1ec7n c\u1ea7n so s\u00e1nh<\/strong> \u2013 l\u00e0 t\u1eebng gi\u00e1 tr\u1ecb\u00a0\u1edf danh s\u00e1ch A,\u00a0\u00e1p d\u1ee5ng t\u1eeb A2 t\u1edbi A10<\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi t\u1eebng gi\u00e1 tr\u1ecb trong danh s\u00e1ch A, ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1eb1ng 0: gi\u00e1 tr\u1ecb n\u00e0y\u00a0\u1edf danh s\u00e1ch A kh\u00f4ng c\u00f3 trong danh s\u00e1ch B<\/li>\n<li>B\u1eb1ng 1: Gi\u00e1 tr\u1ecb n\u00e0y\u00a0\u1edf danh s\u00e1ch A c\u00f3 c\u1ea3 trong danh s\u00e1ch B, xu\u1ea5t hi\u1ec7n 1 l\u1ea7n<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"22_Thao_tac_loc\"><\/span>2.2. Thao t\u00e1c l\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u00c1p d\u1ee5ng ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-trong-excel.html\">AutoFilter<\/a>\u00a0\u1edf Sheet A nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u\u00a0\u1edf Sheet A, g\u1ed3m 2 c\u1ed9t A v\u00e0 B<\/li>\n<li>Ch\u1ecdn tab Data &gt; ch\u1ecdn Filter<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-15738\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-so-sanh-03.png\" width=\"143\" height=\"158\" title=\"heo-so-sanh-03\"><\/p>\n<p><strong>\u0110\u1ec3 l\u1ecdc n\u1ed9i dung xu\u1ea5t hi\u1ec7n\u00a0\u0111\u1ed3ng th\u1eddi c\u1ea3 2 sheet, l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 1 t\u1ea1i c\u1ed9t B<\/strong><\/p>\n<p><strong>\u0110\u1ec3 l\u1ecdc n\u1ed9i dung ch\u1ec9 c\u00f3\u00a0\u1edf Danh s\u00e1ch A, kh\u00f4ng c\u00f3 trong danh s\u00e1ch B, l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 0 t\u1ea1i c\u1ed9t B<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"23_Thao_tac_lay_du_lieu\"><\/span>2.3. Thao t\u00e1c l\u1ea5y d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Copy c\u00e1c k\u1ebft qu\u1ea3 sau khi l\u1ecdc\u00a0\u1edf c\u1ed9t A<\/li>\n<li>D\u00e1n ph\u1ea7n gi\u00e1 tr\u1ecb\u00a0(<a href=\"http:\/\/blog.ezworkapp.com\/cach-thay-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel.html\">paste special \/ Value<\/a>) sang v\u00f9ng k\u1ebft qu\u1ea3<\/li>\n<\/ul>\n<p>Xem th\u00eam video d\u01b0\u1edbi\u00a0\u0111\u00e2y\u00a0\u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch th\u1ef1c hi\u1ec7n:<\/p>\n<iframe loading=\"lazy\" title=\"So sa\u0301nh 2 danh sa\u0301ch va\u0300 ta\u0301ch ra tha\u0300nh pha\u0302\u0300n gio\u0302\u0301ng nhau\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/SM1O4OXJ4D8?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>\u2014<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc\u00a0Excel Online!<\/p>\n<p><strong>Xem th\u00eam:<a href=\"http:\/\/blog.ezworkapp.com\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html\"> L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau t\u1eeb 2 c\u1ed9t trong excel<\/a> c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/strong><\/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\/2024\/12\/vba101_92019-nho-16.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":802,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-801","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\/801","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=801"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/801\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/802"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}