{"id":3954,"date":"2024-12-04T08:27:23","date_gmt":"2024-12-04T08:27:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel\/"},"modified":"2024-12-04T08:27:23","modified_gmt":"2024-12-04T08:27:23","slug":"cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel\/","title":{"rendered":"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 v\u00e0 c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"t\u00ecm-gi\u00e1-tr\u1ecb-tr\u00f9ng-nhau-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html?tim-gia-tri-trung-nhau-trong-excel\">\n<p>Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch <strong>t\u00ecm gi\u00e1 tr\u1ecb tr\u00f9ng nhau trong excel<\/strong>. Ch\u00fang ta s\u1ebd c\u00f3 c\u00e1i nh\u00ecn c\u1eadn c\u1ea3nh v\u1ec1 c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhau \u0111\u1ec3 \u1ea9n c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p, to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u l\u1eb7p li\u00ean ti\u1ebfp b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<\/blockquote>\n<p><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel l\u00e0 s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. \u01afu \u0111i\u1ec3m l\u1edbn nh\u1ea5t c\u1ee7a ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 n\u00f3 kh\u00f4ng ch\u1ec9 hi\u1ec3n th\u1ecb cho b\u1ea1n c\u00e1c d\u1eef li\u1ec7u l\u1eb7p hi\u1ec7n c\u00f3 m\u00e0 c\u00f2n ph\u00e1t hi\u1ec7n v\u00e0 t\u00f4 m\u00e0u c\u00e1c d\u1eef li\u1ec7u l\u1eb7p m\u1edbi khi b\u1ea1n nh\u1eadp, ch\u1ec9nh s\u1eeda ho\u1eb7c ch\u00e8n d\u1eef li\u1ec7u.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ngo\u00e0i ra, b\u1ea1n c\u0169ng h\u1ecdc \u0111\u01b0\u1ee3c t\u1eeb b\u00e0i vi\u1ebft n\u00e0y m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u l\u1eb7p t\u00f9y thu\u1ed9c v\u00e0o nhi\u1ec7m v\u1ee5 c\u1ee5 th\u1ec3. C\u00e1c k\u1ef9 thu\u1eadt n\u00e0y ho\u1ea1t \u0111\u1ed9ng trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2016, Excel 2013, Excel 2010 v\u00e0 th\u1ea5p h\u01a1n.<\/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-67501269aac34\" 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-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Cach_lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_cach_su_dung_quy_tac_built-in_voi_lan_lap_dau_tien\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng quy t\u1eafc built-in (v\u1edbi l\u1ea7n l\u1eb7p \u0111\u1ea7u ti\u00ean)\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng quy t\u1eafc built-in (v\u1edbi l\u1ea7n l\u1eb7p \u0111\u1ea7u ti\u00ean)<\/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\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Khi_su_dung_quy_tac_inbuilt_cua_Excel_de_lam_noi_bat_gia_tri_lap_xin_luu_y_hai_dieu_sau\" title=\"Khi s\u1eed d\u1ee5ng quy t\u1eafc inbuilt c\u1ee7a Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb l\u1eb7p, xin l\u01b0u \u00fd hai \u0111i\u1ec1u sau:\">Khi s\u1eed d\u1ee5ng quy t\u1eafc inbuilt c\u1ee7a Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb l\u1eb7p, xin l\u01b0u \u00fd hai \u0111i\u1ec1u sau:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Cach_lam_noi_bat_cac_du_lieu_lap_ma_khong_co_lan_xuat_hien_dau_tien\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Cach_hien_thi_cac_du_lieu_lap_xuat_hien_lan_thu_3_thu_4_va_tat_ca_cac_du_lieu_lap_tiep_theo\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u l\u1eb7p xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 3, th\u1ee9 4 v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ti\u1ebfp theo\">C\u00e1ch hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u l\u1eb7p xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 3, th\u1ee9 4 v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ti\u1ebfp theo<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Lam_noi_bat_cac_du_lieu_lap_trong_nhieu_cot_bao_gom_ca_lan_xuat_hien_dau_tien\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong nhi\u1ec1u c\u1ed9t bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong nhi\u1ec1u c\u1ed9t bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Lam_noi_bat_cac_ban_sao_trong_nhieu_cot_ma_khong_co_lan_xuat_hien_lan_dau\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao trong nhi\u1ec1u c\u1ed9t m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao trong nhi\u1ec1u c\u1ed9t m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Nguyen_tac_1_Ap_dung_cho_cot_dau_tien\" title=\"Nguy\u00ean t\u1eafc 1. \u00c1p d\u1ee5ng cho c\u1ed9t \u0111\u1ea7u ti\u00ean\">Nguy\u00ean t\u1eafc 1. \u00c1p d\u1ee5ng cho c\u1ed9t \u0111\u1ea7u ti\u00ean<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Quy_tac_2_Ap_dung_cho_tat_ca_cac_cot_tiep_theo\" title=\"Quy t\u1eafc 2. \u00c1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ti\u1ebfp theo\">Quy t\u1eafc 2. \u00c1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ti\u1ebfp theo<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Cach_lam_noi_bat_cac_hang_trung_lap_trong_Excel\" title=\"C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p trong Excel\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p 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\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Lam_noi_bat_cac_o_sao_chep_lien_tiep_trong_Excel\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 sao ch\u00e9p li\u00ean ti\u1ebfp trong Excel\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 sao ch\u00e9p li\u00ean ti\u1ebfp trong Excel<\/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-11\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Cach_lam_noi_bat_cac_du_lieu_lap_trong_Excel_voi_Duplicate_Remover\" title=\" C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel v\u1edbi Duplicate Remover\"> C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel v\u1edbi Duplicate Remover<\/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-12\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Duplicate_Remover_tang_them_3_tinh_nang_moi_cho_Excel\" title=\"Duplicate Remover t\u0103ng th\u00eam 3 t\u00ednh n\u0103ng m\u1edbi cho Excel:\">Duplicate Remover t\u0103ng th\u00eam 3 t\u00ednh n\u0103ng m\u1edbi cho Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_mot_cu_dup_chuot\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng m\u1ed9t c\u00fa \u0111\u00fap chu\u1ed9t\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng m\u1ed9t c\u00fa \u0111\u00fap chu\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-lam-noi-bat-cac-o-va-cac-hang-trung-lap-trong-excel.html#Lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_cach_su_dung_trinh_huong_dan_tung_buoc_nang_cao\" title=\"L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tr\u00ecnh h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc n\u00e2ng cao\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tr\u00ecnh h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc n\u00e2ng cao<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_cach_su_dung_quy_tac_built-in_voi_lan_lap_dau_tien\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng quy t\u1eafc built-in (v\u1edbi l\u1ea7n l\u1eb7p \u0111\u1ea7u ti\u00ean)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel, c\u00f3 m\u1ed9t quy t\u1eafc \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p. \u0110\u1ec3 s\u1eed d\u1ee5ng quy t\u1eafc n\u00e0y trong c\u00e1c b\u1ea3ng t\u00ednh, 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\">1. Ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ki\u1ec3m tra d\u1eef li\u1ec7u l\u1eb7p. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u1ed9t, m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4.<\/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-7788\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-5-2.png\" width=\"372\" height=\"425\" title=\"1-5-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. C\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Duplicate Values s\u1ebd m\u1edf ra v\u1edbi \u0111\u1ecbnh d\u1ea1ng Light Red Fill and Dark Red Text \u0111\u01b0\u1ee3c ch\u1ecdn theo m\u1eb7c \u0111\u1ecbnh. \u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ngo\u00e0i vi\u1ec7c \u0111i\u1ec1n v\u00e0o m\u00e0u \u0111\u1ecf v\u00e0 \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n, m\u1ed9t s\u1ed1 \u00edt c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc c\u00f3 s\u1eb5n trong danh s\u00e1ch th\u1ea3 xu\u1ed1ng. \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 m\u00e0u kh\u00e1c, h\u00e3y nh\u1ea5p v\u00e0o Custom Format\u2026 (m\u1ee5c cu\u1ed1i c\u00f9ng trong tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng) v\u00e0 ch\u1ecdn m\u00e0u \u0111i\u1ec1n v\u00e0 \/ ho\u1eb7c m\u00e0u ch\u1eef theo \u00fd th\u00edch.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7789\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-5.png\" width=\"478\" height=\"197\" title=\"2-5\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. \u0110\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, h\u00e3y ch\u1ecdn Unique \u1edf h\u1ed9p tho\u1ea1i b\u00ean tay tr\u00e1i.<\/span><\/p>\n<p>Xem th\u00eam: <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel.html\">h\u00e0m \u0111\u1ebfm d\u1eef li\u1ec7u tr\u00f9ng trong excel<\/a><\/strong><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">S\u1eed d\u1ee5ng quy t\u1eafc inbuilt, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao trong m\u1ed9t c\u1ed9t ho\u1eb7c trong m\u1ed9t v\u00e0i c\u1ed9t nh\u01b0 th\u1ec3 hi\u1ec7n trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh sau:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7790\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-4-1.png\" width=\"655\" height=\"511\" title=\"3-4-1\"><\/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-315.gif\" title=\"ex101_92019-nho-315\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ch\u00fa th\u00edch. Khi \u00e1p d\u1ee5ng quy t\u1eafc nh\u00e2n b\u1ea3n \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong hai ho\u1eb7c nhi\u1ec1u c\u1ed9t, Excel kh\u00f4ng so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong c\u00e1c c\u1ed9t \u0111\u00f3, n\u00f3 ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Khi_su_dung_quy_tac_inbuilt_cua_Excel_de_lam_noi_bat_gia_tri_lap_xin_luu_y_hai_dieu_sau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Khi s\u1eed d\u1ee5ng quy t\u1eafc inbuilt c\u1ee7a Excel \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb l\u1eb7p, xin l\u01b0u \u00fd hai \u0111i\u1ec1u sau:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 N\u00f3 ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng cho c\u00e1c \u00f4 ri\u00eang l\u1ebb. \u0110\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p, b\u1ea1n c\u1ea7n t\u1ea1o c\u00e1c quy t\u1eafc c\u1ee7a ri\u00eang m\u00ecnh d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3 ho\u1eb7c b\u1eb1ng c\u00e1ch so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00e0i c\u1ed9t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 N\u00f3 l\u00e0m m\u1edd c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p k\u1ec3 c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1eef li\u1ec7u l\u1eb7p \u0111\u00f3. \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n sao tr\u1eeb c\u00e1c tr\u01b0\u1eddng h\u1ee3p xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u ti\u00ean, h\u00e3y 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 n\u00e0y.<\/span><\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">h\u1ecdc h\u00e0m excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_du_lieu_lap_ma_khong_co_lan_xuat_hien_dau_tien\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/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 d\u1eef li\u1ec7u l\u1eb7p t\u00ednh t\u1eeb l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 2 tr\u1edf \u0111i, h\u00e3y ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00f4 m\u00e0u v\u00e0 t\u1ea1o quy t\u1eafc d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c theo c\u00e1ch n\u00e0y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. Tr\u00ean tab Trang ch\u1ee7, trong nh\u00f3m 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\"> 2. Trong h\u1ed9p Format values where this formula is true, nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIF($A$2:$A2,$A2)&gt;1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong \u0111\u00f3 A2 l\u00e0 \u00f4 tr\u00ean c\u00f9ng c\u1ee7a d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. Nh\u1ea5p v\u00e0o n\u00fat Format\u2026 v\u00e0 ch\u1ecdn m\u00e0u \u0111i\u1ec1n b\u00f4i \u0111\u1eadm v\u00e0 \/ ho\u1eb7c m\u00e0u ch\u1eef m\u00e0 b\u1ea1n mu\u1ed1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 4. Cu\u1ed1i c\u00f9ng, nh\u1ea5n OK \u0111\u1ec3 l\u01b0u v\u00e0 \u00e1p d\u1ee5ng quy t\u1eafc.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7791\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-5-1.png\" width=\"623\" height=\"559\" title=\"4-5-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> K\u1ebft qu\u1ea3 l\u00e0, c\u00e1c \u00f4 sao ch\u00e9p tr\u1eeb c\u00e1c tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea7u ti\u00ean s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m n\u1ed5i b\u1eadt v\u1edbi m\u00e0u s\u1eafc b\u1ea1n ch\u1ecdn:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7792\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-5.png\" width=\"211\" height=\"337\" title=\"5-5\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_hien_thi_cac_du_lieu_lap_xuat_hien_lan_thu_3_thu_4_va_tat_ca_cac_du_lieu_lap_tiep_theo\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u l\u1eb7p xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 3, th\u1ee9 4 v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ti\u1ebfp theo<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 xem c\u00e1c d\u1eef li\u1ec7u l\u1eb7p b\u1eaft \u0111\u1ea7u v\u1edbi l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 N, ta c\u1ea7n 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 nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, v\u1edbi s\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 thay th\u1ebf &gt; 1 \u1edf cu\u1ed1i c\u00f4ng th\u1ee9c b\u1eb1ng m\u1ed9t s\u1ed1 theo y\u00eau c\u1ea7u. V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u l\u1eb7p th\u1ee9 ba v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c tr\u01b0\u1eddng h\u1ee3p tr\u00f9ng l\u1eb7p ti\u1ebfp theo, 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 n\u00e0y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$A2,$A2)&gt;=3<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u l\u1eb7p th\u1ee9 4 v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ti\u1ebfp theo, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$A2,$A2)&gt;=4<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt m\u1ed9t gi\u00e1 tr\u1ecb l\u1eb7p nh\u1ea5t \u0111\u1ecbnh b\u1ea1n s\u1eed d\u1ee5ng to\u00e1n t\u1eed b\u1eb1ng (=). V\u00ed d\u1ee5: \u0111\u1ec3 ch\u1ec9 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p l\u1ea7n th\u1ee9 2, b\u1ea1n s\u1ebd 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)=2<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong m\u1ed9t d\u1ea3i (nhi\u1ec1u c\u1ed9t)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Khi b\u1ea1n mu\u1ed1n ki\u1ec3m tra c\u00e1c d\u1eef li\u1ec7u l\u1eb7p tr\u00ean nhi\u1ec1u c\u1ed9t, kh\u00f4ng ph\u1ea3i b\u1eb1ng c\u00e1ch so s\u00e1nh c\u00e1c c\u1ed9t v\u1edbi nhau, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c gi\u1ea3i ph\u00e1p sau.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_du_lieu_lap_trong_nhieu_cot_bao_gom_ca_lan_xuat_hien_dau_tien\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong nhi\u1ec1u c\u1ed9t bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a d\u1eef li\u1ec7u b\u1ecb l\u1eb7p nhi\u1ec1u l\u1ea7n c\u0169ng \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t b\u1ea3n sao th\u00ec c\u00e1ch d\u1ec5 nh\u1ea5t l\u00e0 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c d\u1eef li\u1ec7u l\u1eb7p trong Excel.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ho\u1eb7c, t\u1ea1o m\u1ed9t quy t\u1eafc \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">COUNTIF(range, top_cell)&gt;1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> V\u00ed d\u1ee5: \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao trong d\u1ea3i A2:C8, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$C$8, A2)&gt;1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">H\u00e3y ch\u00fa \u00fd \u0111\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i cho d\u1ea3i ($A$2:$C$8), v\u00e0 c\u00e1c tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i cho \u00f4 tr\u00ean c\u00f9ng (A2).<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7793\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-5.png\" width=\"433\" height=\"571\" title=\"6-5\"><\/p>\n<blockquote>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Ho\u0323c Excel nhanh<\/a>\u00a0c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_ban_sao_trong_nhieu_cot_ma_khong_co_lan_xuat_hien_lan_dau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c b\u1ea3n sao trong nhi\u1ec1u c\u1ed9t m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">C\u00e1c gi\u1ea3i ph\u00e1p cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd c\u00f3 ch\u00fat ph\u1ee9c t\u1ea1p h\u01a1n v\u00ec Excel kh\u00f4ng x\u00e2y d\u1ef1ng quy t\u1eafc s\u1eb5n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p trong m\u1ed9t s\u1ed1 c\u1ed9t b\u1ecf qua l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd ph\u1ea3i t\u1ea1o ra 2 quy t\u1eafc v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nguyen_tac_1_Ap_dung_cho_cot_dau_tien\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Nguy\u00ean t\u1eafc 1. \u00c1p d\u1ee5ng cho c\u1ed9t \u0111\u1ea7u ti\u00ean<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u1ede \u0111\u00e2y b\u1ea1n s\u1eed d\u1ee5ng ch\u00ednh x\u00e1c c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c nh\u01b0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean trong m\u1ed9t c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang t\u1ea1o ra m\u1ed9t quy t\u1eafc cho A2:A8 v\u1edbi c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=COUNTIF($A$2:$A2,$A2)&gt;1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">K\u1ebft qu\u1ea3 l\u00e0 c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p kh\u00f4ng g\u1ed3m l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u s\u00e1t c\u1ed9t b\u00ean tr\u00e1i c\u1ee7a d\u1ea3i \u00f4 (ch\u1ec9 c\u00f3 m\u1ed9t m\u1ee5c nh\u01b0 v\u1eady trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a v\u00ed d\u1ee5 n\u00e0y):<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7794\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-4.png\" width=\"430\" height=\"573\" title=\"7-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Quy_tac_2_Ap_dung_cho_tat_ca_cac_cot_tiep_theo\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Quy t\u1eafc 2. \u00c1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ti\u1ebfp theo<\/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 b\u1ea3n sao trong c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i (B2: C8), 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$8,B2)+COUNTIF(B$2:B2,B2)&gt;1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong c\u00f4ng th\u1ee9c tr\u00ean, ch\u1ee9c n\u0103ng COUNTIF \u0111\u1ebfm nh\u1eefng d\u1eef li\u1ec7u l\u1eb7p trong c\u1ed9t \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh s\u1eb5n, v\u00e0 COUNTIF s\u1ebd th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c t\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c c\u1ed9t ti\u1ebfp theo.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Do \u0111\u00f3, t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c l\u1eb7p tr\u1eeb l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a ch\u00fang \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y v\u00e0 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7795\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-5.png\" width=\"583\" height=\"515\" title=\"8-5\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t v\u1edbi m\u1ed9t quy t\u1eafc<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1ed9t gi\u1ea3i ph\u00e1p kh\u00e1c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u00e0 th\u00eam c\u1ed9t tr\u1ed1ng v\u00e0o b\u00ean tr\u00e1i t\u1eadp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 k\u1ebft h\u1ee3p c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n l\u1ebb nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(COLUMNS($B2:B2)&gt;1,COUNTIF(A$2:$B$8,B2),0)+COUNTIF(B$2:B2,B2)&gt;1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong \u0111\u00f3 B2 l\u00e0 \u00f4 \u0111\u1ea7u c\u00f3 d\u1eef li\u1ec7u trong c\u1ed9t th\u1ee9 2 c\u1ee7a d\u1ea3i \u0111\u00edch.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7796\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-5.png\" width=\"615\" height=\"499\" title=\"9-5\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00f4ng th\u1ee9c, h\u00e3y chia ra l\u00e0m 2 ph\u1ea7n ch\u00ednh:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u0110\u1ed1i v\u1edbi c\u1ed9t \u0111\u1ea7u ti\u00ean (B), \u0111i\u1ec1u ki\u1ec7n IF kh\u00f4ng th\u1ec3 \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u, v\u00ec v\u1eady ch\u1ec9 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng COUNTIF th\u1ee9 hai, l\u00e0 c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng m\u00e0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm c\u00e1c b\u1ea3n sao m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u ti\u00ean trong m\u1ed9t c\u1ed9t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ed1i v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ti\u1ebfp theo (C2:D8), \u0111i\u1ec3m m\u1ea5u ch\u1ed1t l\u00e0 vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i m\u1ed9t c\u00e1ch th\u00f4ng minh trong hai h\u00e0m COUNTIF. \u0110\u1ec3 l\u00e0m cho m\u1ecdi th\u1ee9 d\u1ec5 hi\u1ec3u h\u01a1n,c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c thay \u0111\u1ed5i nh\u01b0 th\u1ebf n\u00e0o khi \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 kh\u00e1c:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7797\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-5.png\" width=\"561\" height=\"227\" title=\"10-5\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u1edfi v\u00ec \u0111i\u1ec1u ki\u1ec7n IF lu\u00f4n lu\u00f4n TRUE cho t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t kh\u00e1c ch\u1ee9 kh\u00f4ng ch\u1ec9 c\u00f3 c\u1ed9t \u0111\u1ea7u ti\u00ean (c\u00f3 nhi\u1ec1u h\u01a1n 1 c\u1ed9t), c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c ti\u1ebfn h\u00e0nh theo c\u00e1ch n\u00e0y:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t m\u1ee5c nh\u1ea5t \u0111\u1ecbnh (D5 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean) trong t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t \u1edf b\u00ean tr\u00e1i c\u1ed9t \u0111\u00e3 cho: COUNTIF(B$2:$C$8,D5)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed9t m\u1ee5c nh\u1ea5t \u0111\u1ecbnh trong c\u1ed9t ch\u1ee9a m\u1ee5c \u0111\u00f3, cho \u0111\u1ebfn \u00f4 c\u1ee7a m\u1ee5c \u0111\u00f3: COUNTIF(D$2:D5,D5)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Cu\u1ed1i c\u00f9ng, c\u00f4ng th\u1ee9c c\u1ed9ng th\u00eam k\u1ebft qu\u1ea3 c\u1ee7a c\u1ea3 hai h\u00e0m COUNTIF. N\u1ebfu t\u1ed5ng s\u1ed1 l\u1edbn h\u01a1n 1, ngh\u0129a l\u00e0 n\u1ebfu m\u1ee5c xu\u1ea5t hi\u1ec7n nhi\u1ec1u l\u1ea7n, quy t\u1eafc s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng v\u00e0 m\u1ee5c \u0111\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u00e1nh d\u1ea5u to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb l\u1eb7p trong m\u1ed9t c\u1ed9t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u c\u1ed9t, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean b\u1ea3n ghi tr\u00f9ng l\u1eb7p trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, quy t\u1eafc \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong Excel cho c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng \u1edf c\u1ea5p \u0111\u1ed9 \u00f4. Nh\u01b0ng m\u1ed9t quy t\u1eafc d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng \u1edf c\u1ea5p \u0111\u1ed9 cao h\u01a1n th\u1ebf. \u0110i\u1ec3m m\u1ea5u ch\u1ed1t l\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng, v\u00e0 sau \u0111\u00f3 t\u1ea1o m\u1ed9t quy t\u1eafc v\u1edbi m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p tr\u1eeb c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIF($A$2:$A2, $A2)&gt;1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIF($A$2:$A$15, $A2)&gt;1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Trong \u0111\u00f3 A2 l\u00e0 \u00f4 \u0111\u1ea7u ti\u00ean v\u00e0 A15 l\u00e0 \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cu\u1ed1i c\u00f9ng trong c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra d\u1eef li\u1ec7u l\u1eb7p. Nh\u01b0 b\u1ea1n th\u1ea5y, vi\u1ec7c s\u1eed d\u1ee5ng th\u00f4ng minh c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i l\u00e0 \u0111i\u1ec1u t\u1ea1o n\u00ean s\u1ef1 kh\u00e1c bi\u1ec7t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau \u0111\u00e2y th\u1ec3 hi\u1ec7n c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u1ea3 hai quy t\u1eafc:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7798\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-5.png\" width=\"587\" height=\"575\" title=\"11-5\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_hang_trung_lap_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5 tr\u01b0\u1edbc \u0111\u00e3 chia s\u1ebb c\u00e1ch t\u00f4 m\u00e0u to\u00e0n b\u1ed9 h\u00e0ng d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p trong m\u1ed9t c\u1ed9t c\u1ee5 th\u1ec3. Nh\u01b0ng n\u1ebfu b\u1ea1n mu\u1ed1n xem c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb gi\u1ed1ng nhau trong m\u1ed9t v\u00e0i c\u1ed9t? Ho\u1eb7c, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p tuy\u1ec7t \u0111\u1ed1i, nh\u1eefng c\u00e1i c\u00f3 gi\u00e1 tr\u1ecb ho\u00e0n to\u00e0n b\u1eb1ng nhau trong t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t?<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">COUNTIFS<\/a> cho ph\u00e9p so s\u00e1nh c\u00e1c \u00f4 theo nhi\u1ec1u ti\u00eau ch\u00ed. V\u00ed d\u1ee5: \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p c\u00f3 gi\u00e1 tr\u1ecb gi\u1ed1ng nhau trong c\u1ed9t A v\u00e0 B, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p ngo\u1ea1i tr\u1eeb c\u00e1c l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIFS($A$2:$A2, $A2, $B$2:$B2, $B2)&gt;1<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =COUNTIFS($A$2:$A$15, $A2, $B$2:$B$15, $B2)&gt;1<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7799\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-5.png\" width=\"651\" height=\"569\" title=\"12-5\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tuy nhi\u00ean, v\u00ed d\u1ee5 tr\u00ean ch\u1ec9 mang t\u00ednh gi\u1edbi thi\u1ec7u c\u00e1ch l\u00e0m cho c\u00e1c b\u1ea1n v\u00ec trong th\u1ef1c t\u1ebf, b\u1ea1n s\u1ebd kh\u00f4ng ch\u1ec9 th\u1ef1c hi\u1ec7n vi\u1ec7c l\u00e0m n\u1ed5i b\u1eadt gi\u00e1 tr\u1ecb l\u1eb7p ch\u1ec9 trong 2 c\u1ed9t m\u00e0 s\u1ebd th\u1ef1c hi\u1ec7n \u1edf gi\u1edbi h\u1ea1n l\u1edbn h\u01a1n. V\u1edbi h\u00e0m COUNTIFS b\u1ea1n c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1edbi 127 ph\u1ea1m vi \/ c\u1eb7p ti\u00eau chu\u1ea9n.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_o_sao_chep_lien_tiep_trong_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 sao ch\u00e9p li\u00ean ti\u1ebfp trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00f4i khi, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u00e1nh d\u1ea5u t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong m\u1ed9t c\u1ed9t m\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c \u00f4 sao ch\u00e9p li\u00ean t\u1ee5c, t\u1ee9c l\u00e0 c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng v\u1edbi nhau. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y ch\u1ecdn \u00f4 c\u00f3 d\u1eef li\u1ec7u (kh\u00f4ng bao g\u1ed3m ti\u00eau \u0111\u1ec1 c\u1ed9t) v\u00e0 t\u1ea1o 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<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p li\u00ean ti\u1ebfp m\u00e0 kh\u00f4ng bao g\u1ed3m l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =$A1=$A2<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p li\u00ean ti\u1ebfp bao g\u1ed3m c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =OR($A1=$A2, $A2=$A3)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau minh h\u1ecda c\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c v\u0103n b\u1ea3n tr\u00f9ng l\u1eb7p li\u00ean ti\u1ebfp, nh\u01b0ng c\u00e1c quy t\u1eafc n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho s\u1ed1 v\u00e0 ng\u00e0y tr\u00f9ng l\u1eb7p:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7800\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-5.png\" width=\"629\" height=\"615\" title=\"13-5\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 c\u00e1c h\u00e0ng r\u1ed7ng v\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00e1c \u00f4 tr\u1ed1ng li\u00ean ti\u1ebfp \u0111\u01b0\u1ee3c l\u00e0m n\u1ed5i b\u1eadt, h\u00e3y th\u1ef1c hi\u1ec7n nh\u1eefng c\u1ea3i ti\u1ebfn sau cho c\u00e1c c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 sao ch\u00e9p li\u00ean ti\u1ebfp m\u00e0 kh\u00f4ng c\u00f3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean v\u00e0 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =AND($A2&lt;&gt;\u201d\u201d, $A1=$A2)<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p v\u1edbi l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean v\u00e0 b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> = AND ($ A2 &lt;&gt; \u201c\u201d, OR ($ A1 = $ A2, $ A2 = $ A3))<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Nh\u01b0 b\u1ea1n th\u1ea5y, vi\u1ec7c l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, n\u00ean b\u1ea1n s\u1ebd kh\u00f4ng g\u1eb7p ph\u1ea3i b\u1ea5t c\u1ee9 kh\u00f3 kh\u0103n n\u00e0o. Ngo\u00e0i ra, v\u1eabn c\u00f2n m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel, \u0111\u1ec3 bi\u1ebft c\u00e1ch l\u00e0m \u0111\u00f3 l\u00e0 g\u00ec, m\u1eddi b\u1ea1n theo d\u00f5i ph\u1ea7n ti\u1ebfp theo c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam_noi_bat_cac_du_lieu_lap_trong_Excel_voi_Duplicate_Remover\"><\/span><span style=\"font-family: 'Times New Roman', Times\"> C\u00e1ch l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel v\u1edbi Duplicate Remover<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ti\u1ec7n \u00edch Duplicate Remover l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1i \u01b0u \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel. N\u00f3 c\u00f3 th\u1ec3 t\u00ecm, \u0111\u00e1nh d\u1ea5u, ch\u1ecdn, sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n c\u00e1c \u00f4 sao ch\u00e9p ho\u1eb7c to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Duplicate_Remover_tang_them_3_tinh_nang_moi_cho_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">Duplicate Remover t\u0103ng th\u00eam 3 t\u00ednh n\u0103ng m\u1edbi cho Excel:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Dedupe Table \u2013 gi\u00fap ngay l\u1eadp t\u1ee9c t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong m\u1ed9t b\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Duplicate Remover \u2013 th\u1ee7 thu\u1eadt t\u1eebng b\u01b0\u1edbc v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn n\u00e2ng cao \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ho\u1eb7c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong 1 b\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Compare 2 Tables \u2013 t\u00ecm v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u l\u1eb7p b\u1eb1ng c\u00e1ch so s\u00e1nh hai c\u1ed9t ho\u1eb7c hai b\u1ea3ng ri\u00eang bi\u1ec7t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Sau khi c\u00e0i \u0111\u1eb7t Duplicate Remover, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y nh\u1eefng c\u00f4ng c\u1ee5 n\u00e0y tr\u00ean tab D\u1eef li\u1ec7u Ablebits trong nh\u00f3m Dedupe:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7801\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-3.png\" width=\"336\" height=\"146\" title=\"14-3\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_mot_cu_dup_chuot\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng m\u1ed9t c\u00fa \u0111\u00fap chu\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 t\u1ea1o ra b\u1ea3ng sau v\u1edbi h\u00e0ng tr\u0103m h\u00e0ng. V\u00e0 m\u1ee5c \u0111\u00edch l\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng nhau trong c\u1ea3 ba c\u1ed9t:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7802\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-2.png\" width=\"350\" height=\"237\" title=\"15-2\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u1ea1n c\u00f3 th\u1ec3 tin ho\u1eb7c kh\u00f4ng, nh\u01b0ng th\u1ef1c s\u1ef1 l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n v\u1edbi ch\u1ec9 2 c\u00fa click chu\u1ed9t.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 V\u1edbi b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u1ea5p v\u00e0o n\u00fat Dedupe Table, v\u00e0 ti\u1ec7n \u00edch th\u00f4ng minh s\u1ebd ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 C\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Dedupe Table s\u1ebd m\u1edf ra v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn t\u1ef1 \u0111\u1ed9ng, v\u00e0 t\u00f9y ch\u1ecdn Color duplicates \u0111\u01b0\u1ee3c ch\u1ecdn theo m\u1eb7c \u0111\u1ecbnh. V\u00ec v\u1eady, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea1n ph\u1ea3i l\u00e0m l\u00e0 nh\u1ea5n OK.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb9o. N\u1ebfu b\u1ea1n mu\u1ed1n ph\u00e1t hi\u1ec7n c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p trong m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t, h\u00e3y b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t kh\u00f4ng li\u00ean quan v\u00e0 ch\u1ec9 \u0111\u1ec3 l\u1ea1i (c\u00e1c) c\u1ed9t ch\u00ednh.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7803\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-3.png\" width=\"619\" height=\"503\" title=\"16-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7804\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/17-3.png\" width=\"303\" height=\"321\" title=\"17-3\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh tr\u00ean, c\u00f4ng c\u1ee5 Dupe Table \u0111\u00e3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c h\u00e0ng tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng bao g\u1ed3m tr\u01b0\u1eddng h\u1ee3p \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p, k\u1ec3 c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean, ho\u1eb7c n\u1ebfu b\u1ea1n mu\u1ed1n t\u00f4 m\u00e0u c\u00e1c b\u1ea3n ghi kh\u00e1c bi\u1ec7t ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p, ho\u1eb7c n\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch m\u00e0u \u0111\u1ecf m\u1eb7c \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng tr\u00ecnh th\u1ee7 thu\u1eadt Duplicate Remover, \u1edf \u0111\u00f3 c\u00f3 t\u1ea5t c\u1ea3 c\u00e1c t\u00ednh n\u0103ng n\u00e0y v\u00e0 c\u00f2n nhi\u1ec1u h\u01a1n th\u1ebf n\u1eefa .<\/span><\/p>\n<p><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-315.gif\" title=\"ex101_92019-nho-315\"><br \/>\n<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lam_noi_bat_cac_du_lieu_lap_trong_Excel_bang_cach_su_dung_trinh_huong_dan_tung_buoc_nang_cao\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tr\u00ecnh h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc n\u00e2ng cao<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\"> So v\u1edbi c\u00f4ng c\u1ee5 Dedupe Table, th\u1ee7 thu\u1eadt Duplicate Remover \u0111\u00f2i h\u1ecfi nhi\u1ec1u h\u01a1n m\u1ed9t v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t, nh\u01b0ng l\u1ea1i c\u00f3 th\u00eam m\u1ed9t s\u1ed1 t\u00f9y ch\u1ecdn b\u1ed5 sung.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c d\u1eef li\u1ec7u l\u1eb7p, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Duplicate Remover tr\u00ean thanh th\u1ef1c \u0111\u01a1n. 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.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Add-in c\u0169ng s\u1ebd g\u1ee3i \u00fd t\u1ea1o m\u1ed9t b\u1ea3n sao l\u01b0u c\u1ee7a b\u1ea3ng c\u1ee7a b\u1ea1n. N\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea7n th\u00ec c\u00f3 th\u1ec3 b\u1ecf ch\u1ecdn h\u1ed9p \u0111\u00f3.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> X\u00e1c minh r\u1eb1ng b\u1ea3ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn ch\u00ednh x\u00e1c v\u00e0 nh\u1ea5n Next.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7805\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/18-3.png\" width=\"431\" height=\"527\" title=\"18-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Ch\u1ecdn ki\u1ec3u d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm trong s\u1ed1 nh\u1eefng l\u1ef1a ch\u1ecdn sau:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Duplicates except 1st occurrences \u2013 d\u1eef li\u1ec7u l\u1eb7p ngo\u1ea1i tr\u1eeb l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Duplicates with 1st occurrences \u2013 d\u1eef li\u1ec7u l\u1eb7p v\u00e0 c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Unique values \u2013 Gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Unique values and 1st duplicate occurrences \u2013 Gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u00f9ng l\u1eb7p l\u1ea7n th\u1ee9 nh\u1ea5t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta h\u00e3y t\u00ecm d\u1eef li\u1ec7u l\u1eb7p v\u00e0 c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7806\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-3.png\" width=\"619\" height=\"501\" title=\"19-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 3. B\u00e2y gi\u1edd, ch\u1ecdn c\u00e1c c\u1ed9t c\u1ea7n ki\u1ec3m tra c\u00e1c d\u1eef li\u1ec7u l\u1eb7p. \u1ede \u0111\u00e2y c\u1ea7n l\u00e0m n\u1ed5i b\u1eadt c\u00e1c t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng, n\u00ean ta ch\u1ecdn t\u1ea5t c\u1ea3 3 c\u1ed9t.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7807\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/20-3.png\" width=\"613\" height=\"495\" title=\"20-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ngo\u00e0i ra, add-in n\u00e0y c\u00f3 th\u00eam t\u00f9y ch\u1ecdn n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u1ee7a ti\u00eau \u0111\u1ec1 ho\u1eb7c b\u1ea1n mu\u1ed1n b\u1ecf qua c\u00e1c \u00f4 tr\u1ed1ng. C\u1ea3 hai t\u00f9y ch\u1ecdn n\u00e0y \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111\u1eb7t theo m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">4. Cu\u1ed1i c\u00f9ng, ch\u1ecdn thao t\u00e1c c\u1ea7n th\u1ef1c hi\u1ec7n tr\u00ean d\u1eef li\u1ec7u l\u1eb7p. B\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 t\u00f9y ch\u1ecdn nh\u01b0 ch\u1ecdn, x\u00f3a, sao ch\u00e9p, di chuy\u1ec3n c\u00e1c d\u1eef li\u1ec7u l\u1eb7p ho\u1eb7c th\u00eam c\u1ed9t tr\u1ea1ng th\u00e1i \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c d\u1eef li\u1ec7u l\u1eb7p \u0111\u00f3.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> T\u1ea5t nhi\u00ean, vi\u1ec7c l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc ph\u00f4ng ch\u1eef c\u0169ng d\u1ec5 d\u00e0ng h\u01a1n h\u1eb3n, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o ph\u1ea7n More Colors \u2026 v\u00e0 ch\u1ecdn b\u1ea5t c\u1ee9 m\u00e0u n\u00e0o c\u00f3 s\u1eb5n ho\u1eb7c m\u00e0u t\u00f9y ch\u1ec9nh.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7808\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/21-3.png\" width=\"609\" height=\"497\" title=\"21-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Nh\u1ea5n Finish r\u1ed3i xem k\u1ebft qu\u1ea3<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7809\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/22-3.png\" width=\"483\" height=\"445\" title=\"22-3\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Hy v\u1ecdng r\u1eb1ng, b\u00e0i vi\u1ebft n\u00e0y \u0111em l\u1ea1i nhi\u1ec1u th\u00f4ng tin b\u1ed5 \u00edch cho c\u00e1c b\u1ea1n v\u00e0 mong g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong nh\u1eefng b\u00e0i vi\u1ebft sau.<\/span><a href=\"http:\/\/bit.ly\/2rPfrhk\" target=\"_blank\" rel=\"noopener noreferrer\"><br \/>\n<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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 Excel c\u00f9ng chuy\u00ean gia \/ gi\u1ea3ng vi\u00ean Nguy\u1ec5n \u0110\u1ee9c Thanh:<\/p>\n<p><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-315.gif\" title=\"ex101_92019-nho-315\"><br \/>\n<\/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-315.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3955,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3954","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\/3954","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=3954"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3954\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3955"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}