{"id":1785,"date":"2024-12-02T06:01:28","date_gmt":"2024-12-02T06:01:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau\/"},"modified":"2024-12-02T06:01:28","modified_gmt":"2024-12-02T06:01:28","slug":"cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau\/","title":{"rendered":"C\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t trong Excel: c\u00e1ch t\u00ecm ki\u1ebfm, l\u1ecdc, l\u1ef1a ch\u1ecdn v\u00e0 \u0111\u00e1nh d\u1ea5u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<h2><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong b\u00e0i vi\u1ebft l\u1ea7n n\u00e0y, H\u1ecdc Excel Online s\u1ebd ch\u1ec9 ra cho c\u00e1c b\u1ea1n c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 t\u00ecm ki\u1ebfm, ch\u1ecdn l\u1ecdc v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">H\u1ecdc Excel Online t\u1eebng h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t trong Excel \u1edf b\u00e0i vi\u1ebft tr\u01b0\u1edbc. Tuy nhi\u00ean, \u0111\u00f4i khi b\u1ea1n c\u00f2n mu\u1ed1n \u0111\u01b0\u1ee3c nh\u00ecn t\u1eadn m\u1eaft nh\u1eefng gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t ho\u1eb7c duy nh\u1ea5t trong m\u1ed9t c\u1ed9t, kh\u00f4ng ph\u1ea3i ch\u1ec9 nh\u00ecn v\u00e0o s\u1ed1 l\u01b0\u1ee3ng m\u00e0 nh\u00ecn v\u00e0o nh\u1eefng gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf. Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n, ch\u00fang ta h\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u xem gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t l\u00e0 g\u00ec v\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t l\u00e0 g\u00ec?<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u00e1 tr\u1ecb duy nh\u1ea5t l\u00e0 c\u00e1c m\u1ee5c xu\u1ea5t hi\u1ec7n trong t\u1eadp d\u1eef li\u1ec7u duy nh\u1ea5t m\u1ed9t l\u1ea7n.\u00a0<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c kh\u00e1c nhau trong danh s\u00e1ch, ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 nh\u1ea5t c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb nh\u00e2n b\u1ea3n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y c\u00f9ng nghi\u00ean c\u1ee9u c\u00e1c k\u1ef9 thu\u1eadt hi\u1ec7u qu\u1ea3 nh\u1ea5t \u00e1p d\u1ee5ng cho c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t trong b\u1ea3ng Excel.<\/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-674d4d373c126\" 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\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Tim_cac_gia_tri_duy_nhat_trong_mot_cot\" title=\"T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_tim_cac_gia_tri_duy_nhat_trong_Excel\" title=\"C\u00e1ch t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel:\">C\u00e1ch t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Tim_hang_duy_nhat_khac_biet_trong_Excel\" title=\"T\u00ecm h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel\">T\u00ecm h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t 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-4\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cong_thuc_de_tim_cac_hang_duy_nhat\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng duy nh\u1ea5t:\">C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng duy nh\u1ea5t:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cong_thuc_de_tim_cac_hang_khac_biet\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t:\">C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t:<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Tim_cac_gia_tri_duy_nhat_khac_biet_trong_Excel_phan_biet_chu_hoa_va_chu_thuong\" title=\"T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Tim_cac_gia_tri_duy_nhat_phan_biet_chu_hoa_va_chu_thuong\" title=\"T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:<\/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\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Tim_cac_gia_tri_rieng_biet_phan_biet_chu_hoa_va_chu_thuong\" title=\"T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_loc_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel\" title=\"C\u00e1ch l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel\">C\u00e1ch l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_chon_cac_gia_tri_khac_biet_doc_nhat\" title=\"C\u00e1ch ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t \/ \u0111\u1ed9c nh\u1ea5t\">C\u00e1ch ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t \/ \u0111\u1ed9c nh\u1ea5t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Sao_chep_cac_gia_tri_duy_nhat_hoac_khac_biet_den_vi_tri_khac\" title=\"Sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t \u0111\u1ebfn v\u1ecb tr\u00ed kh\u00e1c\">Sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t \u0111\u1ebfn v\u1ecb tr\u00ed kh\u00e1c<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_lam_noi_bat_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/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\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Danh_dau_cac_gia_tri_duy_nhat_trong_mot_cot_quy_tac_built-in\" title=\"\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t (quy t\u1eafc built-in)\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t (quy t\u1eafc built-in)<\/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\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Danh_dau_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel_quy_tac_tuy_chinh\" title=\"\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel (quy t\u1eafc t\u00f9y ch\u1ec9nh)\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel (quy t\u1eafc t\u00f9y ch\u1ec9nh)<\/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-15\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Danh_dau_cac_gia_tri_duy_nhat\" title=\"\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_tao_quy_tac_dua_tren_cong_thuc\" title=\"C\u00e1ch t\u1ea1o quy t\u1eafc d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c\">C\u00e1ch t\u1ea1o quy t\u1eafc d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Danh_dau_toan_bo_cac_hang_dua_tren_cac_gia_tri_duy_nhat_khac_biet_trong_mot_cot\" title=\"\u0110\u00e1nh d\u1ea5u to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong m\u1ed9t c\u1ed9t\">\u0110\u00e1nh d\u1ea5u to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong m\u1ed9t c\u1ed9t<\/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-18\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_lam_noi_bat_cac_hang_duy_nhat_trong_Excel\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng duy nh\u1ea5t trong Excel\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng duy nh\u1ea5t trong Excel<\/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-19\" href=\"https:\/\/blog.hocexcel.online\/cac-gia-tri-khac-biet-va-duy-nhat-trong-excel-cach-tim-kiem-loc-lua-chon-va-danh-dau.html#Cach_nhanh_va_de_dang_de_tim_va_danh_dau_cac_gia_tri_duy_nhat_trong_Excel\" title=\"C\u00e1ch nhanh v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\">C\u00e1ch nhanh v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tim_cac_gia_tri_duy_nhat_trong_mot_cot\"><\/span><span style=\"font-family: 'Times New Roman', Times\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t trong m\u1ed9t danh s\u00e1ch, b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau \u0111\u00e2y, trong \u0111\u00f3 A2 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 A10 l\u00e0 \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 d\u1eef li\u1ec7u.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tim_cac_gia_tri_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(COUNTIF($A$2:$A$10, $A2)=1, \u201cUnique\u201d, \u201c\u201d)<\/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-128.gif\" title=\"ex101_92019-nho-128\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(COUNTIF($A$2:$A2, $A2)=1, \u201cDistinct\u201d, \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong c\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ch\u1ec9 c\u00f3 m\u1ed9t \u0111\u1ed9 l\u1ec7ch nh\u1ecf trong tham chi\u1ebfu \u00f4 th\u1ee9 hai nh\u01b0ng l\u1ea1i t\u1ea1o ra m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7836\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9.png\" width=\"399\" height=\"300\" title=\"1-9\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tim_hang_duy_nhat_khac_biet_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">T\u00ecm h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm c\u00e1c h\u00e0ng duy nh\u1ea5t trong b\u1ea3ng Excel d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong 2 c\u1ed9t tr\u1edf l\u00ean. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m COUNTIFS thay v\u00ec COUNTIF \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00e0i c\u1ed9t (c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 \u0111\u01b0\u1ee3c t\u1edbi 127 ph\u1ea1m vi\/ c\u1eb7p ti\u00eau chu\u1ea9n trong m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n).<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u00ecm t\u00ean duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t trong danh s\u00e1ch, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_de_tim_cac_hang_duy_nhat\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng duy nh\u1ea5t:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(COUNTIFS($A$2:$A$10, $A2, $B$2:$B$10, $B2)=1, \u201cUnique row\u201d, \u201c\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_de_tim_cac_hang_khac_biet\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(COUNTIFS($A$2:$A2, $A2, $B$2:$B2, $B2)=1, \u201cDistinct row\u201d, \u201c\u201d)<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7837\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-8-1.png\" width=\"631\" height=\"308\" title=\"2-8-1\"><\/p>\n<h2><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tim_cac_gia_tri_duy_nhat_khac_biet_trong_Excel_phan_biet_chu_hoa_va_chu_thuong\"><\/span><span style=\"font-family: 'Times New Roman', Times\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 v\u1ea5n \u0111\u1ec1, b\u1ea1n c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng ph\u1ee9c t\u1ea1p h\u01a1n m\u1ed9t ch\u00fat.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tim_cac_gia_tri_duy_nhat_phan_biet_chu_hoa_va_chu_thuong\"><\/span><span style=\"font-family: 'Times New Roman', Times\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(SUM((\u2013EXACT($A$2:$A$10,A2)))=1,\u201dUnique\u201d,\u201d\u201d)<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tim_cac_gia_tri_rieng_biet_phan_biet_chu_hoa_va_chu_thuong\"><\/span><span style=\"font-family: 'Times New Roman', Times\">T\u00ecm c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(SUM((\u2013EXACT($A$2:$A2,$A2)))=1,\u201dDistinct\u201d,\u201d\u201d)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ec c\u1ea3 hai \u0111\u1ec1u l\u00e0 c\u00f4ng th\u1ee9c m\u1ea3ng, n\u00ean b\u1ea1n c\u1ea7n nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t ch\u00fang m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7838\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-7.png\" width=\"607\" height=\"302\" title=\"3-7\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Khi t\u00ecm th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u1ecdc, ch\u1ecdn v\u00e0 sao ch\u00e9p ch\u00fang nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 xem ri\u00eang c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t trong danh s\u00e1ch, ch\u00fang ta c\u1ea7n l\u1ecdc ch\u00fang ra b\u1eb1ng c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u00c1p d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Filter tr\u00ean tab Data. Ho\u1eb7c nh\u1ea5p v\u00e0o Sort &amp; Filter &gt; Filter tr\u00ean tab Trang ch\u1ee7 trong nh\u00f3m Editing.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1ea5p v\u00e0o m\u0169i t\u00ean Filter trong ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0 ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n xem:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7839\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-8.png\" width=\"594\" height=\"384\" title=\"4-8\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_chon_cac_gia_tri_khac_biet_doc_nhat\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t \/ \u0111\u1ed9c nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t t\u01b0\u01a1ng \u0111\u1ed1i nh\u1ecf, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn n\u00f3 theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch d\u00f9ng chu\u1ed9t. N\u1ebfu danh s\u00e1ch \u0111\u01b0\u1ee3c l\u1ecdc c\u00f3 h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ngh\u00ecn h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong s\u1ed1 c\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 nhanh ch\u00f3ng, b\u1ea1n ch\u1ecdn danh s\u00e1ch duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t bao g\u1ed3m ti\u00eau \u0111\u1ec1 c\u1ed9t, l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t, nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong danh s\u00e1ch duy nh\u1ea5t, sau \u0111\u00f3 nh\u1ea5n Ctrl + A.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ho\u1eb7c duy nh\u1ea5t m\u00e0 kh\u00f4ng c\u00f3 ti\u00eau \u0111\u1ec1 c\u1ed9t, h\u00e3y l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t, ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean v\u1edbi d\u1eef li\u1ec7u v\u00e0 nh\u1ea5n Ctrl + Shift + End \u0111\u1ec3 m\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn v\u00e0o \u00f4 cu\u1ed1i c\u00f9ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\"><strong>M\u1eb9o<\/strong>. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p hi\u1ebfm hoi, ch\u1ee7 y\u1ebfu l\u00e0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u qu\u00e1 l\u1edbn, c\u00e1c ph\u00edm t\u1eaft tr\u00ean c\u00f3 th\u1ec3 s\u1ebd ch\u1ecdn c\u1ea3 nh\u1eefng \u00f4 hi\u1ec3n th\u1ecb v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb. \u0110\u1ec3 kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y, nh\u1ea5n Ctrl + A ho\u1eb7c Ctrl + Shift + End \u0111\u1ea7u ti\u00ean, v\u00e0 sau \u0111\u00f3 nh\u1ea5n Alt +; \u0110\u1ec3 ch\u1ec9 ch\u1ecdn c\u00e1c \u00f4 hi\u1ec3n th\u1ecb, b\u1ecf qua h\u00e0ng \u1ea9n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n khi nh\u1edb nhi\u1ec1u ph\u00edm t\u1eaft, h\u00e3y s\u1eed d\u1ee5ng c\u00e1ch l\u00e0m tr\u1ef1c quan n\u00e0y: ch\u1ecdn to\u00e0n b\u1ed9 danh s\u00e1ch duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t, sau \u0111\u00f3 \u0111i t\u1edbi tab Trang ch\u1ee7&gt; Find &amp; Select &gt; \u0111i \u0111\u1ebfn ph\u1ea7n Special v\u00e0 ch\u1ecdn Visible cells only.<\/span><\/p>\n<h2><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Sao_chep_cac_gia_tri_duy_nhat_hoac_khac_biet_den_vi_tri_khac\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t \u0111\u1ebfn v\u1ecb tr\u00ed kh\u00e1c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 sao ch\u00e9p danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t sang v\u1ecb tr\u00ed kh\u00e1c, ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Ch\u1ecdn c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c l\u1ecdc b\u1eb1ng chu\u1ed9t ho\u1eb7c c\u00e1c ph\u00edm t\u1eaft \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 ch\u1ecdn.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Ch\u1ecdn \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i trong d\u1ea3i \u0111\u00edch (n\u00f3 c\u00f3 th\u1ec3 n\u1eb1m tr\u00ean c\u00f9ng m\u1ed9t t\u1edd ho\u1eb7c kh\u00e1c t\u1edd), v\u00e0 nh\u1ea5n Ctrl + V \u0111\u1ec3 d\u00e1n gi\u00e1 tr\u1ecb.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n c\u1ea7n l\u00e0m n\u1ed5i b\u1eadt b\u1ea5t c\u1ee9 \u0111i\u1ec1u g\u00ec trong Excel d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh, th\u00ec c\u1ea7n \u00e1p d\u1ee5ng t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_dau_cac_gia_tri_duy_nhat_trong_mot_cot_quy_tac_built-in\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t (quy t\u1eafc built-in)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch nhanh nh\u1ea5t v\u00e0 d\u1ec5 d\u00e0ng nh\u1ea5t \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel l\u00e0 \u00e1p d\u1ee5ng quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho s\u1eb5n:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. Ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Tr\u00ean tab Trang ch\u1ee7, trong nh\u00f3m Styles, ch\u1ecdn Conditional Formatting &gt; Highlight Cells Rules &gt;Duplicate Values\u2026<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7840\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-8.png\" width=\"439\" height=\"437\" title=\"5-8\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">3. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Duplicate Values, ch\u1ecdn Unique trong h\u1ed9p b\u00ean tay tr\u00e1i v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n trong h\u1ed9p b\u00ean ph\u1ea3i, sau \u0111\u00f3 nh\u1ea5n OK.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7841\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-8.png\" width=\"570\" height=\"246\" title=\"6-8\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">M\u1eb9o. N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp tr\u01b0\u1edbc, h\u00e3y nh\u1ea5p v\u00e0o Custom Format\u2026(m\u1ee5c cu\u1ed1i c\u00f9ng trong danh s\u00e1ch th\u1ea3 xu\u1ed1ng) v\u00e0 \u0111\u1eb7t m\u00e0u v\u00e0\/ ho\u1eb7c ph\u00f4ng ch\u1eef theo \u00fd th\u00edch c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n th\u1ea5y, l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng nhi\u1ec7m v\u1ee5 v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. Tuy nhi\u00ean, quy t\u1eafc \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong Excel ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng cho c\u00e1c m\u1ee5c xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch duy nh\u1ea5t m\u1ed9t l\u1ea7n. N\u1ebfu b\u1ea1n c\u1ea7n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t \u2013 g\u1ed3m 1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u2013 b\u1ea1n s\u1ebd ph\u1ea3i t\u1ea1o quy t\u1eafc c\u1ee7a ri\u00eang m\u00ecnh d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c. B\u1ea1n c\u0169ng c\u1ea7n ph\u1ea3i t\u1ea1o m\u1ed9t quy t\u1eafc t\u00f9y ch\u1ec9nh \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng duy nh\u1ea5t d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Danh_dau_cac_gia_tri_duy_nhat_va_khac_biet_trong_Excel_quy_tac_tuy_chinh\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel (quy t\u1eafc t\u00f9y ch\u1ec9nh)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t trong m\u1ed9t c\u1ed9t, h\u00e3y ch\u1ecdn d\u1eef li\u1ec7u nh\u01b0ng kh\u00f4ng bao g\u1ed3m ti\u00eau \u0111\u1ec1 c\u1ed9t (H\u1eb3n l\u00e0 b\u1ea1n c\u0169ng kh\u00f4ng mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt ti\u00eau \u0111\u1ec1 c\u1ed9t) V\u00e0 t\u1ea1o ra m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_dau_cac_gia_tri_duy_nhat\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong m\u1ed9t danh s\u00e1ch duy nh\u1ea5t m\u1ed9t l\u1ea7n, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$A$10,$A2)=1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u1edbi A2 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 A10 l\u00e0 \u00f4 cu\u1ed1i c\u00f9ng c\u1ee7a ph\u1ea1m vi \u00e1p d\u1ee5ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau trong m\u1ed9t c\u1ed9t, t\u1ee9c l\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, h\u00e3y l\u00e0m theo c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$A2,$A2)=1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u1edbi A2 l\u00e0 \u00f4 tr\u00ean c\u00f9ng c\u1ee7a d\u1ea3i.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tao_quy_tac_dua_tren_cong_thuc\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch t\u1ea1o quy t\u1eafc d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Chuy\u1ec3n \u0111\u1ebfn tab Trang ch\u1ee7&gt; Styles, ch\u1ecdn Conditional Formatting &gt; New rule &gt; Use a formula to determine which cells to format.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o ph\u1ea7n Format values where this formula is true.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1ea5p v\u00e0o n\u00fat Format\u2026 v\u00e0 ch\u1ecdn m\u00e0u ho\u1eb7c\/ v\u00e0 ph\u00f4ng ch\u1eef m\u00e0 b\u1ea1n mu\u1ed1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Cu\u1ed1i c\u00f9ng, nh\u1ea5p v\u00e0o n\u00fat OK \u0111\u1ec3 \u00e1p d\u1ee5ng quy t\u1eafc.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7842\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-7.png\" width=\"586\" height=\"414\" title=\"7-7\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi s\u1ebd cho b\u1ea1n th\u1ea5y c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a quy t\u1eafc tr\u00ean:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7843\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-7.png\" width=\"637\" height=\"547\" title=\"8-7\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_dau_toan_bo_cac_hang_dua_tren_cac_gia_tri_duy_nhat_khac_biet_trong_mot_cot\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e1nh d\u1ea5u to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong m\u1ed9t c\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 \u0111\u00e1nh d\u1ea5u to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c cho c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t m\u00e0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, nh\u01b0ng \u00e1p d\u1ee5ng quy t\u1eafc c\u1ee7a b\u1ea1n cho to\u00e0n b\u1ed9 b\u1ea3ng ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t c\u1ed9t \u0111\u01a1n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda quy t\u1eafc l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u ri\u00eang bi\u1ec7t trong c\u1ed9t A:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7844\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-1.png\" width=\"649\" height=\"475\" title=\"9-1\"><\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_hang_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng duy nh\u1ea5t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong 2 ho\u1eb7c nhi\u1ec1u c\u1ed9t, h\u00e3y s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng COUNTIFS cho ph\u00e9p ch\u1ec9 \u0111\u1ecbnh m\u1ed9t s\u1ed1 ti\u00eau ch\u00ed trong m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng duy nh\u1ea5t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIFS($A$2:$A$10,$A2, $B$2:$B$10,$B2)=1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t (c\u00e1c h\u00e0ng duy nh\u1ea5t c\u00f9ng v\u1edbi 1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho nh\u1eefng h\u00e0ng tr\u00f9ng l\u1eb7p)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)=1<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7845\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-6.png\" width=\"667\" height=\"591\" title=\"10-6\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_nhanh_va_de_dang_de_tim_va_danh_dau_cac_gia_tri_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch nhanh v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, Microsoft Excel cung c\u1ea5p kh\u00e1 nhi\u1ec1u t\u00ednh n\u0103ng h\u1eefu \u00edch c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n. Tuy nhi\u00ean, t\u1ea5t c\u1ea3 nh\u1eefng gi\u1ea3i ph\u00e1p \u0111\u00f3 kh\u00f3 c\u00f3 th\u1ec3 g\u1ecdi l\u00e0 tr\u1ef1c quan v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng v\u00ec ch\u00fang \u0111\u00f2i h\u1ecfi ph\u1ea3i ghi nh\u1edb m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c kh\u00e1c nhau. T\u1ea5t nhi\u00ean, V\u1edbi c\u00e1c chuy\u00ean gia Excel th\u00ec vi\u1ec7c ghi nh\u1edb ch\u1eb3ng c\u00f3 g\u00ec kh\u00f3 kh\u0103n c\u1ea3. Nh\u01b0ng \u0111\u1ed1i v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Excel th\u00ec c\u00f3 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong ph\u1ea7n cu\u1ed1i c\u00f9ng c\u1ee7a h\u01b0\u1edbng d\u1eabn h\u00f4m nay, H\u1ecdc Excel Online s\u1ebd s\u1eed d\u1ee5ng ti\u1ec7n \u00edch Duplicate Remover cho Excel. Xin \u0111\u1eebng nh\u1ea7m l\u1eabn b\u1edfi t\u00ean c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y. Ngo\u00e0i c\u00e1c h\u1ed3 s\u01a1 tr\u00f9ng l\u1eb7p, add-in c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n x\u1eed l\u00fd c\u00e1c m\u1ee5c duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 1. Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 nh\u1ea5n v\u00e0o n\u00fat Duplicate Remover tr\u00ean tab Ablebits Data trong nh\u00f3m Dedupe.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7846\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-6.png\" width=\"343\" height=\"439\" title=\"11-6\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tr\u00ecnh h\u01b0\u1edbng d\u1eabn s\u1ebd ch\u1ea1y v\u00e0 to\u00e0n b\u1ed9 b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn t\u1ef1 \u0111\u1ed9ng. 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<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7847\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-6.png\" width=\"633\" height=\"537\" title=\"12-6\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">M\u1eb9o. Khi s\u1eed d\u1ee5ng add-in l\u1ea7n \u0111\u1ea7u ti\u00ean, b\u1ea1n n\u00ean ki\u1ec3m tra h\u1ed9p Create a backup copy.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. T\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n, h\u00e3y ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn sau, sau \u0111\u00f3 b\u1ea5m Next:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Unique (Duy nh\u1ea5t)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Unique +1st occurrences (distinct) (Duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t)<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7848\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-6.png\" width=\"637\" height=\"547\" title=\"13-6\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u1ea7n t\u00ecm c\u00e1c t\u00ean duy nh\u1ea5t d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong 2 c\u1ed9t (First name and Last name), do \u0111\u00f3 ta s\u1ebd ch\u1ecdn c\u1ea3 hai.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7849\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-4.png\" width=\"637\" height=\"531\" title=\"14-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1, h\u00e3y ch\u1ecdn My table has headers. V\u00e0 n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 \u00f4 tr\u1ed1ng, ph\u1ea3i ki\u1ec3m tra l\u1ea1i ph\u1ea7n Skip empty cells. C\u1ea3 hai t\u00f9y ch\u1ecdn \u0111\u1ec1u n\u1eb1m \u1edf ph\u1ea7n tr\u00ean c\u1ee7a c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c ch\u1ecdn theo m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ch\u1ecdn m\u1ed9t trong c\u00e1c thao t\u00e1c sau \u0111\u1ec3 th\u1ef1c hi\u1ec7n tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 t\u00ecm th\u1ea5y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Highlight unique values with color \u2013 \u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t d\u00f9ng m\u00e0u s\u1eafc<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Select unique values \u2013 Ch\u1ecdn gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Identify in a status column \u2013 X\u00e1c \u0111\u1ecbnh trong c\u1ed9t tr\u1ea1ng th\u00e1i<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Copy to another location \u2013 Sao ch\u00e9p \u0111\u1ebfn v\u1ecb tr\u00ed kh\u00e1c<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7850\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-3.png\" width=\"635\" height=\"537\" title=\"15-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Nh\u1ea5n Finish v\u00e0 xem k\u1ebft qu\u1ea3:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7851\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-4.png\" width=\"481\" height=\"473\" title=\"16-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> N\u1ebfu vi\u1ec7c t\u00ecm ki\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 duy nh\u1ea5t trong Excel l\u00e0 m\u1ed9t ph\u1ea7n ph\u1ed5 bi\u1ebfn trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n th\u00ec hy v\u1ecdng r\u1eb1ng b\u00e0i vi\u1ebft n\u00e0y c\u00f3 nhi\u1ec1u ph\u1ea7n b\u1ed5 \u00edch, gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n thu\u1eadn l\u1ee3i h\u01a1n. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y.<\/span><\/p>\n<h2><\/h2>\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-128.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1786,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1785","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\/1785","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=1785"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1785\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1786"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}