{"id":6960,"date":"2024-12-21T16:36:14","date_gmt":"2024-12-21T16:36:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot\/"},"modified":"2024-12-21T16:36:14","modified_gmt":"2024-12-21T16:36:14","slug":"loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot\/","title":{"rendered":"L\u1ecdc duy nh\u1ea5t theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n trong c\u1ed9t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/ham-unique-trong-excel-loc-gia-tri-duy-nhat-trong-vung.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Unique<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-filter-cach-su-dung-de-loc-du-lieu.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m Filter<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m COUNTIF<\/a> \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n trong m\u1ed9t c\u1ed9t; hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng <strong>h\u00e0m advanded filter<\/strong>. C\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>b\u1eaft \u0111\u1ea7u ngay th\u00f4i n\u00e0o<\/em><\/p>\n<figure id=\"attachment_31696\" aria-describedby=\"caption-attachment-31696\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31696\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot.png\" alt=\"L\u1ecdc duy nh\u1ea5t theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n\" width=\"500\" height=\"291\" title=\"loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot\"><\/a><figcaption id=\"caption-attachment-31696\" class=\"wp-caption-text\">L\u1ecdc duy nh\u1ea5t theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n<\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng \u1edf \u00f4 D5 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0:<\/p>\n<p><code class=\"excel-formula\">=UNIQUE(FILTER(data,COUNTIF(data,data)&gt;1))<\/code><\/p>\n<p>v\u1edbi data l\u00e0 Name Range tham chi\u1ebfu t\u1edbi v\u00f9ng d\u1eef li\u1ec7u g\u1ed1c c\u1ea7n l\u1ecdc B5:B16<\/p>\n<p>\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c tr\u00ean, ch\u00fang ta hay \u0111i t\u1eeb trong ra ngo\u00e0i nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">COUNTIF(data,data)<\/code><\/p>\n<p>ph\u1ea7n c\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0a v\u1ec1 gi\u00e1 tr\u1ecb l\u00e0 1 m\u1ea3ng:<\/p>\n<p><code class=\"excel-formula\">{3;1;3;3;2;1;1;3;1;2;3;3}<\/code><\/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-627.gif\" title=\"ex101_92019-nho-627\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>m\u1ea3ng gi\u00e1 tr\u1ecb n\u00e0y t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a t\u1eebng \u00f4 m\u00e0u s\u1eafc trong v\u00f9ng data: B5 (m\u00e0u \u0111\u1ecf) xu\u1ea5t hi\u1ec7n 3 l\u1ea7n, B6 (m\u00e0u v\u00e0ng) xu\u1ea5t hi\u1ec7n 1 l\u1ea7n, \u2026<\/p>\n<p>Sau \u0111\u00f3 \u0111\u1ec3 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 1 l\u1ea7n th\u00ec ch\u00fang ta s\u1ebd so s\u00e1nh v\u1edbi s\u1ed1 1<\/p>\n<p><code class=\"excel-formula\">COUNTIF(data,data)&gt;1<\/code><\/p>\n<p>v\u00e0 k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd l\u00e0<\/p>\n<p><code class=\"excel-formula\">{TRUE;FALSE;TRUE;TRUE;TRUE;FALSE;FALSE;TRUE;FALSE;TRUE;TRUE;TRUE}<\/code><\/p>\n<p>v\u1edbi k\u1ebft qu\u1ea3 l\u00e0 m\u1ea3ng g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE nh\u01b0 v\u1eady, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c v\u1edbi h\u00e0m FILTER, v\u1eady n\u00ean khi gh\u00e9p h\u00e0m FILTER v\u00e0o, ch\u00fang ta s\u1ebd l\u1ecdc \u0111\u01b0\u1ee3c ra nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n l\u1edbn h\u01a1n 1 l\u1ea7n trong m\u1ea3ng data.<\/p>\n<p><code class=\"excel-formula\">{\"\u0110\u1ecf\";\"Xanh\";\"Xanh\";\"Xanh lam\";\"\u0110\u1ecf\";\"Xanh lam\";\"\u0110\u1ecf\";\"Xanh\"}<\/code><\/p>\n<p>Sau \u0111\u00f3 ch\u00fang ta ch\u1ec9 vi\u1ec7c bao h\u00e0m Unique ra ngo\u00e0i k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m FILTER, nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 l\u1ecdc ra \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, nh\u01b0ng xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 1 l\u1ea7n trong m\u1ea3ng d\u1eef li\u1ec7u data:<\/p>\n<p><code class=\"excel-formula\">{\"\u0110\u1ecf\";\"Xanh\";\"Xanh lam\"}<\/code><\/p>\n<p>Nh\u01b0 v\u1eady t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 1 l\u1ea7n trong m\u1ea3ng d\u1eef li\u1ec7u th\u00ec ch\u00fang ta c\u00f3 c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t nh\u01b0ng xu\u1ea5t hi\u1ec7n nhi\u1ec1u h\u01a1n 2 l\u1ea7n trong m\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 trong \u00f4 F5 nh\u01b0 sau:<\/p>\n<p><code class=\"excel-formula\">=UNIQUE(FILTER(data,COUNTIF(data,data)&gt;2))<\/code><\/p>\n<p>Cu\u1ed1i c\u00f9ng, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i <a href=\"https:\/\/youtu.be\/qJF_EnwoBGY\" target=\"_blank\" rel=\"noopener noreferrer\">video<\/a> gi\u1ea3i th\u00edch c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/qJF_EnwoBGY\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><em>Nh\u01b0 v\u1eady b\u00e0i vi\u1ebft v\u1ec1 m\u1ed9t \u1ee9ng d\u1ee5ng s\u1eed d\u1ee5ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/loc-duy-nhat-theo-so-lan-xuat-hien-trong-cot.html\">h\u00e0m advanded filter<\/a><\/strong> \u2013 c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 \u0111\u1ec3 l\u1ecdc duy nh\u1ea5t, \u0111\u00e3 kh\u00e9p l\u1ea1i b\u00e0i h\u1ecdc h\u00f4m nay. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n, xin ch\u00e0o t\u1ea1m bi\u1ec7t!<\/em><\/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-627.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6961,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6960","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\/6960","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=6960"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6960\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6961"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}