{"id":7789,"date":"2024-12-21T18:30:34","date_gmt":"2024-12-21T18:30:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat\/"},"modified":"2024-12-21T18:30:34","modified_gmt":"2024-12-21T18:30:34","slug":"cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat\/","title":{"rendered":"C\u00e1ch d\u00f9ng COUNTIF \u0111\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, \u0111\u1ebfm gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p ho\u1eb7c duy nh\u1ea5t"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Microsoft Excel cung c\u1ea5p r\u1ea5t nhi\u1ec1u h\u00e0m nh\u1eb1m m\u1ee5c \u0111\u00edch \u0111\u1ebfm nh\u1eefng lo\u1ea1i \u00f4 kh\u00e1c nhau, ch\u1eb3ng h\u1ea1n nh\u01b0 \u00f4 tr\u1ed1ng ho\u1eb7c \u00f4 kh\u00f4ng tr\u1ed1ng, s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c gi\u00e1 tr\u1ecb ch\u1eef, ch\u1ee9a c\u00e1c t\u1eeb ho\u1eb7c k\u00fd t\u1ef1 c\u1ee5 th\u1ec3, v.v \u2026<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd t\u1eadp trung v\u00e0o <a href=\"http:\/\/blog.ezworkapp.com\/dem-co-dieu-kien-ham-countif-co-ban.html\"><strong>h\u00e0m COUNTIF<\/strong><\/a> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 v\u1edbi \u0111i\u1ec1u ki\u1ec7n ch\u1ec9 \u0111\u1ecbnh. Tr\u01b0\u1edbc ti\u00ean, ch\u00fang ta s\u1ebd tr\u00ecnh b\u00e0y ng\u1eafn g\u1ecdn v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chung, v\u00e0 sau \u0111\u00f3 l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u00e0 c\u1ea3nh b\u00e1o v\u1ec1 nh\u1eefng \u0111i\u1ec1u c\u00f3 th\u1ec3 x\u1ea3y ra khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1c \u00f4 \u0111\u1eb7c th\u00f9.<\/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-67670949ae954\" 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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Ham_COUNTIF_%E2%80%93_cu_phap_va_cach_su_dung\" title=\"H\u00e0m COUNTIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:\">H\u00e0m COUNTIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Ham_COUNTIF_cho_van_ban_va_so_chinh_xac_tuyet_doi\" title=\"H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)\">H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Ham_COUNTIF_voi_ky_tu_dai_dien_khop_mot_phan\" title=\"H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)\">H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Dem_cac_o_bat_dau_hoac_ket_thuc_bang_cac_ky_tu_nhat_dinh\" title=\"\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh\">\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#COUNTIF_o_khong_trong\" title=\"COUNTIF \u00f4 kh\u00f4ng tr\u1ed1ng:\">COUNTIF \u00f4 kh\u00f4ng tr\u1ed1ng:<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#COUNTIF_o_trong\" title=\"COUNTIF \u00f4 tr\u1ed1ng:\">COUNTIF \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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#COUNTIF_lon_hon_nho_hon_hoac_bang\" title=\"COUNTIF l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:\">COUNTIF l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Su_dung_ham_COUNTIF_voi_ngay\" title=\"S\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi ng\u00e0y:\">S\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi ng\u00e0y:<\/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-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Ham_COUNTIF_voi_nhieu_dieu_kien\" title=\"H\u00e0m COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:\">H\u00e0m COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-countif-dem-gia-tri-lon-hon-dem-gia-tri-trung-lap-hoac-duy-nhat.html#Su_dung_chuc_nang_COUNTIF_de_tim_cac_gia_tri_lap_va_gia_tri_duy_nhat\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng COUNTIF \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p v\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t:\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng COUNTIF \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p v\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_%E2%80%93_cu_phap_va_cach_su_dung\"><\/span><strong>H\u00e0m COUNTIF \u2013 c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m <strong>COUNTIF<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 trong m\u1ed9t ph\u1ea1m vi quy \u0111\u1ecbnh \u0111\u00e1p \u1ee9ng m\u1ed9t ti\u00eau ch\u00ed, ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c COUNTIF \u0111\u1ec3 t\u00ecm ra c\u00f3 bao nhi\u00eau \u00f4 trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u1ee9a s\u1ed1 l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n s\u1ed1 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. Ho\u1eb7c \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 v\u1edbi m\u1ed9t t\u1eeb c\u1ee5 th\u1ec3 ho\u1eb7c b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t (c\u00e1c) ch\u1eef c\u00e1i c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIF r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n<p style=\"text-align: justify\"><strong>COUNTIF(range, criteria)<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, ch\u1ec9 c\u00f3 2 \u0111\u1ed1i s\u1ed1, c\u1ea3 hai \u0111\u1ec1u \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-318.gif\" title=\"vba101_92019-nho-318\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-701.gif\" title=\"ex101_92019-nho-701\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>Range<\/strong> \u2013 x\u00e1c \u0111\u1ecbnh m\u1ed9t ho\u1eb7c nhi\u1ec1u \u00f4 \u0111\u1ec3 \u0111\u1ebfm. B\u1ea1n \u0111\u1eb7t ph\u1ea1m vi trong c\u00f4ng th\u1ee9c nh\u01b0 b\u1ea1n th\u01b0\u1eddng l\u00e0m trong Excel, v\u00ed d\u1ee5: A1: A20.<\/p>\n<p style=\"text-align: justify\"><strong>Criteria<\/strong> \u2013 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n \u0111\u1ebfm \u00f4. N\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, chu\u1ed7i v\u0103n b\u1ea3n, \u00f4 tham chi\u1ebfu ho\u1eb7c bi\u1ec3u th\u1ee9c. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ti\u00eau ch\u00ed nh\u01b0 sau: \u201c10\u201d, A2, \u201c&gt; = 10\u201d, \u201ct\u1eeb g\u00ec \u0111\u00f3\u201d.<\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 \u0111\u01a1n gi\u1ea3n nh\u1ea5t v\u1ec1 h\u00e0m <strong>COUNTIF<\/strong>. Nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi l\u00e0 danh s\u00e1ch nh\u1eefng tay v\u1ee3t gi\u1ecfi nh\u1ea5t trong 14 n\u0103m qua. C\u00f4ng th\u1ee9c <strong>= COUNTIF (C2: C15, \u201cRoger Federer\u201d)<\/strong> t\u00ednh s\u1ed1 l\u1ea7n Roger Federer c\u00f3 t\u00ean trong danh s\u00e1ch:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5262 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight.png\" width=\"317\" height=\"364\" title=\"excel-find-replace-highlight\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>: \u0110i\u1ec1u ki\u1ec7n kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng, c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n nh\u1eadp \u201croger federer\u201d l\u00e0m \u0111i\u1ec1u ki\u1ec7n trong c\u00f4ng th\u1ee9c tr\u00ean, th\u00ec k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 v\u1ec1 h\u00e0m COUNTIF <\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIF r\u1ea5t \u0111\u01a1n gi\u1ea3n. Tuy nhi\u00ean, n\u00f3 cho ph\u00e9p nhi\u1ec1u bi\u1ebfn th\u1ec3 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n, bao g\u1ed3m c\u00e1c k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 kh\u00e1c, v\u00e0 th\u1eadm ch\u00ed c\u00e1c h\u00e0m Excel kh\u00e1c. T\u00ednh \u0111a d\u1ea1ng n\u00e0y l\u00e0m cho h\u00e0m COUNTIF th\u1ef1c s\u1ef1 m\u1ea1nh m\u1ebd v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhi\u1ec1u nhi\u1ec7m v\u1ee5, nh\u01b0 b\u1ea1n s\u1ebd th\u1ea5y trong c\u00e1c v\u00ed d\u1ee5 ti\u1ebfp theo.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_cho_van_ban_va_so_chinh_xac_tuyet_doi\"><\/span><strong>H\u00e0m COUNTIF cho v\u0103n b\u1ea3n v\u00e0 s\u1ed1 (ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tr\u00ean th\u1ef1c t\u1ebf, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn v\u1ec1 h\u00e0m COUNTIF \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb ch\u1eef kh\u1edbp v\u1edbi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i v\u1eeba r\u1ed3i. H\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc l\u1ea1i c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 c\u00f3 ch\u1ee9a m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n: <strong>= COUNTIF (C2: C15, \u201cRoger Federer\u201d)<\/strong>. V\u00ec v\u1eady, b\u1ea1n nh\u1eadp:<\/p>\n<ul style=\"text-align: justify\">\n<li>V\u00f9ng ch\u1ecdn \u0111\u1ebfm l\u00e0 tham s\u1ed1 \u0111\u1ea7u ti\u00ean;<\/li>\n<li>D\u1ea5u ph\u1ea9y nh\u01b0 d\u1ea5u ph\u00e2n c\u00e1ch;<\/li>\n<li>M\u1ed9t t\u1eeb ho\u1eb7c m\u1ed9t s\u1ed1 t\u1eeb trong d\u1ea5u ngo\u1eb7c k\u00e9p l\u00e0m \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Thay v\u00ec nh\u1eadp l\u1ea1i t\u1eeb, b\u1ea1n c\u00f3 th\u1ec3 <strong>s\u1eed d\u1ee5ng tham chi\u1ebfu \u0111\u1ebfn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o<\/strong> ch\u1ee9a t\u1eeb ho\u1eb7c c\u00e1c t\u1eeb \u0111\u00f3 v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng t\u1ef1, v\u00ed d\u1ee5: <strong>= COUNTIF (C1: C9, C7)<\/strong>.<\/p>\n<p style=\"text-align: justify\">H\u00e0m COUNTIF d\u00f9ng t\u01b0\u01a1ng t\u1ef1 cho s\u1ed1. Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c <strong>= COUNTIF (D2: D9,5)<\/strong> \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb 5 \u1edf C\u1ed9t D.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5263 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-1-1.png\" width=\"276\" height=\"246\" title=\"excel-find-replace-highlight-1-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_voi_ky_tu_dai_dien_khop_mot_phan\"><\/span><strong>H\u00e0m COUNTIF v\u1edbi k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (kh\u1edbp m\u1ed9t ph\u1ea7n)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p d\u1eef li\u1ec7u Excel c\u1ee7a b\u1ea1n bao g\u1ed3m m\u1ed9t v\u00e0i bi\u1ebfn th\u1ec3 c\u1ee7a (c\u00e1c) t\u1eeb kho\u00e1 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a m\u1ed9t t\u1eeb, c\u1ee5m t\u1eeb ho\u1eb7c ch\u1eef c\u00e1i nh\u1ea5t \u0111\u1ecbnh nh\u01b0 m\u1ed9t ph\u1ea7n c\u1ee7a n\u1ed9i dung \u00f4.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao cho nh\u1eefng ng\u01b0\u1eddi kh\u00e1c nhau v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao cho Danny Brown. B\u1edfi v\u00ec t\u00ean c\u1ee7a Danny \u0111\u01b0\u1ee3c vi\u1ebft b\u1eb1ng nhi\u1ec1u c\u00e1ch kh\u00e1c nhau, ta nh\u1eadp \u201c* Brown *\u201d l\u00e0 \u0111i\u1ec1u ki\u1ec7n <strong>= COUNTIF (D2: D10, \u201c*Brown *\u201d)<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5264 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-2-300x250-2.png\" width=\"300\" height=\"250\" title=\"excel-find-replace-highlight-2-300x250-2\"><\/p>\n<p style=\"text-align: justify\">D\u1ea5u hoa th\u1ecb <strong>(*)<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ea7u v\u00e0 cu\u1ed1i, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong v\u00ed d\u1ee5 tr\u00ean. N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i kh\u1edbp t\u1eebng k\u00fd t\u1ef1 \u0111\u01a1n, h\u00e3y nh\u1eadp m\u1ed9t d\u1ea5u h\u1ecfi <strong>(?)<\/strong>, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dem_cac_o_bat_dau_hoac_ket_thuc_bang_cac_ky_tu_nhat_dinh\"><\/span><strong>\u0110\u1ebfm c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n, d\u1ea5u sao (*) ho\u1eb7c d\u1ea5u ch\u1ea5m h\u1ecfi (?), v\u1edbi t\u00f9y thu\u1ed9c v\u00e0o k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng v\u0103n b\u1ea3n nh\u1ea5t \u0111\u1ecbnh b\u1ea5t k\u1ec3 c\u00f3 bao nhi\u00eau k\u00fd t\u1ef1 kh\u00e1c trong \u00f4, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (C2: C10, \u201c<\/strong><strong>Mr*\u201d)<\/strong> \u2013 t\u00ednh c\u00e1c \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201cMr\u201d.<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (C2: C10, \u201c* ed\u201d)<\/strong> \u2013 t\u00ednh c\u00e1c \u00f4 k\u1ebft th\u00fac b\u1eb1ng ch\u1eef \u201ced\u201d.<\/p>\n<p style=\"text-align: justify\">H\u00ecnh \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y minh h\u1ecda cho c\u00f4ng th\u1ee9c th\u1ee9 hai:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5265 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-3-1.png\" width=\"335\" height=\"243\" title=\"excel-find-replace-highlight-3-1\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng c\u00e1c k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh v\u00e0 ch\u1ee9a m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi d\u1ea5u h\u1ecfi (?) t\u1ea1i \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (D2: D9, \u201c??own\u201d)<\/strong> \u2013 \u0111\u1ebfm s\u1ed1 \u00f4 k\u1ebft th\u00fac b\u1eb1ng ch\u1eef \u201cown\u201d v\u00e0 c\u00f3 ch\u00ednh x\u00e1c 5 k\u00fd t\u1ef1 trong c\u00e1c \u00f4 t\u1eeb D2 \u0111\u1ebfn D9, bao g\u1ed3m c\u1ea3 kho\u1ea3ng c\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (D2: D9, \u201cMr ??????\u201d)<\/strong> \u2013 \u0111\u1ebfm s\u1ed1 \u00f4 b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef \u201cMr\u201d v\u00e0 c\u00f3 ch\u00ednh x\u00e1c 8 k\u00fd t\u1ef1 trong c\u00e1c \u00f4 t\u1eeb D2 \u0111\u1ebfn D9, bao g\u1ed3m kho\u1ea3ng c\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o<\/strong>. \u0110\u1ec3 t\u00ecm s\u1ed1 \u00f4 ch\u1ee9a d\u1ea5u h\u1ecfi \u201c?\u201d ho\u1eb7c d\u1ea5u hoa th\u1ecb \u201c*\u201d, h\u00e3y g\u00f5 d\u1ea5u ng\u00e3 (~) tr\u01b0\u1edbc d\u1ea5u ? ho\u1eb7c * trong c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5, <strong>= COUNTIF (D2: D9, \u201c* ~? *\u201d)<\/strong> \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1ea5u ch\u1ea5m h\u1ecfi trong d\u1ea3i D2: D9.<\/p>\n<p style=\"text-align: justify\"><strong>H\u00e0m COUNTIF cho \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng tr\u1ed1ng<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00ed d\u1ee5 sau th\u1ec3 hi\u1ec7n c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong Excel \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng ho\u1eb7c kh\u00f4ng tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"COUNTIF_o_khong_trong\"><\/span><strong>COUNTIF \u00f4 kh\u00f4ng tr\u1ed1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Trong m\u1ed9t s\u1ed1 h\u01b0\u1edbng d\u1eabn h\u00e0m COUNTIF kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u00ednh c\u00e1c \u00f4 kh\u00f4ng tr\u1ed1ng trong Excel nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (range, \u201c*\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng th\u1ef1c t\u1ebf l\u00e0, c\u00f4ng th\u1ee9c tr\u00ean ch\u1ec9 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n n\u00e0o, c\u00f3 ngh\u0129a l\u00e0 c\u00e1c \u00f4 c\u00f3 ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 s\u1ebd \u0111\u01b0\u1ee3c coi l\u00e0 c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ebfm!<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 kh\u00f4ng ph\u1ea3i l\u00e0 \u00f4 tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi x\u00e1c \u0111\u1ecbnh, h\u00e3y d\u00f9ng:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (range, \u201c&lt;&gt;\u201d &amp; \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i gi\u00e1 tr\u1ecb \u2013 v\u0103n b\u1ea3n, ng\u00e0y v\u00e0 s\u1ed1 \u2013 nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5266 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-4.png\" width=\"443\" height=\"287\" title=\"excel-find-replace-highlight-4\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"COUNTIF_o_trong\"><\/span><strong>COUNTIF \u00f4 tr\u1ed1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng \u1edf m\u1ed9t v\u00f9ng nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c c\u00f3 k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n ho\u1eb7c m\u1ed9t ti\u00eau chu\u1ea9n kh\u00e1c (v\u1edbi ti\u00eau ch\u00ed \u201c\u201d) \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 r\u1ed7ng.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u00ednh c\u00e1c \u00f4 kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 v\u0103n b\u1ea3n n\u00e0o: <strong>= COUNTIF (range, \u201c&lt;&gt;\u201d &amp; \u201c*\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00f4ng th\u1ee9c tr\u00ean (\u201c&lt;&gt;\u201d &amp; \u201c*\u201d) c\u00f3 ngh\u0129a l\u00e0 t\u00ecm c\u00e1c \u00f4 kh\u00f4ng b\u1eb1ng *, t\u1ee9c l\u00e0 kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 v\u0103n b\u1ea3n n\u00e0o trong ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u1ed5ng qu\u00e1t h\u00e0m COUNTIF cho kho\u1ea3ng tr\u1ed1ng (t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i gi\u00e1 tr\u1ecb):<strong> = COUNTIF (range, \u201c\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ebfm s\u1ed1, ng\u00e0y v\u00e0 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c <strong>= COUNTIF (C2: C11, \u201c\u201d)<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng trong d\u1ea3i C2: C11.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. H\u00e3y l\u01b0u \u00fd r\u1eb1ng Microsoft Excel cung c\u1ea5p m\u1ed9t ch\u1ee9c n\u0103ng kh\u00e1c \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 tr\u1ed1ng <strong>= COUNTBLANK (range)<\/strong>. V\u00ed d\u1ee5: c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y s\u1ebd cho k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c gi\u1ed1ng nh\u01b0 c\u00f4ng th\u1ee9c COUNTIF b\u1ea1n th\u1ea5y trong h\u00ecnh \u1edf tr\u00ean:<\/p>\n<p style=\"text-align: justify\">\u0110\u1ebfm kho\u1ea3ng tr\u1ed1ng: <strong>= COUNTBLANK (C2: C11)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ebfm kh\u00f4ng kho\u1ea3ng c\u00e1ch: <strong>= ROWS (C2: C11) * COLUMNS (C2: C11) -COUNTBLANK (C2: C11)<\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, xin l\u01b0u \u00fd r\u1eb1ng c\u1ea3 hai <strong>= COUNTIF (range, \u201c\u201d)<\/strong> v\u00e0<strong> = COUNTBLANK (range)<\/strong> \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng \u00f4 tr\u1ed1ng. N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n coi c\u00e1c \u00f4 \u0111\u00f3 l\u00e0 kho\u1ea3ng tr\u1ed1ng, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y: <strong>= ROWS (C2: \u042111) * COLUMNS (C2: \u042111) -countif(C2: \u042111, \u201c&lt;&gt;\u201d &amp; \u201c\u201d).<\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"COUNTIF_lon_hon_nho_hon_hoac_bang\"><\/span><strong>COUNTIF l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng s\u1ed1 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh, b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam d\u1ea5u so s\u00e1nh t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c \u0111i\u1ec3u ki\u1ec7n, nh\u01b0 th\u1ec3 hi\u1ec7n trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u01b0u \u00fd r\u1eb1ng trong c\u00e1c c\u00f4ng th\u1ee9c COUNTIF, m\u1ed9t d\u1ea5u so s\u00e1nh v\u1edbi m\u1ed9t s\u1ed1 lu\u00f4n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p.<\/p>\n<table style=\"height: 348px\" width=\"618\">\n<tbody>\n<tr>\n<td style=\"width: 198.24px\"><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td style=\"width: 200.16px\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<td style=\"width: 199.52px\"><strong>Di\u1ec5n gi\u1ea3i<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu l\u1edbn h\u01a1n<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(A2:A10,\u201d&gt;5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu b\u00e9 h\u01a1n<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(A2:A10,\u201d&lt;5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u00e9 h\u01a1n 5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu b\u1eb1ng<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(A2:A10,\u201d=5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng \u00a05<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu kh\u00e1c<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(A2:A10,\u201d&lt;&gt;5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c 5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu b\u1eb1ng ho\u1eb7c l\u1edbn h\u01a1n<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(C2:C8,\u201d&gt;=5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 5<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 198.24px\">\u0110\u1ebfm n\u1ebfu b\u1eb1ng ho\u1eb7c b\u00e9 h\u01a1n<\/td>\n<td style=\"width: 200.16px\">=COUNTIF(C2:C8,\u201d&lt;=5\u2033)<\/td>\n<td style=\"width: 199.52px\">\u0110\u1ebfm nh\u1eefng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u00e9 h\u01a1n ho\u1eb7c b\u1eb1ng 5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4 kh\u00e1c, ch\u1ec9 c\u1ea7n thay th\u1ebf s\u1ed1 trong c\u00e1c ti\u00eau ch\u00ed b\u1eb1ng \u00f4 tham chi\u1ebfu.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a \u00f4 tham chi\u1ebfu, b\u1ea1n ph\u1ea3i \u0111\u1eb7t c\u00e1c d\u1ea5u so s\u00e1nh trong d\u1ea5u nh\u00e1y k\u00e9p v\u00e0 th\u00eam m\u1ed9t d\u1ea5u hi\u1ec7u v\u00e0 (&amp;) tr\u01b0\u1edbc \u00f4 tham chi\u1ebfu. V\u00ed d\u1ee5, \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n \u00f4 D3 trong d\u1ea3i D2: D9, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c <strong>= COUNTIF (D2: D9, \u201c&gt;\u201d &amp; D3)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5267 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-5.png\" width=\"487\" height=\"244\" title=\"excel-find-replace-highlight-5\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a c\u00e1c so s\u00e1nh nh\u01b0 l\u00e0 m\u1ed9t ph\u1ea7n n\u1ed9i dung c\u1ee7a \u00f4, ngh\u0129a l\u00e0 c\u00e1c k\u00fd t\u1ef1 \u201c&gt;\u201d, \u201c&lt;\u201d ho\u1eb7c \u201c=\u201d, sau \u0111\u00f3 l\u00e0 m\u1ed9t s\u1ed1 trong c\u00e1c \u0111i\u1ec1u ki\u1ec7n. \u0110i\u1ec1u ki\u1ec7n nh\u01b0 v\u1eady s\u1ebd \u0111\u01b0\u1ee3c coi nh\u01b0 l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t bi\u1ec3u th\u1ee9c s\u1ed1. V\u00ed d\u1ee5: c\u00f4ng th\u1ee9c <strong>= COUNTIF (D2: D9, \u201c*&gt; 5 *\u201d)<\/strong> s\u1ebd t\u00ednh t\u1ea5t c\u1ea3 \u00f4 trong d\u1ea3i D2: D9 v\u1edbi n\u1ed9i dung nh\u01b0 \u201cGiao h\u00e0ng&gt; 5 ng\u00e0y\u201d ho\u1eb7c \u201c&gt; 5 c\u00f3 s\u1eb5n\u201d.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_COUNTIF_voi_ngay\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m COUNTIF v\u1edbi ng\u00e0y:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm \u00f4 v\u1edbi ng\u00e0y th\u00e1ng l\u1edbn h\u01a1n, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y b\u1ea1n ch\u1ec9 \u0111\u1ecbnh ho\u1eb7c ng\u00e0y trong m\u1ed9t \u00f4 kh\u00e1c, b\u1ea1n h\u00e3y l\u00e0m theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1 \u0111\u00e3 l\u00e0m tr\u01b0\u1edbc \u0111\u00f3. T\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean dung cho ng\u00e0y th\u00e1ng nh\u01b0 cho c\u00e1c con s\u1ed1. Sau \u0111\u00e2y l\u00e0 v\u00e0i v\u00ed d\u1ee5:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"187\"><strong>\u0110i\u1ec1u ki\u1ec7n<\/strong><\/td>\n<td width=\"225\"><strong>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/strong><\/td>\n<td width=\"189\"><strong>Di\u1ec5n gi\u1ea3i<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"187\"><strong>\u0110\u1ebfm m\u1ed9t ng\u00e0y c\u1ee5 th\u1ec3<\/strong><\/td>\n<td width=\"225\">=COUNTIF(B2:B10,\u201d6\/1\/2014\u2033)<\/td>\n<td width=\"189\">\u0110\u1ebfm s\u1ed1 \u00f4 trong v\u00f9ng B2:B10 c\u00f3 ng\u00e0y 6\/1\/2014<\/td>\n<\/tr>\n<tr>\n<td width=\"187\"><strong>\u0110\u1ebfm ng\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t ng\u00e0y kh\u00e1c<\/strong><\/td>\n<td width=\"225\">=COUNTIF(B2:B10,\u201d&gt;=6\/1\/2014\u2033)<\/td>\n<td width=\"189\">\u0110\u1ebfm s\u1ed1 \u00f4 trong v\u00f9ng B2:B10 c\u00f3 ng\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 6\/1\/2014<\/td>\n<\/tr>\n<tr>\n<td width=\"187\"><strong>\u0110\u1ebfm ng\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y trong m\u1ed9t \u00f4 kh\u00e1c tr\u1eeb \u0111i x ng\u00e0y<\/strong><\/td>\n<td width=\"225\">=COUNTIF(B2:B10,\u201d&gt;=\u201d&amp;B2-\u201c7\u201d)<\/td>\n<td width=\"189\">\u0110\u1ebfm s\u1ed1 \u00f4 trong v\u00f9ng B2:B10 c\u00f3 ng\u00e0y l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng ng\u00e0y trong \u00f4 B2 tr\u1eeb \u0111i 7 ng\u00e0y<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Ngo\u00e0i nh\u1eefng c\u00f4ng th\u1ee9c ph\u1ed5 bi\u1ebfn n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m Excel ng\u00e0y v\u00e0 gi\u1edd c\u1ee5 th\u1ec3 nh\u01b0 TODAY () \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 d\u1ef1a tr\u00ean ng\u00e0y hi\u1ec7n t\u1ea1i.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"301\">\u0110i\u1ec1u ki\u1ec7n<\/td>\n<td width=\"301\">C\u00f4ng th\u1ee9c v\u00ed d\u1ee5<\/td>\n<\/tr>\n<tr>\n<td width=\"301\">\u0110\u1ebfm ng\u00e0y b\u1eb1ng v\u1edbi ng\u00e0y hi\u1ec7n t\u1ea1i<\/td>\n<td width=\"301\">=COUNTIF(A2:A10,TODAY())<\/td>\n<\/tr>\n<tr>\n<td width=\"301\">\u0110\u1ebfm ng\u00e0y nh\u1ecf h\u01a1n ng\u00e0y hi\u1ec7n h\u00e0nh, v\u00ed d\u1ee5 h\u00f4m nay<\/td>\n<td width=\"301\">=COUNTIF(A2:A10,\u201d&lt;\u201c&amp;TODAY())<\/td>\n<\/tr>\n<tr>\n<td width=\"301\">\u0110\u1ebfm ng\u00e0y sau ng\u00e0y hi\u1ec7n h\u00e0nh, v\u00ed d\u1ee5 sau h\u00f4m nay<\/td>\n<td width=\"301\">=COUNTIF(A2:A10,\u201d&gt;\u201d&amp;TODAY())<\/td>\n<\/tr>\n<tr>\n<td width=\"301\">\u0110\u1ebfm ng\u00e0y sau ng\u00e0y h\u00f4m nay 1 tu\u1ea7n<\/td>\n<td width=\"301\">=COUNTIF(A2:A10,\u201d=\u201d&amp;TODAY()+7)<\/td>\n<\/tr>\n<tr>\n<td width=\"301\">\u0110\u1ebfm ng\u00e0y trong m\u1ed9t kho\u1ea3ng th\u1eddi gian<\/td>\n<td width=\"301\">=COUNTIF(B2:B10, \u201c&gt;=6\/7\/2014\u201d)-COUNTIF(B2:B10, \u201c&gt;6\/1\/2014\u201d)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean d\u1eef li\u1ec7u th\u1ef1c (t\u1ea1i th\u1eddi \u0111i\u1ec3m 25 th\u00e1ng 6 n\u0103m 2014):<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5268 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-6.png\" width=\"410\" height=\"306\" title=\"excel-find-replace-highlight-6\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_COUNTIF_voi_nhieu_dieu_kien\"><\/span><strong>H\u00e0m COUNTIF v\u1edbi nhi\u1ec1u<\/strong><strong> \u0111i\u1ec1u ki\u1ec7n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. COUNTIF v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n v\u1ec1 s\u1ed1<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a h\u00e0m COUNTIF 2 \u0111i\u1ec1u ki\u1ec7n l\u00e0 \u0111\u1ebfm c\u00e1c con s\u1ed1 trong m\u1ed9t gi\u1edbi h\u1ea1n c\u1ee5 th\u1ec3, t\u1ee9c l\u00e0 nh\u1ecf h\u01a1n X nh\u01b0ng l\u1edbn h\u01a1n Y. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 5 nh\u01b0ng d\u01b0\u1edbi 15 trong kho\u1ea3ng B2: B9.<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (B2: B9, \u201c&gt; 5\u201d) \u2013 COUNTIF (B2: B9, \u201c&gt; = 15\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5269 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-7.png\" width=\"429\" height=\"327\" title=\"excel-find-replace-highlight-7\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y xem m\u1ed9t v\u00ed d\u1ee5 kh\u00e1c c\u1ee7a h\u00e0m COUNTIF s\u1ebd \u0111\u1ebfm 2 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n kh\u00e1c nhau. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch mua s\u1eafm v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau \u0111\u1ed3 u\u1ed1ng. V\u00ec v\u1eady, c\u00f4ng th\u1ee9c sau \u0111\u01b0\u1ee3c d\u00f9ng:<\/p>\n<p style=\"text-align: justify\">\u00a0<strong>= COUNTIF (B2: B13, \u201cLemonade\u201d) + COUNTIF (B2: B13, \u201c* juice\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y ch\u00fa \u00fd \u0111\u1ebfn k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n (*) trong \u0111i\u1ec1u ki\u1ec7n th\u1ee9 hai, n\u00f3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c lo\u1ea1i n\u01b0\u1edbc tr\u00e1i c\u00e2y trong danh s\u00e1ch.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5270 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-8.png\" width=\"555\" height=\"321\" title=\"excel-find-replace-highlight-8\"><\/p>\n<p style=\"text-align: justify\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u1ed9t c\u00f4ng th\u1ee9c COUNTIF v\u1edbi m\u1ed9t s\u1ed1 \u0111i\u1ec1u ki\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 v\u00ed d\u1ee5 v\u1ec1 ch\u1ee9c n\u0103ng COUNTIF \u0111\u1ec3 \u0111\u1ebfm n\u01b0\u1edbc chanh, n\u01b0\u1edbc tr\u00e1i c\u00e2y v\u00e0 kem:<\/p>\n<p style=\"text-align: justify\"><strong>= COUNTIF (B2: B13, \u201cLemonade\u201d) + COUNTIF (B2: B13, \u201c* juice\u201d) + COUNTIF (B2: B13, \u201cIce cream\u201d)<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_COUNTIF_de_tim_cac_gia_tri_lap_va_gia_tri_duy_nhat\"><\/span><strong>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng COUNTIF \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p v\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t c\u00f4ng d\u1ee5ng kh\u00e1c c\u1ee7a h\u00e0m COUNTIF l\u00e0 \u0111\u1ec3 t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p trong m\u1ed9t c\u1ed9t, gi\u1eefa hai c\u1ed9t ho\u1eb7c trong m\u1ed9t h\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. T\u00ecm v\u00e0 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p trong 1 c\u1ed9t<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n n\u00e0y = COUNTIF (B2: B10, B2)&gt; 1 s\u1ebd t\u00ecm c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u1edbi \u00f4 B2, tr\u1ea3 k\u1ebft qu\u1ea3 TRUE\/FALSE v\u1ec1 c\u1ed9t <strong>Duplicate<\/strong> trong kho\u1ea3ng B2: B10 trong khi m\u1ed9t h\u00e0m kh\u00e1c = COUNTIF (D2: D10, TRUE) s\u1ebd cho b\u1ea1n bi\u1ebft c\u00f3 bao nhi\u00eau l\u1ea7n tr\u00f9ng l\u1eb7p:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5271 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-9.png\" width=\"401\" height=\"348\" title=\"excel-find-replace-highlight-9\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Ho\u0323c excel k\u1ebf to\u00e1n b\u00e1n h\u00e0ng<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2. \u0110\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p gi\u1eefa hai c\u1ed9t<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 hai danh s\u00e1ch ri\u00eang bi\u1ec7t, v\u00ed d\u1ee5 danh s\u00e1ch t\u00ean trong c\u00e1c c\u1ed9t B v\u00e0 C, v\u00e0 b\u1ea1n mu\u1ed1n bi\u1ebft c\u00f3 bao nhi\u00eau t\u00ean xu\u1ea5t hi\u1ec7n trong c\u1ea3 hai c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p:<\/p>\n<p style=\"text-align: justify\">\u00a0<strong>= SUMPRODUCT ((COUNTIF (B2: B1000, C2: C1000)&gt; 0) * (C2: C1000 &lt;&gt; \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">\u00a0Th\u1eadm ch\u00ed ta c\u00f3 th\u1ec3 \u0111\u1ebfm bao nhi\u00eau t\u00ean duy nh\u1ea5t trong C\u1ed9t C, t\u1ee9c l\u00e0 c\u00e1c t\u00ean kh\u00f4ng xu\u1ea5t hi\u1ec7n trong C\u1ed9t B:<\/p>\n<p style=\"text-align: justify\"><strong>= SUMPRODUCT ((COUNTIF (B2: B1000, C2: C1000) = 0) * (C2: C1000 &lt;&gt; \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5272 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-10.png\" width=\"537\" height=\"246\" title=\"excel-find-replace-highlight-10\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 3. \u0110\u1ebfm gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t h\u00e0ng<\/strong><\/p>\n<p style=\"text-align: justify\">\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p ho\u1eb7c c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t h\u00e0ng n\u00e0o \u0111\u00f3 thay v\u00ec m\u1ed9t c\u1ed9t, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y. Nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 h\u1eefu \u00edch, th\u00ed d\u1ee5, \u0111\u1ec3 ph\u00e2n t\u00edch l\u1ecbch s\u1eed x\u1ed5 s\u1ed1.<\/p>\n<p style=\"text-align: justify\">\u00a0\u0110\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p trong m\u1ed9t h\u00e0ng:<\/p>\n<p style=\"text-align: justify\">\u00a0<strong>= SUMPRODUCT ((COUNTIF (A2: I2, A2: I2)&gt; 1) * (A2: I2 &lt;&gt; \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">\u00a0\u0110\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t h\u00e0ng:<\/p>\n<p style=\"text-align: justify\">\u00a0<strong>= SUMPRODUCT ((COUNTIF (A2: I2, A2: I2) = 1) * (A2: I2 &lt;&gt; \u201c\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5273 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-11.png\" width=\"600\" height=\"187\" title=\"excel-find-replace-highlight-11\"><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/so-sanh-ham-countifs-voi-sumproduct-trong-viec-dem-theo-nhieu-dieu-kien.html\">So s\u00e1nh h\u00e0m COUNTIFS v\u1edbi SUMPRODUCT trong vi\u1ec7c \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">C\u00e1ch d\u00f9ng h\u00e0m COUNTIFS v\u00e0 COUNTIF v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-countif-nang-cao-excel.html\">9 b\u00ed k\u00edp s\u1eed d\u1ee5ng COUNTIF hi\u1ec7u qu\u1ea3 trong Excel<\/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<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-318.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7790,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7789","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7789","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=7789"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7789\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7790"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}