{"id":3087,"date":"2024-12-02T09:59:21","date_gmt":"2024-12-02T09:59:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-dem-so-luong-gia-tri-duy-nhat-trong-1-vung\/"},"modified":"2024-12-02T09:59:21","modified_gmt":"2024-12-02T09:59:21","slug":"huong-dan-dem-so-luong-gia-tri-duy-nhat-trong-1-vung","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-dem-so-luong-gia-tri-duy-nhat-trong-1-vung\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb duy nh\u1ea5t trong 1 v\u00f9ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online <\/a><\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\"><strong>h\u00e0m counta<\/strong><\/a> \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c bao nhi\u00eau gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng l\u1eb7p (gi\u00e1 tr\u1ecb duy nh\u1ea5t) trong v\u00f9ng<\/em><\/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-674d84f8ef4bc\" 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\/dem-so-luong-gia-tri-duy-nhat-trong-vung.html#Voi_Excel_365_2019\" title=\"V\u1edbi Excel 365, 2019\">V\u1edbi Excel 365, 2019<\/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\/dem-so-luong-gia-tri-duy-nhat-trong-vung.html#Voi_cac_phien_ban_Excel_khac\" title=\"V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel kh\u00e1c\">V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dem-so-luong-gia-tri-duy-nhat-trong-vung.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Voi_Excel_365_2019\"><\/span>V\u1edbi Excel 365, 2019<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n \u0111ang d\u00f9ng Excel 365 th\u00ec vi\u1ec7c n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n,\u00a0 c\u1ee5 th\u1ec3 ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m counta nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=COUNTA(UNIQUE(A2:A15))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30948 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-5-1.png\" alt=\"huong-dan-su-dung-ham-counta-1\" width=\"776\" height=\"567\" title=\"1-5-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">V\u1edbi h\u00e0m UNIQUE, ta s\u1ebd l\u1ea5y ra danh s\u00e1ch duy nh\u1ea5t trong v\u00f9ng <strong>A2:A15<\/strong><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m unique t\u1ef1 \u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Excel<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3, h\u00e0m COUNTA s\u1ebd th\u1ef1c hi\u1ec7n \u0111\u1ebfm trong v\u00f9ng sau khi \u0111\u00e3 lo\u1ea1i \u0111i nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u0111\u00f3, ta \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 5 gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Voi_cac_phien_ban_Excel_khac\"><\/span>V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n kh\u00f4ng d\u00f9ng m\u1ed9t trong hai b\u1ea3n Excel tr\u00ean th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng c\u00f3 h\u00e0m counta nh\u01b0ng c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng, c\u1ee5 th\u1ec3 ta s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau \u0111\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 gi\u00e1 tr\u1ecb duy nh\u1ea5t trong 1 v\u00f9ng n\u00e0o \u0111\u00f3.<\/p>\n<blockquote>\n<p><strong>=SUM(1\/COUNTIF(A2:A15, A2:A15))<\/strong><\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30949 size-thumbnail\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-5-150x150-1.png\" alt=\"huong-dan-su-dung-ham-counta-2\" width=\"150\" height=\"150\" title=\"2-5-150x150-1\"><\/h2>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean ho\u1ea1t \u0111\u1ed9ng theo m\u1ea3ng.<\/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-98.gif\" title=\"vba101_92019-nho-98\"><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-233.gif\" title=\"ex101_92019-nho-233\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\"><em><strong>C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong Excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u h\u01a1n v\u1ec1 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o <strong>Evaluate Formula<\/strong> trong <strong>Tab Formulas<\/strong> v\u00e0 t\u1eebng b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u1ea5n <strong>Evaluate<\/strong> \u0111\u1ec3 xem c\u00e1ch th\u1ee9c Excel s\u1ebd t\u00ednh to\u00e1n c\u00f4ng th\u1ee9c tr\u00ean.<\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>L\u01b0u \u00fd<\/strong><\/span><\/p>\n<ul>\n<li style=\"text-align: justify\">V\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng tr\u00ean th\u00ec b\u1ea1n c\u1ea7n \u1ea5n <strong>Ctrl + Shift + Enter<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c <em>(Office 365, 2019 th\u00ec kh\u00f4ng c\u1ea7n)<\/em><\/li>\n<li style=\"text-align: justify\">C\u00f4ng th\u1ee9c =SUM(1\/COUNTIF(A2:A15, A2:A15)) nh\u01b0 tr\u00ean s\u1ebd \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho h\u1ea7u h\u1ebft c\u00e1c phi\u00ean b\u1ea3n Excel<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>H\u1ecdc Excel Online<\/strong> hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb duy nh\u1ea5t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng trong 1 v\u00f9ng m\u00e0 \u1edf \u0111\u00f3 c\u00f3 ch\u1ee9a nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p kh\u00e1c nhau; th\u00f4ng qua c\u00e1ch s\u1ee7 d\u1ee5ng h\u00e0m counta ho\u1eb7c c\u00e1ch kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\">Tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan<\/span><\/p>\n<hr>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m unique t\u1ef1 \u0111\u1ed9ng l\u1ecdc danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\">C\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng h\u1eb1ng s\u1ed1 m\u1ea3ng trong Excel, v\u00ed d\u1ee5 v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-danh-so-thu-tu-tu-dong-trong-excel-voi-ham-counta.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong excel v\u1edbi h\u00e0m counta<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-count-va-counta-de-dem-o-trong-excel.html\">C\u00e1ch d\u00f9ng h\u00e0m count v\u00e0 counta \u0111\u1ec3 \u0111\u1ebfm \u00f4 trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-countif-trong-ke-toan-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m countif trong k\u1ebf to\u00e1n excel<\/a><\/strong><\/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\/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-98.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3088,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3087","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\/3087","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=3087"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3087\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3088"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}