{"id":2535,"date":"2024-12-02T08:04:03","date_gmt":"2024-12-02T08:04:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel\/"},"modified":"2024-12-02T08:04:03","modified_gmt":"2024-12-02T08:04:03","slug":"cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t v\u00e0 duy nh\u1ea5t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><span style=\"font-family: georgia, palatino, serif\">Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c v\u00e0 c\u00e1ch \u0111\u1ebfm t\u1ef1 \u0111\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong b\u1ea3ng. Ngo\u00e0i ra, H\u1ecdc Excel Online c\u0169ng s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c v\u00ed d\u1ee5 \u0111\u1ec3 \u0111\u1ebfm c\u00e1c t\u00ean, v\u0103n b\u1ea3n, s\u1ed1, gi\u00e1 tr\u1ecb ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, \u2026.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Khi l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t t\u1eadp d\u1eef li\u1ec7u l\u1edbn trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd c\u1ea7n ph\u1ea3i bi\u1ebft c\u00f3 bao nhi\u00eau gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 duy nh\u1ea5t \u1edf \u0111\u00f3. V\u00e0 \u0111\u00f4i khi, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n ch\u1ec9 \u0111\u1ebfm ri\u00eang c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t (kh\u00e1c nhau).<\/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<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-674d69f212758\" 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<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Truoc_tien_hay_nhac_lai_mot_so_dinh_nghia_can_biet\" title=\"Tr\u01b0\u1edbc ti\u00ean h\u00e3y nh\u1eafc l\u1ea1i m\u1ed9t s\u1ed1 \u0111\u1ecbnh ngh\u0129a c\u1ea7n bi\u1ebft\">Tr\u01b0\u1edbc ti\u00ean h\u00e3y nh\u1eafc l\u1ea1i m\u1ed9t s\u1ed1 \u0111\u1ecbnh ngh\u0129a c\u1ea7n bi\u1ebft<\/a><\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cach_dem_cac_gia_tri_duy_nhat_trong_Excel\" title=\"C\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\">C\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb 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-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_duy_nhat_trong_mot_cot\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_duy_nhat_dang_van_ban_trong_Excel\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t d\u1ea1ng v\u0103n b\u1ea3n trong Excel\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t d\u1ea1ng v\u0103n b\u1ea3n trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_so_duy_nhat_trong_Excel\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 duy nh\u1ea5t trong Excel\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 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-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_duy_nhat_phan_biet_chu_hoa_chu_thuong_trong_Excel\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_khac_biet_trong_Excel_gia_tri_duy_nhat_va_1_xuat_hien_dai_dien_cho_cac_gia_tri_trung_lap\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 1 xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p)\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 1 xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p)<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cach_hoat_dong_cua_cong_thuc_gia_tri_khac_biet_cua_Excel\" title=\"C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t c\u1ee7a Excel\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t c\u1ee7a 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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cong_thuc_dem_cac_gia_tri_khac_biet_theo_nhung_cach_khac_nhau\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t theo nh\u1eefng c\u00e1ch kh\u00e1c nhau\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t theo nh\u1eefng c\u00e1ch kh\u00e1c nhau<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_khac_biet_bo_qua_o_trong\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1ecf qua \u00f4 tr\u1ed1ng\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1ecf qua \u00f4 tr\u1ed1ng<\/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\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cong_thuc_dem_cac_gia_tri_van_ban_khac_biet\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c bi\u1ec7t\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c bi\u1ec7t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cong_thuc_dem_cac_gia_tri_so_khac_biet\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c bi\u1ec7t\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c bi\u1ec7t<\/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-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_gia_tri_khac_biet_phan_biet_chu_hoa_chu_thuong_trong_Excel\" title=\"\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/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-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Dem_cac_hang_duy_nhat_va_khac_biet_trong_Excel\" title=\"\u0110\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel\">\u0110\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t v\u00e0 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-15\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cong_thuc_dem_cac_hang_duy_nhat\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t\">C\u00f4ng th\u1ee9c \u0111\u1ebfm 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-16\" href=\"https:\/\/blog.hocexcel.online\/cach-dem-cac-gia-tri-khac-biet-va-duy-nhat-trong-excel.html#Cong_thuc_dem_cac_hang_khac_biet\" title=\"C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Truoc_tien_hay_nhac_lai_mot_so_dinh_nghia_can_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">Tr\u01b0\u1edbc ti\u00ean h\u00e3y nh\u1eafc l\u1ea1i m\u1ed9t s\u1ed1 \u0111\u1ecbnh ngh\u0129a c\u1ea7n bi\u1ebft<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">Gi\u00e1 tr\u1ecb duy nh\u1ea5t \u2013 \u0111\u00e2y l\u00e0 c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch duy nh\u1ea5t m\u1ed9t l\u1ea7n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t \u2013 t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau trong danh s\u00e1ch, ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u1ed9ng v\u1edbi l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u ti\u00ean \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau \u0111\u00e2y th\u1ec3 hi\u1ec7n s\u1ef1 kh\u00e1c bi\u1ec7t:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7825\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-8-1.png\" width=\"721\" height=\"293\" title=\"1-8-1\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\"> V\u00e0 b\u00e2y gi\u1edd, h\u00e3y xem c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c.<\/span><\/p>\n<blockquote>\n<p><span style=\"font-family: georgia, palatino, serif\">T\u1ed5ng h\u1ee3p ki\u1ebfn th\u1ee9c v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 ba\u0309n<\/a><\/span><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dem_cac_gia_tri_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t nhi\u1ec7m v\u1ee5 ph\u1ed5 bi\u1ebfn m\u00e0 t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng Excel ch\u1eafc ch\u1eafn \u0111\u1ec1u ph\u1ea3i th\u1ef1c hi\u1ec7n. B\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c d\u1eef li\u1ec7u v\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i t\u00ecm ra s\u1ed1 l\u01b0\u1ee3ng c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong danh s\u00e1ch \u0111\u00f3. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3? B\u1ea1n s\u1ebd t\u00ecm ra m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong s\u1ed1 c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_duy_nhat_trong_mot_cot\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t c\u1ed9t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u1ed9t t\u00ean trong b\u1ea3ng t\u00ednh Excel c\u1ee7a m\u00ecnh v\u00e0 b\u1ea1n c\u1ea7n \u0111\u1ebfm c\u00e1c t\u00ean duy nh\u1ea5t trong c\u1ed9t \u0111\u00f3. Gi\u1ea3i ph\u00e1p l\u00e0 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cac-vi-du-ve-ham-sum-trong-excel-cach-chi-tinh-tong-cac-cot-hang-hoac-o-duoc-hien-thi.html\">h\u00e0m SUM<\/a> k\u1ebft h\u1ee3p v\u1edbi IF v\u00e0 COUNTIF:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(COUNTIF(range, range)=1,1,0))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Ch\u00fa th\u00edch. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00ec v\u1eady h\u00e3y ch\u1eafc ch\u1eafn nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 ho\u00e0n t\u1ea5t c\u00f4ng th\u1ee9c. M\u1ed9t khi b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u00f3ng khung c\u00f4ng th\u1ee9c trong {d\u1ea5u ngo\u1eb7c nh\u1ecdn} nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta \u0111ang \u0111\u1ebfm t\u00ean duy nh\u1ea5t trong ph\u1ea1m vi A2: A10, v\u00ec v\u1eady c\u00f4ng th\u1ee9c c\u1ee7a ch\u00fang ta c\u00f3 d\u1ea1ng sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(COUNTIF(A2:A10,A2:A10)=1,1,0))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7826\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-7.png\" width=\"431\" height=\"284\" title=\"2-7\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Ngo\u00e0i ra, trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online c\u0169ng \u0111\u01b0a \u0111\u1ebfn cho c\u00e1c b\u1ea1n m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c m\u1edf r\u1ed9ng d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u1ee7a Excel \u0111\u1ec3 \u00e1p d\u1ee5ng v\u00e0o nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau. Do \u0111\u00f3, b\u1ea1n c\u1ea7n hi\u1ec3u \u0111\u1ea7y \u0111\u1ee7 v\u1ec1 c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng c\u0169ng nh\u01b0 s\u1ef1 thay \u0111\u1ed5i gi\u1eefa c\u00f4ng th\u1ee9c g\u1ed1c v\u00e0 c\u00f4ng th\u1ee9c m\u1edf r\u1ed9ng.<\/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-196.gif\" title=\"ex101_92019-nho-196\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n th\u1ea5y, 3 ch\u1ee9c n\u0103ng kh\u00e1c nhau \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c t\u00ecm gi\u00e1 tr\u1ecb duy nh\u1ea5t l\u00e0 \u2013 SUM, IF v\u00e0 COUNTIF. Nh\u00ecn m\u1ed9t c\u00e1ch c\u1ee5 th\u1ec3 ta c\u00f3:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">H\u00e0m COUNTIF \u0111\u1ebfm s\u1ed1 l\u1ea7n m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Trong v\u00ed d\u1ee5 n\u00e0y, COUNTIF(A2:A10,A2:A10) tr\u1ea3 v\u1ec1 m\u1ea3ng {1;2;2;1;2;2;2;1;2}.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">H\u00e0m IF \u0111\u00e1nh gi\u00e1 m\u1ed7i gi\u00e1 tr\u1ecb trong m\u1ea3ng tr\u1ea3 v\u1ec1 b\u1edfi COUNTIF, gi\u1eef l\u1ea1i c\u1ea3 nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u \u0111\u1ea1i di\u1ec7n cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, v\u00e0 thay th\u1ebf t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c b\u1eb1ng s\u1ed1 kh\u00f4ng.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ec v\u1eady, h\u00e0m IF(COUNTIF(A2:A10,A2:A10)=1,1,0) tr\u1edf th\u00e0nh IF(1;2;2;1;2;2;2;1;2) = 1,1,0, Trong \u0111\u00f3 1 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 0 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Cu\u1ed1i c\u00f9ng, h\u00e0m SUM th\u00eam c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ea3ng tr\u1ea3 v\u1ec1 b\u1edfi IF v\u00e0 cho ra t\u1ed5ng s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, \u0111\u00f3 l\u00e0 ch\u00ednh x\u00e1c nh\u1eefng g\u00ec ch\u00fang ta mu\u1ed1n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> M\u1eb9o. \u0110\u1ec3 xem m\u1ed9t ph\u1ea7n c\u1ee5 th\u1ec3 trong c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u1ee7a Excel, b\u1ea1n h\u00e3y ch\u1ecdn ph\u1ea7n \u0111\u00f3 trong thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n ph\u00edm F9.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_duy_nhat_dang_van_ban_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t d\u1ea1ng v\u0103n b\u1ea3n trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu danh s\u00e1ch Excel ch\u1ee9a c\u1ea3 s\u1ed1 v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, v\u00e0 b\u1ea1n ch\u1ec9 mu\u1ed1n \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n duy nh\u1ea5t, b\u1ea1n c\u1ea7n th\u00eam h\u00e0m ISTEXT v\u00e0o c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISTEXT(A2:A10)*COUNTIF(A2:A10,A2:A10)=1,1,0))<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, h\u00e0m Excel ISTEXT tr\u1ea3 v\u1ec1 TRUE n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 v\u0103n b\u1ea3n, FALSE n\u1ebfu kh\u00f4ng ph\u1ea3i v\u0103n b\u1ea3n. D\u1ea5u sao (*) ho\u1ea1t \u0111\u1ed9ng nh\u01b0 to\u00e1n t\u1eed AND trong c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e0m IF tr\u1ea3 v\u1ec1 1 ch\u1ec9 khi m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 c\u1ea3 v\u0103n b\u1ea3n v\u00e0 gi\u00e1 tr\u1ecb \u0111\u00f3 l\u00e0 duy nh\u1ea5t, 0 n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n. V\u00e0 sau khi ch\u1ee9c n\u0103ng SUM l\u1ecdc th\u00eam c\u1ea3 1 l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho nh\u1eefng gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n duy nh\u1ea5t trong ph\u1ea1m vi \u0111\u1ecbnh s\u1eb5n.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1eebng qu\u00ean nh\u1ea5n Ctrl + Shift + Enter \u0111\u1ec3 nh\u1eadp \u0111\u00fang c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7827\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-6.png\" width=\"591\" height=\"299\" title=\"3-6\"><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n duy nh\u1ea5t, tr\u1eeb \u00f4 tr\u1ed1ng, s\u1ed1, gi\u00e1 tr\u1ecb logic c\u1ee7a TRUE v\u00e0 FALSE, v\u00e0 l\u1ed7i.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_so_duy_nhat_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 duy nh\u1ea5t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 duy nh\u1ea5t trong m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng nh\u01b0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n duy nh\u1ea5t v\u1edbi s\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng ISNUMBER thay v\u00ec ISTEXT trong c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb duy nh\u1ea5t:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISNUMBER(A2:A10)*COUNTIF(A2:A10,A2:A10)=1,1,0))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7828\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-7.png\" width=\"563\" height=\"294\" title=\"4-7\"><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_duy_nhat_phan_biet_chu_hoa_chu_thuong_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t l\u00e0 t\u1ea1o ra m\u1ed9t c\u1ed9t tr\u1ee3 gi\u00fap v\u1edbi c\u00f4ng th\u1ee9c m\u1ea3ng sau \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p v\u00e0 duy nh\u1ea5t:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=IF(SUM((\u2013EXACT($A$2:$A$10,A2)))=1,\u201dUnique\u201d,\u201dDupe\u201d)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00e0 sau \u0111\u00f3, s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m COUNTIF \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=COUNTIF(B2:B10, \u201cunique\u201d)<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7829\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-7.png\" width=\"671\" height=\"289\" title=\"5-7\"><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_khac_biet_trong_Excel_gia_tri_duy_nhat_va_1_xuat_hien_dai_dien_cho_cac_gia_tri_trung_lap\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel (gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 1 xu\u1ea5t hi\u1ec7n \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong m\u1ed9t danh s\u00e1ch, ta s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(1\/COUNTIF(range, range))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> H\u00e3y nh\u1edb r\u1eb1ng, \u0111\u00f3 l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00e0 do \u0111\u00f3 b\u1ea1n n\u00ean nh\u1ea5n ph\u00edm t\u1eaft Ctrl + Shift + Enter thay v\u00ec ph\u00edm Enter nh\u01b0 th\u00f4ng th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">SUMPRODUCT <\/a>v\u00e0 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch nh\u1ea5n ph\u00edm Enter:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUMPRODUCT(1\/COUNTIF(range, range))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong ph\u1ea1m vi A2: A10, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(1\/COUNTIF(A2:A10,A2:A10))<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Ho\u1eb7c<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUMPRODUCT(1\/COUNTIF(A2:A10,A2:A10))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7830\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-7.png\" width=\"642\" height=\"254\" title=\"6-7\"><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_hoat_dong_cua_cong_thuc_gia_tri_khac_biet_cua_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t c\u1ee7a Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 t\u00ecm ra s\u1ed1 l\u1ea7n m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. Trong v\u00ed d\u1ee5 tr\u00ean, k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIF l\u00e0 m\u1ea3ng sau: {2;2;3;1;2;2;3;1;3}.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Sau \u0111\u00f3, m\u1ed9t s\u1ed1 ho\u1ea1t \u0111\u1ed9ng ph\u00e2n chia \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n, trong \u0111\u00f3 m\u1ed7i gi\u00e1 tr\u1ecb c\u1ee7a m\u1ea3ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t s\u1ed1 chia v\u1edbi 1 l\u00e0 c\u1ed5 t\u1ee9c. \u0110i\u1ec1u n\u00e0y s\u1ebd bi\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p th\u00e0nh c\u00e1c s\u1ed1 ph\u00e2n s\u1ed1 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u00f9ng l\u1eb7p. V\u00ed d\u1ee5, n\u1ebfu m\u1ed9t gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n 2 l\u1ea7n trong danh s\u00e1ch, n\u00f3 t\u1ea1o ra 2 m\u1ee5c trong m\u1ea3ng v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb l\u00e0 0.5 (1\/2=0.5). V\u00e0 n\u1ebfu gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n 3 l\u1ea7n, n\u00f3 s\u1ebd t\u1ea1o ra 3 m\u1ee5c trong m\u1ea3ng v\u1edbi gi\u00e1 tr\u1ecb l\u00e0 0.3(3). Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, k\u1ebft qu\u1ea3 c\u1ee7a 1\/COUNTIF(A2:A10,A2:A10)) l\u00e0 m\u1ea3ng {0.5;0.5;0.3(3);1;0.5;0.5;0.3(3);1;0.3(3)}.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Khi m\u1ed9t trong c\u00e1c h\u00e0m n\u00e0y c\u1ed9ng th\u00eam c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ea3ng, t\u1ed5ng c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 ph\u00e2n s\u1ed1 cho m\u1ed7i m\u1ee5c ri\u00eang l\u1ebb lu\u00f4n l\u00e0 1, cho d\u00f9 c\u00f3 bao nhi\u00eau l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ee5c \u0111\u00f3 t\u1ed3n t\u1ea1i trong danh s\u00e1ch. V\u00e0 b\u1edfi v\u00ec t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t xu\u1ea5t hi\u1ec7n trong m\u1ea3ng l\u00e0 l\u1ea7n \u0111\u1ea1i di\u1ec7n duy nh\u1ea5t (1\/1=1), k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00f4ng th\u1ee9c l\u00e0 t\u1ed5ng s\u1ed1 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau trong danh s\u00e1ch<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_cac_gia_tri_khac_biet_theo_nhung_cach_khac_nhau\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t theo nh\u1eefng c\u00e1ch kh\u00e1c nhau<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">C\u0169ng nh\u01b0 tr\u01b0\u1eddng h\u1ee3p \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c bi\u1ebfn th\u1ec3 c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 Excel c\u01a1 b\u1ea3n \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c lo\u1ea1i gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 nh\u01b0 s\u1ed1, v\u0103n b\u1ea3n v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">H\u00e3y nh\u1edb r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 y\u00eau c\u1ea7u nh\u1ea5n Ctrl + Shift + Enter khi ho\u00e0n t\u1ea5t c\u00f4ng th\u1ee9c.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_khac_biet_bo_qua_o_trong\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t b\u1ecf qua \u00f4 tr\u1ed1ng<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">N\u1ebfu m\u1ed9t c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t c\u00f3 ch\u1ee9a c\u00e1c \u00f4 tr\u1ed1ng, b\u1ea1n n\u00ean th\u00eam m\u1ed9t h\u00e0m IF \u0111\u1ec3 ki\u1ec3m tra ph\u1ea1m vi quy \u0111\u1ecbnh cho kho\u1ea3ng tr\u1ed1ng (c\u00f4ng th\u1ee9c Excel c\u01a1 b\u1ea3n \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn \u1edf tr\u00ean s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #DIV\/0 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y):<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(range&lt;&gt;\u201d\u201d,1\/COUNTIF(range, range), 0))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ed d\u1ee5: \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong d\u1ea3i A2: A10, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(A2:A10&lt;&gt;\u201d\u201d,1\/COUNTIF(A2:A10, A2:A10), 0))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7831\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-6.png\" width=\"437\" height=\"294\" title=\"7-6\"><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_cac_gia_tri_van_ban_khac_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c bi\u1ec7t trong m\u1ed9t c\u1ed9t, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p t\u01b0\u01a1ng t\u1ef1 m\u00e0 \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i tr\u1eeb c\u00e1c \u00f4 tr\u1ed1ng.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111o\u00e1n \u0111\u01b0\u1ee3c, ch\u00fang ta ch\u1ec9 \u0111\u01a1n gi\u1ea3n l\u00e0 th\u00eam h\u00e0m ISTEXT v\u00e0o c\u00f4ng th\u1ee9c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t trong Excel:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISTEXT(range),1\/COUNTIF(range, range),\u201d\u201d))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00e0 \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng th\u1ee9c th\u1ef1c t\u1ebf:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISTEXT(A2:A10),1\/COUNTIF(A2:A10, A2:A10),\u201d\u201d))<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_cac_gia_tri_so_khac_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1 kh\u00e1c bi\u1ec7t (s\u1ed1, ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian), ta s\u1eed d\u1ee5ng h\u00e0m ISNUMBER:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISNUMBER(range),1\/COUNTIF(range, range),\u201d\u201d))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> V\u00ed d\u1ee5, \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 kh\u00e1c nhau trong ph\u1ea1m vi A2: A10, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(ISNUMBER(A2:A10),1\/COUNTIF(A2:A10, A2:A10),\u201d\u201d))<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_gia_tri_khac_biet_phan_biet_chu_hoa_chu_thuong_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t c\u00f3 ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng l\u00e0 th\u00eam c\u1ed9t tr\u1ee3 gi\u00fap b\u1eb1ng c\u00f4ng th\u1ee9c m\u1ea3ng x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t k\u1ec3 c\u1ea3 l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u00f9ng l\u1eb7p \u0111\u1ea7u ti\u00ean. C\u00f4ng th\u1ee9c n\u00e0y v\u1ec1 c\u01a1 b\u1ea3n gi\u1ed1ng nh\u01b0 c\u00f4ng th\u1ee9c m\u00e0 ch\u00fang ta \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, v\u1edbi m\u1ed9t thay \u0111\u1ed5i nh\u1ecf trong m\u1ed9t tham chi\u1ebfu \u00f4 nh\u01b0ng l\u1ea1i t\u1ea1o ra s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=IF(SUM((\u2013EXACT($A$2:$A2,$A2)))=1,\u201dDistinct\u201d,\u201d\u201d)<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">T\u1ea5t nhi\u00ean, v\u1eabn ph\u1ea3i nh\u1edb r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng trong Excel y\u00eau c\u1ea7u nh\u1ea5n Ctrl + Shift + Enter.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Sau khi c\u00f4ng th\u1ee9c tr\u00ean k\u1ebft th\u00fac, h\u00e3y vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c COUNTIF th\u00f4ng th\u01b0\u1eddng nh\u01b0 =COUNTIF(B2:B10, \u201cdistinct\u201d) \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t:<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7832\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-6.png\" width=\"620\" height=\"280\" title=\"8-6\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> N\u1ebfu b\u1ea1n kh\u00f4ng th\u1ec3 th\u00eam m\u1ed9t c\u1ed9t tr\u1ee3 gi\u00fap v\u00e0o b\u1ea3ng t\u00ednh th\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng ph\u1ee9c t\u1ea1p sau \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o c\u1ed9t b\u1ed5 sung:<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IFERROR(1\/IF($A$2:$A$10&lt;&gt;\u201d\u201d, FREQUENCY(IF(EXACT($A$2:$A$10, TRANSPOSE($A$2:$A$10)), MATCH(ROW($A$2:$A$10), ROW($A$2:$A$10)), \u201c\u201d), MATCH(ROW($A$2:$A$10), ROW($A$2:$A$10))), 0), 0))<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dem_cac_hang_duy_nhat_va_khac_biet_trong_Excel\"><\/span><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t \/ kh\u00e1c bi\u1ec7t trong Excel gi\u1ed1ng nh\u01b0 vi\u1ec7c \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 ri\u00eang bi\u1ec7t, v\u1edbi s\u1ef1 kh\u00e1c bi\u1ec7t duy nh\u1ea5t l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COUNTIFS thay v\u00ec COUNTIF, h\u00e0m n\u00e0y cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh m\u1ed9t v\u00e0i c\u1ed9t \u0111\u1ec3 ki\u1ec3m tra c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">V\u00ed d\u1ee5: \u0111\u1ec3 \u0111\u1ebfm c\u00e1c t\u00ean duy nh\u1ea5t ho\u1eb7c kh\u00e1c bi\u1ec7t d\u1ef1a tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t A (First Name) v\u00e0 B (Last Name), h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_cac_hang_duy_nhat\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(IF(COUNTIFS(A2:A10,A2:A10, B2:B10,B2:B10)=1,1,0))<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_dem_cac_hang_khac_biet\"><\/span><span style=\"font-family: georgia, palatino, serif\">C\u00f4ng th\u1ee9c \u0111\u1ebfm c\u00e1c h\u00e0ng kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-family: georgia, palatino, serif\">=SUM(1\/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10))<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7833\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-6.png\" width=\"478\" height=\"287\" title=\"9-6\"><\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> \u0110\u01b0\u01a1ng nhi\u00ean, kh\u00f4ng ph\u1ea3i khi \u0111\u1ebfm c\u00e1c h\u00e0ng duy nh\u1ea5t b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u1ebfm trong gi\u1edbi h\u1ea1n 2 c\u1ed9t nh\u01b0 \u1edf trong v\u00ed d\u1ee5, h\u00e0m COUNTIFS c\u00f3 th\u1ec3 x\u1eed l\u00fd 127 ph\u1ea1m vi \/ c\u1eb7p ti\u00eau chu\u1ea9n.<\/span><br \/>\n<span style=\"font-family: georgia, palatino, serif\"> Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 gi\u1edbi thi\u1ec7u cho c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel. Hy v\u1ecdng b\u00e0i vi\u1ebft c\u00f3 th\u1ec3 \u0111em l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1i nh\u00ecn t\u1ed5ng quan c\u0169ng nh\u01b0 nh\u1eefng c\u00f4ng th\u1ee9c h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft n\u00e0y.<a href=\"http:\/\/bit.ly\/2rPfrhk\" target=\"_blank\" rel=\"noopener noreferrer\"><br \/>\n<\/a><\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m n\u00e2ng cao trong Excel c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng t\u1ed1t h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1c b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2waTldp\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, gi\u00fap b\u1ea1n ph\u00e1t tri\u1ec3n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng. \u0110\u1eb7c bi\u1ec7t kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian h\u1ecdc t\u1eadp, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc tho\u1ea3i m\u00e1i v\u00e0 xem l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o.<\/span><\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/span><\/p>\n<p>\u00a0<\/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-196.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2536,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2535","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\/2535","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=2535"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2535\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2536"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}