{"id":6924,"date":"2024-12-21T16:31:15","date_gmt":"2024-12-21T16:31:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dung-ham-loc-trung-nhau-trong-excel-2010-2013-2016-2019\/"},"modified":"2024-12-21T16:31:15","modified_gmt":"2024-12-21T16:31:15","slug":"huong-dan-dung-ham-loc-trung-nhau-trong-excel-2010-2013-2016-2019","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-dung-ham-loc-trung-nhau-trong-excel-2010-2013-2016-2019\/","title":{"rendered":"H\u01b0\u01a1\u0301ng d\u00e2\u0303n d\u00f9ng h\u00e0m l\u1ecdc tru\u0300ng nhau trong Excel 2010, 2013, 2016, 2019"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"c\u00e1ch-l\u1ecdc-tr\u00f9ng-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-loc-gia-tri-trung-nhau-tren-excel-2010.html?cach-loc-trung-trong-excel\">\n<p style=\"text-align: justify\"><em>Ch\u1eafc h\u1eb3n b\u1ea1n c\u0169ng bi\u1ebft <strong>\u00a0L\u1ecdc tr\u00f9ng\u00a0 trong Excel<\/strong> lu\u00f4n l\u00e0 h\u00e0m c\u1ea7n thi\u1ebft v\u00e0 c\u01a1 b\u1ea3n, \u0111\u1eb7c bi\u1ec7t v\u1edbi c\u00e1c th\u1ed1ng k\u00ea v\u1ec1 kho h\u00e0ng hay nh\u00e2n s\u1ef1 c\u00f4ng ty. Trong b\u00e0i vi\u1ebft n\u00e0y,<a href=\"http:\/\/blog.ezworkapp.com\"><strong> H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn ca\u0301c ba\u0323n c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m l\u1ecdc tr\u00f9ng trong Excel<\/strong> m\u00f4\u0323t ca\u0301ch \u0111\u01a1n gia\u0309n va\u0300 nhanh nh\u00e2\u0301t<\/em>.<\/p>\n<\/blockquote>\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-6766ed525456f\" 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\/huong-dan-loc-gia-tri-trung-nhau-tren-excel-2010.html#Cac_vi_du_thuc_te\" title=\"C\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf\">C\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/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\/huong-dan-loc-gia-tri-trung-nhau-tren-excel-2010.html#Cac_buoc_thuc_hien\" title=\"C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_vi_du_thuc_te\"><\/span>C\u00e1c v\u00ed d\u1ee5 th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u00e1nh m\u1eafc l\u1ed7i tr\u00f9ng l\u1eb7p trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u l\u1edbn tr\u1ea3i su\u1ed1t m\u1ed9t th\u1eddi gian d\u00e0i, c\u00f4ng c\u1ee5 <strong>l\u1ecdc tr\u00f9ng trong excel<\/strong> \u0111\u00e3 xu\u1ea5t hi\u1ec7n r\u1ea5t s\u1edbm tr\u00ean excel c\u00e1c phi\u00ean b\u1ea3n c\u0169. T\u1eeb phi\u00ean b\u1ea3n excel 2007 tr\u1edf l\u00ean, s\u1ef1 c\u1ea3i thi\u1ec7n c\u1ee7a c\u00f4ng c\u1ee5 <strong>l\u1ecdc tr\u00f9ng trong excel<\/strong> \u0111\u00e3 hi\u1ec7u qu\u1ea3 m\u00e0 \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng b\u1ea3n th\u1ed1ng k\u00ea h\u00e0ng h\u00f3a sau l\u00e0m v\u00ed d\u1ee5.<\/p>\n<figure id=\"attachment_3283\" aria-describedby=\"caption-attachment-3283\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3283 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-26-1.png\" alt=\"B\u1ea3n k\u00ea h\u00e0ng h\u00f3a l\u00e0m v\u00ed d\u1ee5 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng nhau.\" width=\"600\" height=\"396\" title=\"1-26-1\"><figcaption id=\"caption-attachment-3283\" class=\"wp-caption-text\">B\u1ea3n k\u00ea h\u00e0ng h\u00f3a l\u00e0m v\u00ed d\u1ee5 l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng nhau.<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cac_buoc_thuc_hien\"><\/span>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en ph\u1ea7n gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc. T\u1ea1i v\u00ed d\u1ee5 n\u00e0y ch\u00fang ta b\u00f4i \u0111en c\u1ed9t m\u00e3 h\u00e0ng.<\/p>\n<figure id=\"attachment_3285\" aria-describedby=\"caption-attachment-3285\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3285 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-3-5.png\" alt=\"B\u00f4i \u0111en c\u00e1c gi\u00e1 tr\u1ecb\" width=\"600\" height=\"306\" title=\"2-3-5\"><figcaption id=\"caption-attachment-3285\" class=\"wp-caption-text\">B\u00f4i \u0111en c\u00e1c gi\u00e1 tr\u1ecb<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ee5c <strong><em>Home<\/em><\/strong>, t\u00ecm nh\u00f3m<strong><em> Styles<\/em><\/strong>, ch\u1ecdn <a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016.html\"><em><strong>Conditional Formatting<\/strong><\/em><\/a>, ti\u1ebfp t\u1ee5c ch\u1ecdn\u00a0<strong><em>Highlight Cells Rules<\/em><\/strong>, ch\u1ecdn <em><strong>Duplicate Value.<\/strong><\/em><\/p>\n<figure id=\"attachment_3286\" aria-describedby=\"caption-attachment-3286\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3286 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-2-3.png\" alt=\"Home - Conditional Formatting - Highlight Cells Rules - Duplicate Values\" width=\"600\" height=\"257\" title=\"3-2-3\"><figcaption id=\"caption-attachment-3286\" class=\"wp-caption-text\">Home \u2013 Conditional Formatting \u2013 Highlight Cells Rules \u2013 Duplicate Values<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 3:<\/strong> Trong b\u1ea3ng hi\u1ec7n ra, <strong><em>Values with<\/em><\/strong> s\u1ebd c\u00f3 chu\u1ed7i c\u00e1c s\u1ef1 l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc \u0111\u1ec3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb n\u1ed5i b\u1eadt h\u01a1n. C\u00f2n \u1edf m\u1ee5c b\u00ean c\u1ea1nh, n\u1ebfu ch\u1ecdn <em><strong>Uniqu<\/strong>e<\/em>, excel 2010 s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb t\u1ed3n t\u1ea1i duy nh\u1ea5t trong chu\u1ed7i d\u1eef li\u1ec7u ch\u00fang ta b\u00f4i \u0111en.<\/p>\n<figure id=\"attachment_3288\" aria-describedby=\"caption-attachment-3288\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3288 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-3.png\" alt=\"Unique \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t\" width=\"600\" height=\"397\" title=\"5-2-3\"><figcaption id=\"caption-attachment-3288\" class=\"wp-caption-text\">Unique \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u1ec3 d\u00f9ng <strong>h\u00e0m l\u1ecdc tr\u00f9ng trong Excel<\/strong>, ta ch\u1ecdn <em><strong>Duplicate<\/strong><\/em>, r\u1ed3i <em><strong>Okay<\/strong><\/em>. V\u00e0 \u0111\u00e2y l\u00e0 c\u00e1c excel 2010 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb tr\u00f9ng sau khi l\u1ecdc.<\/p>\n<figure id=\"attachment_3289\" aria-describedby=\"caption-attachment-3289\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3289 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-1-2.png\" alt=\"Sau khi l\u1ecdc, gi\u00e1 tr\u1ecb tr\u00f9ng \u0111\u01b0\u1ee3c excel 10 hi\u1ec3n th\u1ecb n\u1ed5i b\u1eadt b\u1eb1ng ch\u1eef \u0111\u1ecf, \u0111\u1ed5 \u00f4 m\u00e0u \u0111\u1ecf\" width=\"600\" height=\"456\" title=\"6-1-2\"><figcaption id=\"caption-attachment-3289\" class=\"wp-caption-text\">Sau khi l\u1ecdc, gi\u00e1 tr\u1ecb tr\u00f9ng \u0111\u01b0\u1ee3c excel 10 hi\u1ec3n th\u1ecb n\u1ed5i b\u1eadt b\u1eb1ng ch\u1eef \u0111\u1ecf, \u0111\u1ed5 \u00f4 m\u00e0u \u0111\u1ecf<\/figcaption><\/figure>\n<p style=\"text-align: justify\">B\u1eb1ng 3 b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn c\u01a1 b\u1ea3n, r\u1ea5t mong c\u00f4ng c\u1ee5 <strong>l\u1ecdc tr\u00f9ng trong excel<\/strong> hay gi\u00e1 tr\u1ecb t\u1ed3n t\u1ea1i duy nh\u1ea5t s\u1ebd \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n v\u1edbi c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng Excel. N\u00ea\u0301u ca\u0301c ba\u0323n co\u0301 b\u00e2\u0301t ky\u0300 th\u0103\u0301c m\u0103\u0301c gi\u0300 co\u0301 th\u00ea\u0309 comment ngay d\u01b0\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y \u0111\u00ea\u0309 chu\u0301ng t\u00f4i co\u0301 th\u00ea\u0309 gia\u0309i quy\u00ea\u0301t mo\u0323i th\u0103\u0301c m\u0103\u0301c cu\u0309a ba\u0323n trong th\u01a1\u0300i gian s\u01a1\u0301m nh\u00e2\u0301t.<\/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-623.gif\" title=\"ex101_92019-nho-623\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 theo d\u00f5i video sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam m\u1ed9t c\u00e1ch n\u1eefa x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p:<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/6A2Q0LaW0zs?t=8s\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-dinh-dang-co-dieu-kien-trong-excel-2010-2013-va-2016.html\">C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel 2010, 2013 v\u00e0 2016<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-an-loi-na-bang-conditional-formatting-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n l\u1ed7i #N\/A b\u1eb1ng Conditional Formatting trong Excel<\/a><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang t\u00ecm hi\u1ec3u n\u1eb1m trong\u00a0kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia\u00a0c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>. Khi tham gia kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng<a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-trong-excel-va-cac-vi-du-minh-hoa.html\"><strong> c\u00e1c h\u00e0m trong excel<\/strong><\/a>, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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\/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-623.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6925,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6924","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\/6924","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=6924"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6924\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6925"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}