{"id":3783,"date":"2024-12-03T04:03:45","date_gmt":"2024-12-03T04:03:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel\/"},"modified":"2024-12-03T04:03:45","modified_gmt":"2024-12-03T04:03:45","slug":"cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ecdc ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span style=\"font-family: georgia, palatino, serif\">Trong b\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch l\u1ecdc ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t \u0111\u1ed9c nh\u1ea5t trong c\u1ed9t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch tinh ch\u1ec9nh c\u00f4ng th\u1ee9c \u0111\u00f3 cho c\u00e1c b\u1ed9 d\u1eef li\u1ec7u kh\u00e1c nhau. Ngo\u00e0i ra, <strong>H\u1ecdc Excel Online<\/strong> c\u0169ng s\u1ebd ch\u1ec9 cho c\u00e1c b\u1ea1n c\u00e1ch nhanh ch\u00f3ng nh\u1ea5t \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch ri\u00eang bi\u1ec7t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc n\u00e2ng cao c\u1ee7a Excel, <strong>h\u00e0m li\u1ec7t k\u00ea danh s\u00e1ch trong excel\u00a0<\/strong>v\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c h\u00e0ng duy nh\u1ea5t s\u1eed d\u1ee5ng Duplicate Remover.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 l\u1ecdc ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u00f3, l\u1ecdc ri\u00eang r\u1ed3i sao ch\u00e9p ch\u00fang. Tuy nhi\u00ean, s\u1eed d\u1ee5ng c\u00e1ch l\u00e0m n\u00e0y s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian, \u0111\u1ec3 th\u1ef1c hi\u1ec7n nhanh h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u1eb7c bi\u1ec7t c\u00f9ng v\u1edbi m\u1ed9t v\u00e0i k\u0129 thu\u1eadt kh\u00e1c m\u00e0 H\u1ecdc Excel Online s\u1ebd chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n ngay sau \u0111\u00e2y.<\/span><\/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-674e832061185\" 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-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cach_loc_ra_cac_gia_tri_duy_nhat_trong_Excel\" title=\"C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\">C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_mang_de_tim_ra_nhung_gia_tri_duy_nhat_hoan_thanh_cong_thuc_xong_ta_nhan_Ctrl_Shift_Enter\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Ctrl + Shift + Enter):\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Ctrl + Shift + Enter):<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_gia_tri_duy_nhat_thuong_xuyen_hoan_thanh_cong_thuc_xong_ta_nhan_Enter\" title=\"C\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t th\u01b0\u1eddng xuy\u00ean (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Enter):\">C\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t th\u01b0\u1eddng xuy\u00ean (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Enter):<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Trong_do\" title=\"Trong \u0111\u00f3:\">Trong \u0111\u00f3:<\/a><\/li>\n<\/ul>\n<\/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\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cach_loc_ra_cac_gia_tri_khac_biet_trong_Excel_duy_nhat_nhung_du_lieu_giong_nhau_se_chi_xuat_hien_mot_lan\" title=\"C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (duy nh\u1ea5t + nh\u1eefng d\u1eef li\u1ec7u gi\u1ed1ng nhau s\u1ebd ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n)\">C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (duy nh\u1ea5t + nh\u1eefng d\u1eef li\u1ec7u gi\u1ed1ng nhau s\u1ebd ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n)<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_mang_de_tim_nhung_gia_tri_khac_biet_nhan_Ctrl_Shift_Enter\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t (nh\u1ea5n Ctrl + Shift + Enter):\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t (nh\u1ea5n Ctrl + Shift + Enter):<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_chuan_de_tim_nhung_gia_tri_khac_biet\" title=\"C\u00f4ng th\u1ee9c chu\u1ea9n \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t\">C\u00f4ng th\u1ee9c chu\u1ea9n \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Trong_do-2\" title=\"Trong \u0111\u00f3:\">Trong \u0111\u00f3:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_trich_xuat_cac_gia_tri_khac_biet_khong_bao_gom_khoang_trong\" title=\"C\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00f4ng bao g\u1ed3m kho\u1ea3ng tr\u1ed1ng:\">C\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00f4ng bao g\u1ed3m kho\u1ea3ng tr\u1ed1ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cach_trich_xuat_cac_gia_tri_khac_nhau_phan_biet_chu_hoa_chu_thuong_trong_Excel\" title=\"C\u00e1ch tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\">C\u00e1ch tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cong_thuc_mang_de_nhan_cac_gia_tri_rieng_biet_theo_tung_truong_hop_nhan_Ctrl_Shift_Enter\" title=\"C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u1eadn c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p (nh\u1ea5n Ctrl + Shift + Enter)\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u1eadn c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p (nh\u1ea5n Ctrl + Shift + Enter)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Cach_hoat_dong_cua_cong_thuc_trich_xuat_cac_gia_tri_duy_nhat_khac_biet\" title=\"C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t\/ kh\u00e1c bi\u1ec7t\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t\/ kh\u00e1c bi\u1ec7t<\/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-13\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Trich_xuat_nhung_hang_duy_nhat_va_khac_biet_su_dung_Duplicate_Remover\" title=\"Tr\u00edch xu\u1ea5t nh\u1eefng h\u00e0ng duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t s\u1eed d\u1ee5ng Duplicate Remover\">Tr\u00edch xu\u1ea5t nh\u1eefng h\u00e0ng duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t s\u1eed d\u1ee5ng Duplicate Remover<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html#Gio_chung_ta_se_cung_xem_hoat_dong_cua_cong_cu_Duplicate_Remover\" title=\"Gi\u1edd ch\u00fang ta s\u1ebd c\u00f9ng xem ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng c\u1ee5 Duplicate Remover.\">Gi\u1edd ch\u00fang ta s\u1ebd c\u00f9ng xem ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng c\u1ee5 Duplicate Remover.<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_ra_cac_gia_tri_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn, \u0111\u1ea7u ti\u00ean, ch\u00fang ta c\u1ea7n hi\u1ec3u nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0o \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel. Gi\u00e1 tr\u1ecb duy nh\u1ea5t l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 t\u1ed3n t\u1ea1i duy nh\u1ea5t m\u1ed9t l\u1ea7n trong to\u00e0n b\u1ed9 danh s\u00e1ch. V\u00ed d\u1ee5:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7873\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-1-4.png\" width=\"267\" height=\"166\" title=\"1-1-4\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"> \u0110\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_de_tim_ra_nhung_gia_tri_duy_nhat_hoan_thanh_cong_thuc_xong_ta_nhan_Ctrl_Shift_Enter\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm ra nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Ctrl + Shift + Enter):<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">= IFERROR (INDEX ($ A $ 2: $ A $ 10, MATCH (0, COUNTIF ($ B $ 1: B1, $ A $ 2: $ A $ 10) + (COUNTIF ($ A $ 2: $ A $ 10, $ A $ 2: $ A $ 10) &lt;&gt; 1), 0)), \u201c\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_gia_tri_duy_nhat_thuong_xuyen_hoan_thanh_cong_thuc_xong_ta_nhan_Enter\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t th\u01b0\u1eddng xuy\u00ean (ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c xong ta nh\u1ea5n Enter):<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">= IFERROR (INDEX ($ A $ 2: $ A $ 10, MATCH (0, INDEX (COUNTIF ($ B $ 1: B1, $ A $ 2: $ A $ 10) + (COUNTIF ($ A $ 2: $ A $ 10, $ A $ 2 : $ A $ 10) &lt;&gt; 1), 0,0), 0)), \u201c\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Trong_do\"><\/span><span style=\"font-family: georgia, palatino, serif\">Trong \u0111\u00f3:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">A2: A10 \u2013 danh s\u00e1ch ngu\u1ed3n<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B1 \u2013 \u00f4 \u0111\u1ea7u c\u1ee7a danh s\u00e1ch duy nh\u1ea5t tr\u1eeb \u0111i 1. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta b\u1eaft \u0111\u1ea7u danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u1edf B2, v\u00e0 do \u0111\u00f3 ch\u00fang ta \u0111\u01b0a B1 v\u00e0o c\u00f4ng th\u1ee9c (B2-1 = B1). N\u1ebfu danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u \u1edf \u00f4 C3, ta s\u1ebd thay \u0111\u1ed5i $B$1:B1 th\u00e0nh $C$2:C2.<\/span><\/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-297.gif\" title=\"ex101_92019-nho-297\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-family: georgia, palatino, serif\">Ch\u00fa th\u00edch. B\u1edfi v\u00ec c\u00f4ng th\u1ee9c tham chi\u1ebfu \u00f4 b\u00ean tr\u00ean \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, th\u01b0\u1eddng l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t (nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 B1), n\u00ean b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea1n l\u00e0 m\u1ed9t t\u00ean duy nh\u1ea5t kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf b\u1ea5t c\u1ee9 \u0111\u00e2u trong c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u1ede v\u00ed d\u1ee5 n\u00e0y \u0111ang tr\u00edch xu\u1ea5t c\u00e1c t\u00ean duy nh\u1ea5t t\u1eeb c\u1ed9t A (ch\u00ednh x\u00e1c h\u01a1n l\u00e0 trong ph\u1ea1m vi A2: A20), v\u00e0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh sau s\u1ebd minh h\u1ecda cho c\u00f4ng th\u1ee9c s\u1ebd d\u00f9ng:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7874\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-12-2.png\" width=\"529\" height=\"307\" title=\"1-12-2\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"> D\u01b0\u1edbi \u0111\u00e2y l\u00e0 gi\u1ea3i th\u00edch m\u1ed9t c\u00e1ch chi ti\u1ebft v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u2013 L\u1ef1a ch\u1ecdn m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c d\u1ef1a theo d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t (trong v\u00ed d\u1ee5 s\u1ebd l\u00e0 \u00f4 B2).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 N\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng, nh\u1ea5n Ctrl + Shift + Enter. N\u1ebfu b\u1ea1n ch\u1ecdn c\u00f4ng th\u1ee9c b\u00ecnh th\u01b0\u1eddng, h\u00e3y nh\u1ea5n ph\u00edm Enter nh\u01b0 th\u01b0\u1eddng l\u1ec7.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e0ng xa c\u00e0ng t\u1ed1t b\u1eb1ng c\u00e1ch k\u00e9o ch\u1ed1t x\u1eed l\u00fd. V\u00ec c\u1ea3 hai c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u01b0\u1ee3c g\u00f3i g\u1ecdn trong h\u00e0m IFERROR, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn cu\u1ed1i b\u1ea3ng m\u00e0 kh\u00f4ng l\u00e0m l\u1ed9n x\u1ed9n d\u1eef li\u1ec7u v\u00ec b\u1ea5t k\u1ef3 l\u1ed7i n\u00e0o d\u00f9 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u00e3 \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t ra sao.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_ra_cac_gia_tri_khac_biet_trong_Excel_duy_nhat_nhung_du_lieu_giong_nhau_se_chi_xuat_hien_mot_lan\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch l\u1ecdc ra c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (duy nh\u1ea5t + nh\u1eefng d\u1eef li\u1ec7u gi\u1ed1ng nhau s\u1ebd ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n \u0111\u00e3 \u0111o\u00e1n ra t\u1eeb ti\u00eau \u0111\u1ec1 c\u1ee7a ph\u1ea7n n\u00e0y, c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau trong danh s\u00e1ch, t\u1ee9c l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u00f3 ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t d\u00f9 n\u00f3 c\u00f3 bao nhi\u00eau nh\u00e2n b\u1ea3n \u0111i ch\u0103ng n\u1eefa. V\u00ed d\u1ee5:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7875\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-11-1.png\" width=\"253\" height=\"165\" title=\"2-11-1\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"> \u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_de_tim_nhung_gia_tri_khac_biet_nhan_Ctrl_Shift_Enter\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t (nh\u1ea5n Ctrl + Shift + Enter):<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), \u201c\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_chuan_de_tim_nhung_gia_tri_khac_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c chu\u1ea9n \u0111\u1ec3 t\u00ecm nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$10), 0, 0), 0)), \u201c\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Trong_do-2\"><\/span><span style=\"font-family: georgia, palatino, serif\">Trong \u0111\u00f3:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">A2:A10 l\u00e0 danh s\u00e1ch ngu\u1ed3n<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B1 l\u00e0 \u00f4 n\u1eb1m ph\u00eda tr\u00ean c\u1ee7a danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t. Trong v\u00ed d\u1ee5 n\u00e0y, danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1eaft \u0111\u1ea7u \u1edf \u00f4 B2 (\u0111\u00e2y l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7876\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-10.png\" width=\"602\" height=\"294\" title=\"3-10\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"> Tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0o trong m\u1ed9t c\u1ed9t v\u00e0 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu danh s\u00e1ch ngu\u1ed3n c\u1ee7a b\u1ea1n ch\u1ee9a \u00f4 tr\u1ed1ng, th\u00ec nh\u1eefng c\u00f4ng th\u1ee9c ch\u00fang ra v\u1eeba n\u00eau \u1edf tr\u00ean s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 kh\u00f4ng cho m\u1ed7i h\u00e0ng tr\u1ed1ng. \u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, ch\u00fang ta c\u1ea7n c\u1ea3i ti\u1ebfn c\u00f4ng th\u1ee9c th\u00eam m\u1ed9t ch\u00fat.<\/span><\/p>\n<blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\"><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u<\/a>?<\/span><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_trich_xuat_cac_gia_tri_khac_biet_khong_bao_gom_khoang_trong\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t kh\u00f4ng bao g\u1ed3m kho\u1ea3ng tr\u1ed1ng:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10&amp;\u201d\u201d) + IF($A$2:$A$10=\u201d\u201d,1,0), 0)), \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Tr\u00edch xu\u1ea5t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n ri\u00eang bi\u1ec7t b\u1ecf qua s\u1ed1 v\u00e0 kho\u1ea3ng tr\u1ed1ng<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t tr\u1eeb c\u00e1c \u00f4 v\u00e0 \u00f4 tr\u1ed1ng c\u00f3 ch\u1ee9a s\u1ed1:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10&amp;\u201d\u201d) + IF(ISTEXT($A$2:$A$10)=FALSE,1,0), 0)), \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong \u0111\u00f3, A2: A10 l\u00e0 danh s\u00e1ch ngu\u1ed3n, v\u00e0 B1 l\u00e0 \u00f4 n\u1eb1m ngay tr\u00ean \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch ri\u00eang bi\u1ec7t.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau \u0111\u00e2y cho th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a c\u1ea3 hai c\u00f4ng th\u1ee9c tr\u00ean:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7877\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-11.png\" width=\"605\" height=\"387\" title=\"4-11\"><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_trich_xuat_cac_gia_tri_khac_nhau_phan_biet_chu_hoa_chu_thuong_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m nh\u01b0 trong tr\u01b0\u1eddng h\u1ee3p nh\u01b0 m\u1eadt kh\u1ea9u, t\u00ean ng\u01b0\u1eddi d\u00f9ng ho\u1eb7c t\u00ean t\u1ec7p, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i c\u00f3 danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t nh\u1ea1y c\u1ea3m v\u1edbi t\u1eebng ch\u1eef. Khi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau \u0111\u00e2y, v\u1edbi A2:A10 l\u00e0 danh s\u00e1ch ngu\u1ed3n, v\u00e0 B1 l\u00e0 \u00f4 n\u1eb1m tr\u00ean \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch ri\u00eang bi\u1ec7t:<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_mang_de_nhan_cac_gia_tri_rieng_biet_theo_tung_truong_hop_nhan_Ctrl_Shift_Enter\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 nh\u1eadn c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p (nh\u1ea5n Ctrl + Shift + Enter)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, FREQUENCY(IF(EXACT($A$2:$A$10,TRANSPOSE($B$1:B1)), MATCH(ROW($A$2:$A$10), ROW($A$2:$A$10)), \u201c\u201d), MATCH(ROW($A$2:$A$10), ROW($A$2:$A$10))), 0)), \u201c\u201d)<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7878\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-11.png\" width=\"539\" height=\"329\" title=\"5-11\"><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_hoat_dong_cua_cong_thuc_trich_xuat_cac_gia_tri_duy_nhat_khac_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t\/ kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Ph\u1ea7n n\u00e0y \u0111\u01b0\u1ee3c vi\u1ebft ri\u00eang cho nh\u1eefng ng\u01b0\u1eddi mu\u1ed1n hi\u1ec3u r\u00f5 v\u1ec1 nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0y m\u1ed9t c\u00e1ch c\u1ee5 th\u1ec3 nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Vi\u1ec7c tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel th\u1ef1c s\u1ef1 kh\u00f4ng ph\u1ea3i m\u1ed9t thao t\u00e1c \u0111\u01a1n gi\u1ea3n. Nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec1u \u0111\u01b0\u1ee3c d\u1ef1a tr\u00ean c\u00f9ng m\u1ed9t c\u00e1ch ti\u1ebfp c\u1eadn \u2013 s\u1eed d\u1ee5ng INDEX \/ MATCH k\u1ebft h\u1ee3p v\u1edbi h\u00e0m COUNTIF, ho\u1eb7c COUNTIF + IF.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 ph\u00e2n t\u00edch s\u00e2u h\u01a1n, ch\u00fang ta s\u1ebd c\u00f9ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 tr\u00edch ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1edfi v\u00ec t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn trong h\u01b0\u1edbng d\u1eabn n\u00e0y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea3i ti\u1ebfn ho\u1eb7c bi\u1ebfn th\u1ec3 t\u1eeb c\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), \u201c\u201d)<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7879\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-11.png\" width=\"603\" height=\"291\" title=\"6-11\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, ch\u00fang ta c\u00f3 th\u1ec3 b\u1ecf qua h\u00e0m IFERROR, h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi m\u1ed9t m\u1ee5c \u0111\u00edch duy nh\u1ea5t \u0111\u1ec3 lo\u1ea1i b\u1ecf l\u1ed7i # N\/A khi s\u1ed1 \u00f4 m\u00e0 b\u1ea1n \u0111\u00e3 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u01b0\u1ee3t qu\u00e1 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong danh s\u00e1ch ngu\u1ed3n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 nh\u1eefng ph\u1ea7n c\u1ed1t l\u00f5i trong c\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. COUNTIF(range, criteria) h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 \u00f4 trong m\u1ed9t ph\u1ea1m vi \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Nh\u01b0 \u1edf trong v\u00ed d\u1ee5 n\u00e0y, COUNTIF($B$1:B1, $A$2:$A$10) tr\u1ea3 v\u1ec1 m\u1ea3ng 1 v\u00e0 0 d\u1ef1a tr\u00ean b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o trong danh s\u00e1ch ngu\u1ed3n ($A$2:$A$10) xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ($B$1:B1). N\u1ebfu gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 1, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd tr\u1ea3 v\u1ec1 \u2013 0.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u1ee5 th\u1ec3, trong \u00f4 B2, COUNTIF($B$1:B1, $A$2:$A$10 tr\u1edf th\u00e0nh:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">COUNTIF(\u201cDistinct\u201d, {\u201cRonnie\u201d; \u201cDavid\u201d; \u201cSally\u201d; \u201cJeremy\u201d; \u201cRobert\u201d; \u201cDavid\u201d; \u201cRobert\u201d; \u201cTom\u201d; \u201cSally\u201d})<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00e0 tr\u1ea3 v\u1ec1:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">{0;0;0;0;0;0;0;0;0}<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u1ede \u0111\u00e2y, kh\u00f4ng c\u00f3 m\u1ee5c n\u00e0o trong danh s\u00e1ch ngu\u1ed3n (ti\u00eau ch\u00ed) xu\u1ea5t hi\u1ec7n trong ph\u1ea1m vi ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n t\u00ecm. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ph\u1ea1m vi ($B$1:B1) bao g\u1ed3m m\u1ed9t m\u1ee5c duy nh\u1ea5t \u2013 \u201cDistinct\u201d.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. MATCH (lookup_value, lookup_array, [match_type]) tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a gi\u00e1 tr\u1ecb \u0111ang t\u00ecm trong m\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Trong v\u00ed d\u1ee5 n\u00e0y, lookup_value l\u00e0 0, n\u00ean ta c\u00f3:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> MATCH(0,COUNTIF($B$1:B1, $A$2:$A$10), 0)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">tr\u1edf th\u00e0nh:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">MATCH(0, {0;0;0;0;0;0;0;0;0},0)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00e0 tr\u1ea3 v\u1ec1 1<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">B\u1edfi v\u00ec ch\u1ee9c n\u0103ng MATCH nh\u1eadn v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean c\u0169ng ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb \u0111ang \u0111ang t\u00ecm ki\u1ebfm (m\u00e0 gi\u00e1 tr\u1ecb \u0111ang t\u00ecm l\u00e0 0).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. INDEX(array, row_num, [column_num]) tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u1eb1m trong m\u1ed9t m\u1ea3ng d\u1ef1a tr\u00ean h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh v\u00e0 nh\u1eefng s\u1ed1 c\u1ed9t (t\u00f9y \u00fd).<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Trong v\u00ed d\u1ee5 n\u00e0y, INDEX($A$2:$A$10, 1)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Tr\u1edf th\u00e0nh:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">INDEX({\u201cRonnie\u201d; \u201cDavid\u201d; \u201cSally\u201d; \u201cJeremy\u201d; \u201cRobert\u201d; \u201cDavid\u201d; \u201cRobert\u201d; \u201cTom\u201d; \u201cSally\u201d}, 1)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00e0 tr\u1ea3 v\u1ec1 \u201cRonnie\u201d.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Khi c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sa ch\u00e9p xu\u1ed1ng c\u1ed9t, danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ($B$1:B1) s\u1ebd m\u1edf r\u1ed9ng h\u01a1n v\u00ec tham chi\u1ebfu th\u00eam \u00f4 th\u1ee9 hai (B1) l\u00e0 m\u1ed9t tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u2013 thay \u0111\u1ed5i theo v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a \u00f4 khi c\u00f4ng th\u1ee9c di chuy\u1ec3n sang \u00f4 kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Do \u0111\u00f3, khi sao ch\u00e9p c\u00f4ng th\u1ee9c sang \u00f4 B3, COUNTIF($B$1:B1, $A$2:$A$10) thay \u0111\u1ed5i th\u00e0nh COUNTIF($B$1:B2, $A$2:$A$10), v\u00e0 tr\u1edf th\u00e0nh:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">COUNTIF({\u201cDistinct\u201d;\u201dRonnie\u201d}, {\u201cRonnie\u201d; \u201cDavid\u201d; \u201cSally\u201d; \u201cJeremy\u201d; \u201cRobert\u201d; \u201cDavid\u201d; \u201cRobert\u201d; \u201cTom\u201d; \u201cSally\u201d}), 0)), \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">tr\u1ea3 v\u1ec1:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">{1;0;0;0;0;0;0;0;0}<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00ec c\u00f3 m\u1ed9t \u201cRonnie\u201d \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong ph\u1ea1m vi $B$1:B2.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">T\u1eeb \u0111\u00f3, MATCH(0,{1;0;0;0;0;0;0;0;0},0) tr\u1ea3 v\u1ec1 2, b\u1edfi v\u00ec 2 l\u00e0 v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a s\u1ed1 0 \u0111\u1ea7u ti\u00ean trong m\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Cu\u1ed1i c\u00f9ng, INDEX($A$2:$A$10, 2) tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb t\u1eeb h\u00e0ng th\u1ee9 2, \u0111\u00f3 l\u00e0 \u201cDavid\u201d.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">M\u1eb9o: \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u00ec logic c\u1ee7a c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c ph\u1ea7n kh\u00e1c nhau c\u1ee7a c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n f9 \u0111\u1ec3 xem \u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u1ea7n \u0111\u00f3:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7880\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-10.png\" width=\"463\" height=\"284\" title=\"7-10\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp, c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y d\u1ef1a tr\u00ean logic t\u01b0\u01a1ng t\u1ef1, nh\u01b0ng c\u00f3 th\u00eam ch\u00fat thay \u0111\u1ed5i:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u2013 ch\u1ee9a th\u00eam m\u1ed9t <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">h\u00e0m COUNTIF<\/a> lo\u1ea1i b\u1ecf nh\u1eefng m\u1ee5c xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n trong danh s\u00e1ch ngu\u1ed3n kh\u1ecfi danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t: kh\u1ecfi danh s\u00e1ch duy nh\u1ea5t t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch ngu\u1ed3n nhi\u1ec1u l\u1ea7n: COUNTIF($A$2:$A$10, $A$2:$A$10)&lt;&gt;1.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1ecf qua kho\u1ea3ng tr\u1eafng \u2013 \u1edf \u0111\u00e2y b\u1ea1n th\u00eam m\u1ed9t h\u00e0m IF \u0111\u1ec3 ng\u0103n kh\u00f4ng cho c\u00e1c \u00f4 tr\u1ed1ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o danh s\u00e1ch ri\u00eang bi\u1ec7t: IF($A$2:$A$13=\u201d\u201d,1,0).<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c bi\u1ec7t b\u1ecf qua c\u00e1c con s\u1ed1 \u2013 b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng ISTEXT \u0111\u1ec3 ki\u1ec3m tra xem gi\u00e1 tr\u1ecb c\u00f3 ph\u1ea3i l\u00e0 v\u0103n b\u1ea3n hay kh\u00f4ng, v\u00e0 ch\u1ee9c n\u0103ng IF \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i gi\u00e1 tr\u1ecb kh\u00e1c, bao g\u1ed3m c\u00e1c \u00f4 tr\u1ed1ng: IF(ISTEXT($A$2:$A$13)=FALSE,1,0).<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t t\u1eeb m\u1ed9t c\u1ed9t s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc n\u00e2ng cao \u2013 Advanced Filter c\u1ee7a Excel<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n l\u00e3ng ph\u00ed th\u1eddi gian \u0111\u1ec3 hi\u1ec3u c\u1eb7n k\u1ebd c\u00e1c c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng c\u00f3 \u0111\u01b0\u1ee3c danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc n\u00e2ng cao b\u1eb1ng c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 2. Chuy\u1ec3n sang tab Data &gt; Sort &amp; Filter v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Advanced:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7881\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-10.png\" width=\"428\" height=\"431\" title=\"8-10\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 3. Trong h\u1ed9p tho\u1ea1i Advanced Filter, b\u1ea1n ch\u1ecdn c\u00e1c tu\u1ef3 ch\u1ecdn sau:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Ki\u1ec3m tra n\u00fat Copy to another location.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Trong h\u1ed9p List range, x\u00e1c minh r\u1eb1ng ph\u1ea1m vi ngu\u1ed3n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Trong h\u1ed9p Copy to, nh\u1eadp ph\u1ea1m vi tr\u00ean c\u00f9ng c\u1ee7a d\u1ea3i \u00f4 b\u1ea1n mu\u1ed1n sao ch\u00e9p d\u1eef li\u1ec7u sang. L\u01b0u \u00fd l\u00e0 b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc v\u00e0o trang t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Ch\u1ecdn Unique records only.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7882\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-8.png\" width=\"443\" height=\"287\" title=\"9-8\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 4. Cu\u1ed1i c\u00f9ng, b\u1ea1n nh\u1ea5n OK v\u00e0 ki\u1ec3m tra l\u1ea1i k\u1ebft qu\u1ea3:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7883\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-7.png\" width=\"345\" height=\"234\" title=\"10-7\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> B\u1ea1n c\u1ea7n l\u01b0u \u00fd r\u1eb1ng, d\u00f9 t\u00f9y ch\u1ecdn c\u1ee7a Advanced Filter \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean l\u00e0 \u201cUnique records only\u201d (Ch\u1ec9 c\u00f3 nh\u1eefng b\u1ea3n ghi duy nh\u1ea5t) tuy nhi\u00ean n\u00f3 v\u1eabn tr\u00edch xu\u1ea5t nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t, ngh\u0129a l\u00e0 bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t v\u00e0 m\u1ed9t l\u1ea7n xu\u1ea5t hi\u1ec7n chung cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Trich_xuat_nhung_hang_duy_nhat_va_khac_biet_su_dung_Duplicate_Remover\"><\/span><span style=\"font-family: georgia, palatino, serif\">Tr\u00edch xu\u1ea5t nh\u1eefng h\u00e0ng duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t s\u1eed d\u1ee5ng Duplicate Remover<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong ph\u1ea7n cu\u1ed1i c\u00f9ng c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, H\u1ecdc Excel Online s\u1ebd ch\u1ec9 cho b\u1ea1n gi\u1ea3i ph\u00e1p t\u00ecm v\u00e0 tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t v\u00e0 \u0111\u1ed9c nh\u1ea5t trong c\u00e1c trang t\u00ednh c\u1ee7a Excel. Gi\u1ea3i ph\u00e1p n\u00e0y k\u1ebft h\u1ee3p linh ho\u1ea1t c\u00e1c c\u00f4ng th\u1ee9c Excel v\u00e0 m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng \u0111\u01a1n gi\u1ea3n c\u1ee7a advanced filter. Ngo\u00e0i ra, gi\u1ea3i ph\u00e1p n\u00e0y c\u00f2n cung c\u1ea5p m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng r\u1ea5t \u0111\u1ed9c \u0111\u00e1o nh\u01b0:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u2013 T\u00ecm v\u00e0 tr\u00edch xu\u1ea5t c\u00e1c h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 T\u00ecm, \u0111\u00e1nh d\u1ea5u v\u00e0 sao ch\u00e9p gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u1ebfn b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o kh\u00e1c, trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh ho\u1eb7c sang b\u1ea3ng t\u00ednh kh\u00e1c.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Gio_chung_ta_se_cung_xem_hoat_dong_cua_cong_cu_Duplicate_Remover\"><\/span><span style=\"font-family: georgia, palatino, serif\">Gi\u1edd ch\u00fang ta s\u1ebd c\u00f9ng xem ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng c\u1ee5 Duplicate Remover.<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00f3m t\u1eaft \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1eb1ng c\u00e1ch h\u1ee3p nh\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t s\u1ed1 b\u1ea3ng kh\u00e1c. C\u00f3 th\u1ec3 th\u1ea5y r\u00f5 r\u00e0ng r\u1eb1ng b\u1ea3ng t\u00f3m t\u1eaft ch\u1ee9a r\u1ea5t nhi\u1ec1u h\u00e0ng tr\u00f9ng l\u1eb7p v\u00e0 nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n l\u00e0 tr\u00edch xu\u1ea5t h\u00e0ng duy nh\u1ea5t xu\u1ea5t hi\u1ec7n trong b\u1ea3ng ch\u1ec9 m\u1ed9t l\u1ea7n ho\u1eb7c c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t bao g\u1ed3m nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n duy nh\u1ea5t m\u1ed9t l\u1ea7n v\u00e0 m\u1ed9t l\u1ea7n xu\u1ea5t hi\u1ec7n chung cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p. S\u1eed d\u1ee5ng Duplicate Remover c\u00f4ng vi\u1ec7c s\u1ebd \u0111\u01b0\u1ee3c ho\u00e0n t\u1ea5t trong 5 b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">1. Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng ngu\u1ed3n c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p n\u00fat Duplicate Remover tr\u00ean tab Ablebits Data, trong nh\u00f3m Dedupe.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7884\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-7.png\" width=\"381\" height=\"423\" title=\"11-7\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Th\u1ee7 thu\u1eadt Duplicate Remover s\u1ebd ch\u1ea1y v\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng. V\u00ec v\u1eady, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o Next \u0111\u1ec3 ti\u1ebfp t\u1ee5c b\u01b0\u1edbc ti\u1ebfp theo.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7885\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-7.png\" width=\"633\" height=\"539\" title=\"12-7\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Ch\u1ecdn lo\u1ea1i gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm v\u00e0 nh\u1ea5p v\u00e0o Next:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Ph\u1ee5 thu\u1ed9c v\u00e0o nhu c\u1ea7u tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u1ec3 ch\u1ecdn Unique (duy nh\u1ea5t) ho\u1eb7c Unique +1st occurrences (distinct) (Nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 m\u1ed9t l\u1ea7n xu\u1ea5t hi\u1ec7n chung cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p).<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta mu\u1ed1n tr\u00edch xu\u1ea5t c\u00e1c h\u00e0ng xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t trong b\u1ea3ng ngu\u1ed3n n\u00ean ta s\u1ebd ch\u1ecdn Unique:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7886\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-7.png\" width=\"647\" height=\"551\" title=\"13-7\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">M\u1eb9o: Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u00f3 hai l\u1ef1a ch\u1ecdn d\u00e0nh cho nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n, nh\u01b0ng b\u1ea1n c\u1ea7n nh\u1edb l\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1ea7m l\u1eabn v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh kh\u00e1c.<\/span><\/p>\n<blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">Xem ngay: <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt Excel hay<\/a>\u00a0m\u1ecdi th\u1eddi \u0111\u1ea1i<\/span><\/p>\n<\/blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">3. Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Nh\u01b0 trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u1ea7n t\u00ecm ra m\u1ed9t h\u00e0ng duy nh\u1ea5t d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ea3 ba c\u1ed9t (Order number, First name and Last name), v\u00ec th\u1ebf ch\u00fang ta s\u1ebd ch\u1ecdn t\u1ea5t c\u1ea3.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7887\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-5.png\" width=\"635\" height=\"545\" title=\"14-5\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 4. Ch\u1ecdn ra t\u00f9y ch\u1ecdn c\u1ea7n \u00e1p d\u1ee5ng cho nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u00ecm \u0111\u01b0\u1ee3c d\u1ef1a tr\u00ean c\u00e1c l\u1ef1a ch\u1ecdn c\u00f3 s\u1eb5n sau \u0111\u00e2y:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Highlight unique values \u2013 \u0110\u00e1nh gi\u00e1 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Select unique values \u2013 Ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Identify in a status column \u2013 X\u00e1c \u0111\u1ecbnh trong c\u1ed9t tr\u1ea1ng th\u00e1i<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u2013 Copy to another location \u2013 Sao ch\u00e9p sang v\u1ecb tr\u00ed kh\u00e1c<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ec ch\u00fang ta \u0111ang c\u1ea7n chi\u1ebft xu\u1ea5t c\u00e1c h\u00e0ng duy nh\u1ea5t, ch\u1ecdn Copy to another location v\u00e0 sau \u0111\u00f3 ch\u1ec9 \u0111\u1ecbnh v\u1ecb tr\u00ed ch\u00ednh x\u00e1c c\u1ea7n sao ch\u00e9p ch\u00fang \u2013 v\u1ecb tr\u00ed \u0111\u00f3 ph\u1ea3i l\u00e0 m\u1ed9t b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng (ch\u1ecdn tu\u1ef3 ch\u1ecdn Custom location v\u00e0 ch\u1ec9 \u0111\u1ecbnh \u00f4 tr\u00ean c\u00f9ng c\u1ee7a d\u1ea3i \u0111\u00edch), ho\u1eb7c v\u1ecb tr\u00ed mu\u1ed1n sao ch\u00e9p \u0111\u00f3 ph\u1ea3i l\u00e0 b\u1ea3ng t\u00ednh m\u1edbi.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta h\u00e3y ch\u1ecdn trang t\u00ednh m\u1edbi:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7888\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-4.png\" width=\"641\" height=\"545\" title=\"15-4\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> 5. Ch\u1ecdn Finish, nh\u01b0 v\u1eady l\u00e0 \u0111\u00e3 th\u1ef1c hi\u1ec7n xong.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7889\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-5.png\" width=\"480\" height=\"369\" title=\"16-5\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Hy v\u1ecdng b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng tr\u00edch xu\u1ea5t \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c c\u00e1c h\u00e0ng b\u1ea1n c\u1ea7n trong Excel.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u2014\u2014\u2014<\/span><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2Myqxpe\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. 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. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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-297.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3784,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3783","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\/3783","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=3783"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3784"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}