{"id":6887,"date":"2024-12-21T16:25:35","date_gmt":"2024-12-21T16:25:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien\/"},"modified":"2024-12-21T16:25:35","modified_gmt":"2024-12-21T16:25:35","slug":"su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien\/","title":{"rendered":"S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao trong Excel \u2013 V\u00ed d\u1ee5 v\u00e0 c\u00f4ng th\u1ee9c v\u00f9ng \u0111i\u1ec1u ki\u1ec7n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y cho th\u1ea5y c\u00e1ch s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao trong Excel v\u00e0 cung c\u1ea5p v\u00e0i v\u00ed d\u1ee5 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao \u0111\u1ec3 t\u1ea1o b\u1ed9 l\u1ecdc ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, \u0111\u1ec3 t\u00ecm \u0111i\u1ec3m gi\u1ed1ng v\u00e0 kh\u00e1c gi\u1eefa hai c\u1ed9t, c\u00e1ch xu\u00e2t h\u1ed3 s\u01a1 kh\u1edbp v\u1edbi danh s\u00e1ch nh\u1ecf h\u01a1n, v\u00e0 nhi\u1ec1u h\u01a1n th\u1ebf n\u1eefa.<\/p>\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 th\u1ea3o lu\u1eadn c\u00e1c kh\u00eda c\u1ea1nh kh\u00e1c nhau c\u1ee7a B\u1ed9 l\u1ecdc N\u00e2ng cao trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 l\u1ecdc h\u00e0ng c\u00f9ng v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m l\u00f4gic AND v\u00e0 OR<\/a>. B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 c\u00f3 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n, h\u00e3y xem x\u00e9t c\u00e1c v\u00ed d\u1ee5 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n nh\u00e9 \u2013 c\u00e1c v\u00ed d\u1ee5 n\u00e0y c\u00f3 th\u1ec3 h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n \u0111\u1ea5y.<\/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-6766ebfdcde8e\" 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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#CAI_DAT_VUNG_DIEU_KIEN_DUA_TREN_CONG_THUC\" title=\"C\u00c0I \u0110\u1eb6T V\u00d9NG \u0110I\u1ec0U KI\u1ec6N D\u1ef0A TR\u00caN C\u00d4NG TH\u1ee8C\">C\u00c0I \u0110\u1eb6T V\u00d9NG \u0110I\u1ec0U KI\u1ec6N D\u1ef0A TR\u00caN C\u00d4NG TH\u1ee8C<\/a><\/li>\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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#VI_DU_VUNG_DIEU_KIEN_TRONG_BO_LOC_EXCEL_NANG_CAO\" title=\"V\u00cd D\u1ee4 V\u00d9NG \u0110I\u1ec0U KI\u1ec6N TRONG B\u1ed8 L\u1eccC EXCEL N\u00c2NG CAO\">V\u00cd D\u1ee4 V\u00d9NG \u0110I\u1ec0U KI\u1ec6N TRONG B\u1ed8 L\u1eccC EXCEL N\u00c2NG CAO<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#BO_LOC_PHAN_BIET_DANG_CHU_CHO_GIA_TRI_DANG_KY_TU\" title=\"B\u1ed8 L\u1eccC PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee CHO GI\u00c1 TR\u1eca D\u1ea0NG K\u00dd T\u1ef0\">B\u1ed8 L\u1eccC PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee CHO GI\u00c1 TR\u1eca D\u1ea0NG K\u00dd T\u1ef0<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_GIA_TRI_LON_HON_HAY_NHO_HON_GIA_TRI_TRUNG_BINH_TRONG_MOT_COT\" title=\"L\u1eccC GI\u00c1 TR\u1eca L\u1edaN H\u01a0N HAY NH\u1ece H\u01a0N GI\u00c1 TR\u1eca TRUNG B\u00ccNH TRONG M\u1ed8T C\u1ed8T\">L\u1eccC GI\u00c1 TR\u1eca L\u1edaN H\u01a0N HAY NH\u1ece H\u01a0N GI\u00c1 TR\u1eca TRUNG B\u00ccNH TRONG M\u1ed8T C\u1ed8T<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_HANG_TRONG_HAY_CO_CHUA_DU_LIEU\" title=\"L\u1eccC H\u00c0NG TR\u1ed0NG HAY C\u00d3 CH\u1ee8A D\u1eee LI\u1ec6U\">L\u1eccC H\u00c0NG TR\u1ed0NG HAY C\u00d3 CH\u1ee8A D\u1eee LI\u1ec6U<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_CAC_O_TRONG_VOI_HAM_LOGIC_OR\" title=\"L\u1eccC C\u00c1C \u00d4 TR\u1ed0NG V\u1edaI H\u00c0M L\u00d4GIC OR\">L\u1eccC C\u00c1C \u00d4 TR\u1ed0NG V\u1edaI H\u00c0M L\u00d4GIC OR<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_CAC_O_CHUA_DU_LIEU_VOI_HAM_LOGIC_OR_VA_HAM_LOGIC_AND\" title=\"L\u1eccC C\u00c1C \u00d4 CH\u1ee8A D\u1eee LI\u1ec6U V\u1edaI H\u00c0M L\u00d4GIC OR V\u00c0 H\u00c0M L\u00d4GIC AND\">L\u1eccC C\u00c1C \u00d4 CH\u1ee8A D\u1eee LI\u1ec6U V\u1edaI H\u00c0M L\u00d4GIC OR V\u00c0 H\u00c0M L\u00d4GIC AND<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#CACH_XUAT_N_HO_SO_DAUCUOI\" title=\"C\u00c1CH XU\u1ea4T N H\u1ed2 S\u01a0 \u0110\u1ea6U\/CU\u1ed0I\">C\u00c1CH XU\u1ea4T N H\u1ed2 S\u01a0 \u0110\u1ea6U\/CU\u1ed0I<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_DIEM_GIONG_VA_DIEM_KHAC_GIUA_HAI_COT\" title=\"L\u1eccC \u0110I\u1ec2M GI\u1ed0NG V\u00c0 \u0110I\u1ec2M KH\u00c1C GI\u1eeeA HAI C\u1ed8T\">L\u1eccC \u0110I\u1ec2M GI\u1ed0NG V\u00c0 \u0110I\u1ec2M KH\u00c1C GI\u1eeeA HAI C\u1ed8T<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_CAC_HANG_DUA_TREN_CAC_MUC_GIONG_NHAU_TRONG_DANH_SACH\" title=\"L\u1eccC C\u00c1C H\u00c0NG D\u1ef0A TR\u00caN C\u00c1C M\u1ee4C GI\u1ed0NG NHAU TRONG DANH S\u00c1CH\">L\u1eccC C\u00c1C H\u00c0NG D\u1ef0A TR\u00caN C\u00c1C M\u1ee4C GI\u1ed0NG NHAU TRONG DANH S\u00c1CH<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_CAC_HANG_CO_CHUA_DANH_MUC_THUOC_DANH_SACH\" title=\"L\u1eccC C\u00c1C H\u00c0NG C\u00d3 CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH\">L\u1eccC C\u00c1C H\u00c0NG C\u00d3 CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_HANG_KHONG_CHUA_DANH_MUC_THUOC_DANH_SACH\" title=\"L\u1eccC H\u00c0NG KH\u00d4NG CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH\">L\u1eccC H\u00c0NG KH\u00d4NG CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH<\/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\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#LOC_CAC_NGAY_CUOI_TUAN_VA_TRONG_TUAN\" title=\"L\u1eccC C\u00c1C NG\u00c0Y CU\u1ed0I TU\u1ea6N V\u00c0 TRONG TU\u1ea6N\">L\u1eccC C\u00c1C NG\u00c0Y CU\u1ed0I TU\u1ea6N V\u00c0 TRONG TU\u1ea6N<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#CACH_LOC_NGAY_CUOI_TUAN_TRONG_EXCEL\" title=\"C\u00c1CH L\u1eccC NG\u00c0Y CU\u1ed0I TU\u1ea6N TRONG EXCEL\">C\u00c1CH L\u1eccC NG\u00c0Y CU\u1ed0I TU\u1ea6N TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/su-dung-bo-loc-nang-cao-trong-excel-vi-du-va-cong-thuc-vung-dieu-kien.html#CACH_LOC_NGAY_TRONG_TUAN_TRONG_EXCEL\" title=\"C\u00c1CH L\u1eccC NG\u00c0Y TRONG TU\u1ea6N TRONG EXCEL\">C\u00c1CH L\u1eccC NG\u00c0Y TRONG TU\u1ea6N TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"CAI_DAT_VUNG_DIEU_KIEN_DUA_TREN_CONG_THUC\"><\/span><strong>C\u00c0I \u0110\u1eb6T V\u00d9NG \u0110I\u1ec0U KI\u1ec6N D\u1ef0A TR\u00caN C\u00d4NG TH\u1ee8C<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ec ph\u1ea7n l\u1edbn c\u00e1c v\u00ed d\u1ee5 v\u1ec1 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y s\u1ebd c\u00f3 c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau, h\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch x\u00e1c \u0111\u1ecbnh quy t\u1eafc thi\u1ebft y\u1ebfu \u0111\u1ec3 c\u00e0i \u0111\u1eb7t ch\u00fang m\u1ed9t c\u00e1ch ph\u00f9 h\u1ee3p. Tin t\u00f4i \u0111i, m\u1ea9u ki\u1ebfn th\u1ee9c nh\u1ecf nhoi n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 b\u1ea1n kh\u00f4ng c\u00f2n ph\u1ea3i \u0111au \u0111\u1ea7u khi ph\u1ea3i x\u00e1c \u0111\u1ecbnh v\u00e0 s\u1eeda l\u1ed7i cho v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p n\u1eefa \u2013 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c.<\/p>\n<p>C\u00f4ng th\u1ee9c b\u1ea1n s\u1eed d\u1ee5ng cho v\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i bi\u1ebft \u0111\u00e1nh gi\u00e1 TRUE hay FALSE.<\/p>\n<p>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n ph\u1ea3i c\u00f3 \u00edt nh\u1ea5t 2 \u00f4: \u00f4 c\u00f4ng th\u1ee9c v\u00e0 \u00f4 ti\u00eau \u0111\u1ec1.<\/p>\n<p>\u00d4 ti\u00eau \u0111\u1ec1 c\u1ee7a \u0111i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c ho\u1eb7c l\u00e0 \u0111\u1ec3 tr\u1ed1ng ho\u1eb7c l\u00e0 kh\u00e1c v\u1edbi b\u1ea5t k\u1ef3 ti\u00eau \u0111\u1ec1 n\u00e0o c\u1ee7a b\u1ea3ng (d\u1ea3i \u00f4 danh s\u00e1ch).<\/p>\n<p>\u0110\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 trong m\u1ed7i \u00f4 c\u1ee7a d\u1ea3i \u00f4 danh s\u00e1ch, h\u00e3y tham chi\u1ebfu \u00f4 tr\u00ean c\u00f9ng c\u00f9ng v\u1edbi d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i ch\u1eb3ng h\u1ea1n nh\u01b0 A1.<\/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-619.gif\" title=\"ex101_92019-nho-619\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 ch\u1ec9 cho m\u1ed9t \u00f4 hay m\u1ed9t d\u1ea3i \u00f4 x\u00e1c \u0111\u1ecbnh, h\u00e3y tahm chi\u1ebfu \u00f4 hay d\u1ea3i \u00f4 \u0111\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i ch\u1eb3ng h\u1ea1n nh\u01b0 $A$1.<\/p>\n<p>Khi tham chi\u1ebfu d\u1ea3i \u00f4 danh s\u00e1ch trong c\u00f4ng th\u1ee9c, h\u00e3y lu\u00f4n s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i.<\/p>\n<p>Khi \u00e1p d\u1ee5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e3y nh\u1eadp t\u1ea5t c\u1ea3 \u0111i\u1ec1u ki\u1ec7n tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng v\u00e0 li\u00ean k\u1ebft ch\u00fang b\u1eb1ng to\u00e1n t\u1eed AND, hay nh\u1eadp m\u1ed7i \u0111i\u1ec1u ki\u1ec7n v\u00e0o m\u1ed9t h\u00e0ng kh\u00e1c nhau v\u00e0 li\u00ean k\u1ebft ch\u00fang b\u1eb1ng to\u00e1n t\u1eed OR.<\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel nhanh<\/a> v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"VI_DU_VUNG_DIEU_KIEN_TRONG_BO_LOC_EXCEL_NANG_CAO\"><\/span><strong>V\u00cd D\u1ee4 V\u00d9NG \u0110I\u1ec0U KI\u1ec6N TRONG B\u1ed8 L\u1eccC EXCEL N\u00c2NG CAO<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd ch\u1ec9 b\u1ea1n c\u00e1ch t\u1ea1o b\u1ed9 l\u1ecdc trong Excel \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c nhi\u1ec7m v\u1ee5 ph\u1ee9c t\u1ea1p h\u01a1n \u2013 nh\u1eefng nhi\u1ec7m v\u1ee5 m\u00e0 B\u1ed9 l\u1ecdc T\u1ef1 \u0111\u1ed9ng Excel th\u00f4ng th\u01b0\u1eddng kh\u00f4ng x\u1eed l\u00fd \u0111\u01b0\u1ee3c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"BO_LOC_PHAN_BIET_DANG_CHU_CHO_GIA_TRI_DANG_KY_TU\"><\/span><strong>B\u1ed8 L\u1eccC PH\u00c2N BI\u1ec6T D\u1ea0NG CH\u1eee CHO GI\u00c1 TR\u1eca D\u1ea0NG K\u00dd T\u1ef0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Gi\u1ed1ng nh\u01b0 B\u1ed9 l\u1ecdc T\u1ef1 \u0111\u1ed9ng Excel, c\u00f4ng c\u1ee5 B\u1ed9 l\u1ecdc N\u00e2ng cao c\u0169ng kh\u00f4ng ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef, c\u00f3 ngh\u0129a l\u00e0 n\u00f3 kh\u00f4ng ph\u00e2n bi\u1ec7t k\u00fd t\u1ef1 vi\u1ebft hoa v\u00e0 vi\u1ebft th\u01b0\u1eddng khi l\u1ecdc gi\u00e1 tr\u1ecb d\u1ea1ng k\u00fd t\u1ef1. Tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm trong khi v\u1eabn ph\u00e2n bi\u1ec7t d\u1ea1ng ch\u1eef b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m EXACT <\/strong>trong \u0111i\u1ec1u ki\u1ec7n l\u1ecdc n\u00e2ng cao.<\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 l\u1ecdc h\u00e0ng ch\u1ee9a Chu\u1ed1i, kh\u00f4ng ph\u00e2n bi\u1ec7t l\u00e0 CHU\u1ed0I hay chu\u1ed1i, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o v\u00f9ng \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p>=EXACT(B5, \u201cChu\u1ed1i\u201d)<\/p>\n<p>Trong \u0111\u00f3 B l\u00e0 c\u1ed9t ch\u1ee9a t\u00ean danh m\u1ee5c, v\u00e0 h\u00e0ng 5 h\u00e0ng \u0111\u1ea7u ti\u00ean ch\u1ee9a d\u01b0 li\u1ec7u.<\/p>\n<p>Sau \u0111\u00f3, h\u00e3y s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc N\u00e2ng cao Excel b\u1eb1ng c\u00e1ch nh\u1ea5p n\u00fat Advanced tr\u00ean tab Data, r\u1ed3i \u0111\u1ecbnh c\u1ea5u h\u00ecnh cho d\u1ea3i \u00f4 Danh s\u00e1ch v\u00e0 d\u1ea3i \u00f4 \u0110i\u1ec1u ki\u1ec7n nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7110 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/500-300x114-1.png\" width=\"300\" height=\"114\" title=\"500-300x114-1\"><\/p>\n<p>L\u01b0u \u00fd. H\u00ecnh \u1ea3nh tr\u00ean c\u0169ng nh\u01b0 c\u00e1c \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh kh\u00e1c trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n nh\u1eb1m gi\u00fap m\u1ecdi th\u1ee9 tr\u1edf n\u00ean r\u00f5 r\u00e0ng h\u01a1n. Trong trang t\u00ednh c\u1ee7a b\u1ea1n, \u00f4 c\u00f4ng th\u1ee9c ch\u1ec9 n\u00ean tr\u1ea3 v\u1ec1 TRUE ho\u1eb7c FALSE, t\u00f9y v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean ch\u1ee9a d\u1eef li\u1ec7u c\u00f3 kh\u1edbp v\u1edbi \u0111i\u1ec1u ki\u1ec7n hay kh\u00f4ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7111 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/501-300x151-1.png\" width=\"300\" height=\"151\" title=\"501-300x151-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_GIA_TRI_LON_HON_HAY_NHO_HON_GIA_TRI_TRUNG_BINH_TRONG_MOT_COT\"><\/span><strong>L\u1eccC GI\u00c1 TR\u1eca L\u1edaN H\u01a0N HAY NH\u1ece H\u01a0N GI\u00c1 TR\u1eca TRUNG B\u00ccNH TRONG M\u1ed8T C\u1ed8T<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi l\u1ecdc gi\u00e1 tr\u1ecb s\u1ed1, th\u00f4ng th\u01b0\u1eddng b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n hi\u1ec3n th\u1ecb ch\u1ec9 nh\u1eefng \u00f4 l\u1edbn h\u01a1n hay nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh trong c\u1ed9t. V\u00ed d\u1ee5:<\/p>\n<p>\u0110\u1ec3 l\u1ecdc h\u00e0ng c\u00f3 t\u1ed5ng l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p>=F5&gt;AVERAGE($F$5:$F$50)<\/p>\n<p>\u0110\u1ec3 l\u1ecdc h\u00e0ng c\u00f3 t\u1ed5ng nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/p>\n<p>=F5&lt;AVERAGE($F$5:$F$50)<\/p>\n<p>Xin h\u00e3y l\u01b0u \u00fd r\u1eb1ng ch\u00fang ta s\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u1ec3 tham chi\u1ebfu \u00f4 tr\u00ean c\u00f9ng c\u00f3 d\u1eef li\u1ec7u (\u00f4 F5), v\u00e0 tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh to\u00e0n b\u1ed9 d\u1ea3i \u00f4 \u2013 d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, kh\u00f4ng t\u00ednh ti\u00eau \u0111\u1ec1 c\u1ed9t ($F$5:$F$50).<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00f4ng th\u1ee9c l\u1ecdc gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh trong th\u1ef1c t\u1ebf:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7112 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/502-300x154-1.png\" width=\"300\" height=\"154\" title=\"502-300x154-1\"><\/p>\n<p>Nh\u1eefng ai \u0111\u00e3 quen v\u1edbi B\u1ed9 l\u1ecdc S\u1ed1 trong Excel c\u00f3 th\u1ec3 t\u1ef1 h\u1ecfi, t\u1ea1i sao l\u1ea1i ph\u1ea3i s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao trong khi b\u1ed9 l\u1ecdc s\u1ed1 c\u00f3 s\u1eb5n \u0111\u00e3 c\u00f3 l\u1ef1a ch\u1ecdn Above average v\u00e0 Below average? \u0110\u00fang r\u1ed3i \u0111\u1ea5y, nh\u01b0ng b\u1ed9 l\u1ecdc c\u00f3 s\u1eb5n trong Excel kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng v\u1edbi h\u00e0m l\u00f4gic OR!<\/p>\n<p>V\u00ec th\u1ebf, h\u00e3y t\u1eadn d\u1ee5ng v\u00ed d\u1ee5 n\u00e0y, h\u00e3y l\u1ecdc h\u00e0ng c\u00f3 t\u1ed5ng (c\u1ed9t F) HAY Doanh thu Th\u00e1ng ch\u00edn (c\u1ed9t E) l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh. V\u1ec1 vi\u1ec7c n\u00e0y, h\u00e3y thi\u1ebft l\u1eadp v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 h\u00e0m l\u00f4gic OR b\u1eb1ng c\u00e1ch nh\u1eadp m\u1ed7i \u0111i\u1ec1u ki\u1ec7n v\u00e0o m\u1ed7i h\u00e0ng kh\u00e1c nhau. K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t danh s\u00e1ch l\u1edbn h\u01a1n gi\u00e1 tr\u1ecb trung b\u00ecnh n\u1eb1m \u1edf c\u1ed9t F hay c\u1ed9t E:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7113 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/503-300x185-1.png\" width=\"300\" height=\"185\" title=\"503-300x185-1\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">Excel k\u1ebf to\u00e1n<\/a> 1 th\u1ea7y 1 tr\u00f2<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"LOC_HANG_TRONG_HAY_CO_CHUA_DU_LIEU\"><\/span>L\u1eccC H\u00c0NG TR\u1ed0NG HAY C\u00d3 CH\u1ee8A D\u1eee LI\u1ec6U<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 l\u1ebd m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 bi\u1ebft, B\u1ed9 l\u1ecdc Excel c\u00f3 m\u1ed9t t\u00ednh n\u0103ng s\u1eb5n c\u00f3 \u0111\u1ec3 l\u1ecdc c\u00e1c \u00f4 tr\u1ed1ng. B\u1eb1ng c\u00e1ch ch\u1ecdn hay b\u1ecf ch\u1ecdn (Tr\u1ed1ng) c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u trong b\u1ea3ng ch\u1ecdn B\u1ed9 l\u1ecdc T\u1ef1 \u0111\u1ed9ng c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb ch\u1ec9 nh\u1eefng h\u00e0ng c\u00f3 c\u00e1c \u00f4 tr\u1ed1ng hay ch\u1ee9a d\u1eef li\u1ec7u trong m\u1ed9t hay nhi\u1ec1u c\u1ed9t. V\u1ea5n \u0111\u1ec1 \u1edf \u0111\u00e2y \u0111\u00f3 l\u00e0 b\u1ed9 l\u1ecdc \u00f4 tr\u1ed1ng c\u00f3 s\u1eb5n trong Excel ch\u1ec9 ch\u1ea1y khi \u0111\u01b0\u1ee3c d\u00f9ng v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-logic-trong-excel-xor-va-not-cong-thuc-cach-dung-va-vi-du.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m l\u00f4gic AND<\/a>.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n l\u1ecdc c\u00e1c \u00f4 tr\u1ed1ng hay \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u v\u1edbi h\u00e0m l\u00f4gic OR, hay s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n cho c\u00e1c \u00f4 tr\u1ed1ng hay c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u00f9ng v\u1edbi v\u00e0i \u0111i\u1ec1u ki\u1ec7n kh\u00e1c n\u1eefa, th\u00ec h\u00e3y c\u00e0i \u0111\u1eb7t v\u00f9ng \u0111i\u1ec1u ki\u1ec7n b\u1ed9 l\u1ecdc n\u00e2ng cao c\u00f9ng v\u1edbi m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c sau:<\/p>\n<p>L\u1ecdc c\u00e1c \u00f4 tr\u1ed1ng:<\/p>\n<p><i>\u00f4_tr\u00ean_c\u00f9ng<\/i>=\u201d\u201d<\/p>\n<p>L\u1ecdc c\u00e1c \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u:<\/p>\n<p><i>\u00f4_tr\u00ean<\/i>_c\u00f9ng&lt;&gt;\u201d\u201d<\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_CAC_O_TRONG_VOI_HAM_LOGIC_OR\"><\/span><strong>L\u1eccC C\u00c1C \u00d4 TR\u1ed0NG V\u1edaI H\u00c0M L\u00d4GIC OR<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u1ecdc c\u00e1c h\u00e0ng c\u00f3 \u00f4 tr\u1ed1ng ho\u1eb7c \u1edf c\u1ed9t A hay B, hay \u1edf c\u1ea3 hai c\u1ed9t, h\u00e3y l\u1eadp c\u1ea5u h\u00ecnh v\u00f9ng \u0111i\u1ec1u ki\u1ec7n B\u1ed9 l\u1ecdc N\u00e2ng cao theo c\u00e1ch n\u00e0y:<\/p>\n<ul>\n<li><code>=A6=\"\"<\/code><\/li>\n<li><code>=B6=\"\"<\/code><\/li>\n<\/ul>\n<p>Trong \u0111\u00f3, 6 l\u00e0 h\u00e0ng tr\u00ean c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7114 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/504.png\" width=\"254\" height=\"260\" title=\"504\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_CAC_O_CHUA_DU_LIEU_VOI_HAM_LOGIC_OR_VA_HAM_LOGIC_AND\"><\/span><strong>L\u1eccC C\u00c1C \u00d4 CH\u1ee8A D\u1eee LI\u1ec6U V\u1edaI H\u00c0M L\u00d4GIC OR V\u00c0 H\u00c0M L\u00d4GIC AND<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 hi\u1ec3u th\u00eam c\u00e1ch B\u1ed9 l\u1ecdc N\u00e2ng cao trong Excel ho\u1ea1t \u0111\u1ed9ng khi c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n, h\u00e3y l\u1ecdc c\u00e1c h\u00e0ng trong b\u1ea3ng m\u1eabu theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<p>Ho\u1eb7c l\u00e0 V\u00f9ng mi\u1ec1n (c\u1ed9t A) ho\u1eb7c l\u00e0 Danh m\u1ee5c (c\u1ed9t B) c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u, v\u00e0<\/p>\n<p>T\u1ed5ng doanh thu (c\u1ed9t C) ph\u1ea3i l\u1edbn h\u01a1n 900.<\/p>\n<p>N\u00f3i c\u00e1ch kh\u00e1c, ch\u00fang ta mu\u1ed1n hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng \u0111\u00e1p \u1ee9ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<p>(T\u1ed5ng doanh thu&gt;900 AND V\u00f9ng mi\u1ec1n=c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u) OR (T\u1ed5ng doanh thu&gt;900 AND Danh m\u1ee5c=c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u)<\/p>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u1ee7a B\u1ed9 l\u1ecdc N\u00e2ng cao Excel, \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m l\u00f4gic AND n\u00ean \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o c\u00f9ng m\u1ed9t h\u00e0ng, v\u00e0 \u0111i\u1ec1u ki\u1ec7n k\u1ebft h\u1ee3p v\u1edbi h\u00e0m l\u00f4gic OR \u2013 \u1edf c\u00e1c h\u00e0ng kh\u00e1c nhau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7115 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/505.png\" width=\"255\" height=\"282\" title=\"505\"><\/p>\n<p>B\u1edfi v\u00ec m\u1ed9t \u0111i\u1ec1u ki\u1ec7n trong v\u00ed d\u1ee5 n\u00e0y \u0111\u01b0\u1ee3c di\u1ec5n t\u1ea3 b\u1eb1ng c\u00f4ng th\u1ee9c (c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u) v\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u00f2n l\u1ea1i c\u00f3 ch\u1ee9a to\u00e1n t\u1eed so s\u00e1nh (T\u1ed5ng doanh thu&gt;900), h\u00e3y \u0111\u1ec3 t\u00f4i nh\u1eafc b\u1ea1n m\u1ed9t v\u00e0i \u0111i\u1ec1u:<\/p>\n<p>\u0110i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c l\u1eadp v\u1edbi to\u00e1n t\u1eed so s\u00e1nh n\u00ean c\u00f3 ti\u00eau \u0111\u1ec1 gi\u1ed1ng 100% ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng, gi\u1ed1ng nh\u01b0 \u0111i\u1ec1u ki\u1ec7n T\u1ed5ng doanh thu trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean.<\/p>\n<p>\u0110i\u1ec1u ki\u1ec7n d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c n\u00ean c\u00f3 ho\u1eb7c l\u00e0 \u00f4 ti\u00eau \u0111\u1ec1 tr\u1ed1ng ho\u1eb7c l\u00e0 ti\u00eau \u0111\u1ec1 kh\u00f4ng gi\u1ed1ng v\u1edbi b\u1ea5t k\u1ef3 ti\u00eau \u0111\u1ec1 n\u00e0o c\u1ee7a b\u1ea3ng, gi\u1ed1ng nh\u01b0 \u0111i\u1ec1u ki\u1ec7n C\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CACH_XUAT_N_HO_SO_DAUCUOI\"><\/span>C\u00c1CH XU\u1ea4T N H\u1ed2 S\u01a0 \u0110\u1ea6U\/CU\u1ed0I<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f3 l\u1ebd b\u1ea1n \u0111\u00e3 bi\u1ebft, B\u1ed9 l\u1ecdc S\u1ed1 c\u00f3 s\u1eb5n trong Excel c\u00f3 t\u00ednh n\u0103ng hi\u1ec3n th\u1ecb 10 danh m\u1ee5c \u0111\u1ea7u hay cu\u1ed1i. Nh\u01b0ng n\u1ebfu b\u1ea1n c\u1ea7n l\u1ecdc 3 gi\u00e1 tr\u1ecb \u0111\u1ea7u hay 5 gi\u00e1 tr\u1ecb cu\u1ed1i th\u00ec sao? Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, B\u1ed9 l\u1ecdc N\u00e2ng cao trong Excel s\u1ebd c\u00f3 s\u1eb5n c\u00e1c c\u00f4ng th\u1ee9c d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p>L\u1ecdc N danh m\u1ee5c \u0111\u1ea7u:<\/p>\n<p><i>\u00f4_tr\u00ean_c\u00f9ng<\/i>&gt;=LARGE(<i>d\u1ea3i \u00f4<\/i>, N)<\/p>\n<p>L\u1ecdc N danh m\u1ee5c cu\u1ed1i:<\/p>\n<p><i>\u00f4_tr\u00ean_c\u00f9ng<\/i>&lt;=SMALL(<i>d\u1ea3i \u00f4<\/i>, N)<\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 l\u1ecdc 3 t\u1ed5ng doanh thu \u0111\u1ea7u, h\u00e3y t\u1ea1o v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f9ng v\u1edbi c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p>=F5&gt;=LARGE($F$5:$F$50,3)<\/p>\n<p>\u0110\u1ec3 xu\u1ea5t 3 t\u1ed5ng doanh thu cu\u1ed1i, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p>=F5&gt;=SMALL($F$5:$F$50,3)<\/p>\n<p>Trong \u0111\u00f3, F5 l\u00e0 \u00f4 tr\u00ean c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong c\u1ed9t T\u1ed5ng doanh thu (kh\u00f4ng t\u00ednh ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t).<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00f4ng th\u1ee9c l\u1ecdc 3 t\u1ed5ng doanh thu \u0111\u1ea7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7116 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/506-300x122-1.png\" width=\"300\" height=\"122\" title=\"506-300x122-1\"><\/p>\n<p><strong>L\u01b0u \u00fd.<\/strong> N\u1ebfu d\u1ea3i danh s\u00e1ch ch\u1ee9a v\u00e0i h\u00e0ng c\u00f3 c\u00f9ng gi\u00e1 tr\u1ecb thu\u1ed9c N danh s\u00e1ch \u0111\u1ea7u\/cu\u1ed1i, t\u1ea5t c\u1ea3 h\u00e0ng nh\u01b0 th\u1ebf \u0111\u1ec1u s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7117 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/507-300x127-1.png\" width=\"300\" height=\"127\" title=\"507-300x127-1\"><\/p>\n<p><strong>T\u00ecm hi\u1ec3u ngay<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_DIEM_GIONG_VA_DIEM_KHAC_GIUA_HAI_COT\"><\/span>L\u1eccC \u0110I\u1ec2M GI\u1ed0NG V\u00c0 \u0110I\u1ec2M KH\u00c1C GI\u1eeeA HAI C\u1ed8T<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t trong nh\u1eefng b\u00e0i vi\u1ebft tr\u01b0\u1edbc c\u1ee7a ch\u00fang ta \u0111\u00e3 gi\u1ea3i th\u00edch nh\u1eefng c\u00e1ch kh\u00e1c nhau nh\u1eb1m so s\u00e1nh hai c\u1ed9t trong Excel r\u1ed3i t\u00ecm \u0111i\u1ec3m gi\u1ed1ng v\u00e0 \u0111i\u1ec3m kh\u00e1c gi\u1eefa ch\u00fang. B\u00ean c\u1ea1nh c\u00e1c c\u00f4ng th\u1ee9c Excel, quy lu\u1eadt \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00f4ng c\u1ee5 Duplicate Remover \u0111\u00e3 \u0111\u01b0\u1ee3c n\u00f3i \u0111\u1ebfn trong b\u00e0i h\u01b0\u1edbng d\u1eabn tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc N\u00e2ng cao Excel \u0111\u1ec3 xu\u1ea5t c\u00e1c h\u00e0ng c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb gi\u1ed1ng hay kh\u00e1c nhau trong hai hay nhi\u1ec1u c\u1ed9t. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y nh\u1eadp m\u1ed9t trong nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y v\u00e0o v\u00f9ng \u0111i\u1ec1u ki\u1ec7n:<\/p>\n<p>L\u1ecdc \u0111i\u1ec3m gi\u1ed1ng (s\u1ef1 tr\u00f9ng l\u1eb7p) gi\u1eefa hai c\u1ed9t:<\/p>\n<p>=B5=C5<\/p>\n<p>L\u1ecdc \u0111i\u1ec3m kh\u00e1c (gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t) gi\u1eefa hai c\u1ed9t:<\/p>\n<p>=B5&lt;&gt;C5<\/p>\n<p>Trong \u0111\u00f3, B5 v\u00e0 C5 l\u00e0 c\u00e1c \u00f4 tr\u00ean c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u thu\u1ed9c hai c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7118 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/508-300x118-1.png\" width=\"300\" height=\"118\" title=\"508-300x118-1\"><\/p>\n<p><strong>L\u01b0u \u00fd.<\/strong> C\u00f4ng c\u1ee5 B\u1ed9 l\u1ecdc N\u00e2ng cao ch\u1ec9 c\u00f3 th\u1ec3 t\u00ecm \u0111i\u1ec3m gi\u1ed1ng v\u00e0 \u0111i\u1ec3m kh\u00e1c tr\u00ean c\u00f9ng m\u1ed9t h\u00e0ng. \u0110\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb thu\u1ed9c c\u1ed9t A nh\u01b0ng kh\u00f4ng xu\u1ea5t hi\u1ec7n trong c\u1ed9t B, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c n\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_CAC_HANG_DUA_TREN_CAC_MUC_GIONG_NHAU_TRONG_DANH_SACH\"><\/span><strong>L\u1eccC C\u00c1C H\u00c0NG D\u1ef0A TR\u00caN C\u00c1C M\u1ee4C GI\u1ed0NG NHAU TRONG DANH S\u00c1CH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng l\u1edbn c\u00f3 h\u00e0ng tr\u0103m hay h\u00e0ng ng\u00e0n h\u00e0ng, v\u00e0 b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch ng\u1eafn h\u01a1n ch\u1ec9 ch\u1ee9a c\u00e1c danh m\u1ee5c c\u1ea7n d\u00f9ng t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m. C\u00e2u h\u1ecfi \u0111\u1eb7t ra l\u00e0 \u2013 l\u00e0m th\u1ebf n\u00e0o b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 danh m\u1ee5c trong b\u1ea3ng \u2013 c\u00e1c danh m\u1ee5c xu\u1ea5t hi\u1ec7n hay kh\u00f4ng xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch ng\u1eafn \u0111\u00f3?<\/p>\n<h4><span class=\"ez-toc-section\" id=\"LOC_CAC_HANG_CO_CHUA_DANH_MUC_THUOC_DANH_SACH\"><\/span><strong>L\u1eccC C\u00c1C H\u00c0NG C\u00d3 CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 danh m\u1ee5c trong b\u1ea3ng ngu\u1ed3n \u2013 c\u00e1c danh m\u1ee5c n\u00e0y c\u0169ng n\u1eb1m trong danh s\u00e1ch, h\u00e3y s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00f4ng th\u1ee9c COUNTIF<\/a> sau \u0111\u00e2y:<\/p>\n<p><strong>COUNTIF(<em>list_to_match<\/em>, <em>top_data_cell)<\/em><\/strong><\/p>\n<p>Gi\u1ea3 s\u1eed danh s\u00e1ch ng\u1eafn h\u01a1n n\u1eb1m trong d\u1ea3i \u00f4 D2:D7, v\u00e0 c\u00e1c danh m\u1ee5c trong b\u1ea3ng c\u1ea7n \u0111\u01b0\u1ee3c so s\u00e1nh v\u1edbi danh s\u00e1ch \u0111\u00f3 th\u00ec n\u1eb1m trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 10, c\u00f4ng th\u1ee9c c\u00f3 d\u1ea1ng sau \u0111\u00e2y (h\u00e3y ch\u00fa \u00fd c\u00e1ch d\u00f9ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i):<\/p>\n<p><strong>=COUNTIF($D$2:$D$7,B10)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7119 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/509-300x224-1.png\" width=\"300\" height=\"224\" title=\"509-300x224-1\"><\/p>\n<p>T\u1ea5t nhi\u00ean b\u1ea1n kh\u00f4ng b\u1ecb b\u00f3 bu\u1ed9c trong vi\u1ec7c ch\u1ec9 l\u1ecdc b\u1ea3ng v\u1edbi m\u1ed9t \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 l\u1ecdc c\u00e1c h\u00e0ng n\u1eb1m trong danh s\u00e1ch, nh\u01b0ng ch\u1ec9 c\u00e1c v\u00f9ng mi\u1ec1n B\u1eafc th\u00f4i, h\u00e3y nh\u1eadp hai \u0111i\u1ec1u ki\u1ec7n n\u00e0y v\u00e0o c\u00f9ng m\u1ed9t h\u00e0ng \u0111\u1ec3 ch\u00fang c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng khi d\u00f9ng h\u00e0m l\u00f4gic AND:<\/p>\n<ul>\n<li>V\u00f9ng mi\u1ec1n: <code>=\"=Mi\u1ec1n B\u1eafc\" <\/code><\/li>\n<li>Danh m\u1ee5c gi\u1ed1ng nhau: <code>=COUNTIF($D$2:$D$7,B10)<\/code><\/li>\n<\/ul>\n<p>Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, ch\u1ec9 c\u00f3 hai h\u1ed3 s\u01a1 trong b\u1ea3ng kh\u1edbp v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n m\u00e0 th\u00f4i:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7120 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/510-300x139-1.png\" width=\"300\" height=\"139\" title=\"510-300x139-1\"><\/p>\n<p><strong>L\u01b0u \u00fd.<\/strong> Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1eed d\u1ee5ng \u0111i\u1ec3m gi\u1ed1ng tuy\u1ec7t \u0111\u1ed1i cho gi\u00e1 tr\u1ecb k\u00fd t\u1ef1: =\u201d=Mi\u1ec1n B\u1eafc\u201d \u0111\u1ec3 t\u00ecm nh\u1eefng \u00f4 gi\u1ed1ng h\u1ec7t v\u1edbi chu\u1ed7i k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh. N\u1ebfu b\u1ea1n ch\u1ec9 nh\u1eadp \u0111i\u1ec1u ki\u1ec7n V\u00f9ng mi\u1ec1n nh\u01b0 th\u1ebf n\u00e0y Mi\u1ec1n B\u1eafc (kh\u00f4ng c\u00f3 d\u1ea5u b\u1eb1ng v\u00e0 d\u1ea5u ngo\u1eb7c k\u00e9p), th\u00ec Microsoft Excel s\u1ebd t\u00ecm t\u1ea5t c\u1ea3 danh m\u1ee5c b\u1eaft \u0111\u1ea7u v\u1edbi chu\u1ed7i k\u00fd t\u1ef1 x\u00e1c \u0111\u1ecbnh, v\u00ed d\u1ee5 Mi\u1ec1n B\u1eafc Trung B\u1ed9.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"LOC_HANG_KHONG_CHUA_DANH_MUC_THUOC_DANH_SACH\"><\/span>L\u1eccC H\u00c0NG KH\u00d4NG CH\u1ee8A DANH M\u1ee4C THU\u1ed8C DANH S\u00c1CH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 danh m\u1ee5c trong b\u1ea3ng kh\u00f4ng thu\u1ed9c danh s\u00e1ch nh\u1ecf h\u01a1n, h\u00e3y xem xem k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c COUNTIF c\u00f3 b\u1eb1ng 0 kh\u00f4ng:<\/p>\n<p><strong>COUNTIF(<em>list_to_match<\/em>, <em>top_data_cell)<\/em>=0<\/strong><\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 l\u1ecdc danh m\u1ee5c v\u00f9ng mi\u1ec1n B\u1eafc trong b\u1ea3ng \u2013 danh m\u1ee5c kh\u00f4ng xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch, h\u00e3y s\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n sau:<\/p>\n<ul>\n<li>V\u00f9ng mi\u1ec1n: <code>=\"=Mi\u1ec1n B\u1eafc\"<\/code><\/li>\n<li>Danh m\u1ee5c kh\u00f4ng tr\u00f9ng kh\u1edbp: <code>=COUNTIF($D$2:$D$7,B10)=0<\/code><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7121 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/511-300x177-1.png\" width=\"300\" height=\"177\" title=\"511-300x177-1\"><\/p>\n<p><strong>L\u01b0u \u00fd.<\/strong><\/p>\n<ul>\n<li>N\u1ebfu danh s\u00e1ch c\u1ea7n so s\u00e1nh n\u1eb1m \u1edf trang t\u00ednh kh\u00e1c, h\u00e3y ch\u1eafc r\u1eb1ng b\u1ea1n th\u00eam t\u00ean trang t\u00ednh v\u00e0o c\u00f4ng th\u1ee9c, v\u00ed d\u1ee5\u00a0<code>=COUNTIF(Sheet2!$A$2:$A$7,B10)<\/code>.<\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n xu\u1ea5t k\u1ebft qu\u1ea3 sang m\u1ed9t trang t\u00ednh kh\u00e1c, h\u00e3y s\u1eed d\u1ee5ng B\u1ed9 l\u1ecdc N\u00e2ng cao \u1edf trang t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"LOC_CAC_NGAY_CUOI_TUAN_VA_TRONG_TUAN\"><\/span>L\u1eccC C\u00c1C NG\u00c0Y CU\u1ed0I TU\u1ea6N V\u00c0 TRONG TU\u1ea6N<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u00e3y gi\u1edd, v\u00ed d\u1ee5 v\u1ec1 v\u00f9ng \u0111i\u1ec1u ki\u1ec7n B\u1ed9 l\u1ecdc N\u00e2ng cao ph\u1ea7n l\u1edbn x\u1eed l\u00fd gi\u00e1 tr\u1ecb s\u1ed1 v\u00e0 gi\u00e1 tr\u1ecb k\u00fd t\u1ef1. B\u00e2y gi\u1edd, l\u00e0 l\u00fac cho b\u1ea1n th\u1ea5y c\u00e1ch x\u1eed l\u00fd ng\u00e0y th\u00e1ng n\u0103m.<\/p>\n<p>B\u1ed9 l\u1ecdc Ng\u00e0y Th\u00e1ng N\u0103m c\u00f3 s\u1eb5n trong Excel cung c\u1ea5p nhi\u1ec1u l\u1ef1a ch\u1ecdn li\u00ean quan \u0111\u1ebfn nhi\u1ec1u t\u00ecnh hu\u1ed1ng. Nhi\u1ec1u, nh\u01b0ng kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3! V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 danh s\u00e1ch ng\u00e0y th\u00e1ng n\u0103m v\u00e0 \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u ph\u1ea3i l\u1ecdc c\u00e1c ng\u00e0y cu\u1ed1i tu\u1ea7n v\u00e0 trong tu\u1ea7n, b\u1ea1n s\u1ebd l\u00e0m th\u1ebf n\u00e0o?<\/p>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, Microsoft Excel cung c\u1ea5p <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m WEEKDAY<\/a> \u0111\u1eb7c bi\u1ec7t \u2013 h\u00e0m n\u00e0y tr\u1ea3 v\u1ec1 ng\u00e0y trong tu\u1ea7n d\u1ef1a tr\u00ean ng\u00e0y th\u00e1ng n\u0103m cho s\u1eb5n. V\u00e0 \u0111\u00e2y l\u00e0 h\u00e0m m\u00e0 ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n B\u1ed9 l\u1ecdc N\u00e2ng cao Excel.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"CACH_LOC_NGAY_CUOI_TUAN_TRONG_EXCEL\"><\/span>C\u00c1CH L\u1eccC NG\u00c0Y CU\u1ed0I TU\u1ea6N TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e3y nh\u1edb r\u1eb1ng, trong thu\u1eadt ng\u1eef WEEKDAY, 1 l\u00e0 Ch\u1ee7 nh\u1eadt v\u00e0 7 l\u00e0 Th\u1ee9 b\u1ea3y, c\u00f4ng th\u1ee9c l\u1ecdc ng\u00e0y cu\u1ed1i tu\u1ea7n c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p><strong>OR(WEEKDAY(<i>ng\u00e0y th\u00e1ng n\u0103m<\/i>)=7, WEEKDAY(<i>ng\u00e0y th\u00e1ng n\u0103m<\/i>)=1)<\/strong><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta l\u1ecdc ng\u00e0y th\u00e1ng n\u0103m trong c\u1ed9t B b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 5, v\u00ec th\u1ebf c\u00f4ng th\u1ee9c l\u1ecdc ng\u00e0y cu\u1ed1i tu\u1ea7n c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p>=OR(WEEKDAY(B5)=7, WEEKDAY(B5)=1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7122 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/512-300x286-1.png\" width=\"300\" height=\"286\" title=\"512-300x286-1\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"CACH_LOC_NGAY_TRONG_TUAN_TRONG_EXCEL\"><\/span>C\u00c1CH L\u1eccC NG\u00c0Y TRONG TU\u1ea6N TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 l\u1ecdc c\u00e1c ng\u00e0y trong tu\u1ea7n, h\u00e3y thay \u0111\u1ed5i c\u00f4ng th\u1ee9c tr\u00ean \u0111\u1ec5 n\u00f3 kh\u00f4ng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 1 (Ch\u1ee7 nh\u1eadt) v\u00e0 7 (Th\u1ee9 b\u1ea3y):<\/p>\n<p>AND(WEEKDAY(<i>ng\u00e0y th\u00e1ng n\u0103m<\/i>)&lt;&gt;7, WEEKDAY(<i>ng\u00e0y th\u00e1ng n\u0103m<\/i>)&lt;&gt;1)<\/p>\n<p>\u0110\u1ed1i v\u1edbi b\u1ea3ng m\u1eabu c\u1ee7a ch\u00fang ta, c\u00f4ng th\u1ee9c sau c\u00f3 \u00edch r\u1ea5t nhi\u1ec1u:<\/p>\n<p>=AND(WEEKDAY(B5)&lt;&gt;7, WEEKDAY(B5)&lt;&gt;1)<\/p>\n<p>B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam m\u1ed9t \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u1ecdc c\u00e1c \u00f4 tr\u1ed1ng: =B5&lt;&gt;\u201d\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-7123 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/513-300x160-1.png\" width=\"300\" height=\"160\" title=\"513-300x160-1\"><\/p>\n<p>\u0110\u1ec3 l\u1ecdc ng\u00e0y th\u00e1ng n\u0103m trong trang t\u00ednh c\u1ee7a b\u1ea1n theo c\u00e1ch kh\u00e1c, h\u00e3y t\u00ecm h\u00e0m Date li\u00ean quan v\u00e0 c\u1ee9 t\u1ef1 nhi\u00ean d\u00f9ng n\u00f3 trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n B\u1ed9 l\u1ecdc N\u00e2ng cao Excel.<\/p>\n<p>\u00c0 th\u00ec, \u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n d\u00f9ng B\u1ed9 l\u1ecdc N\u00e2ng cao Excel cho c\u00e1c \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p. T\u1ea5t nhi\u00ean, c\u00e1c l\u1ef1a ch\u1ecdn c\u1ee7a b\u1ea1n kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi nh\u1eefng v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c th\u1ea3o lu\u1eadn trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, m\u1ee5c \u0111\u00edch c\u1ee7a ch\u00fang t\u00f4i l\u00e0 cung c\u1ea5p cho b\u1ea1n v\u00e0i \u00fd t\u01b0\u1edfng c\u00f3 th\u1ec3 truy\u1ec1n c\u1ea3m h\u1ee9ng \u0111\u1ec3 b\u1ea1n \u0111i \u0111\u00fang h\u01b0\u1edbng. H\u00e3y nh\u1edb r\u1eb1ng con \u0111\u01b0\u1eddng tr\u1edf th\u00e0nh chuy\u00ean gia lu\u00f4n \u0111i \u0111\u00f4i th\u1ef1c h\u00e0nh. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n v\u00e0o tu\u1ea7n t\u1edbi!<\/p>\n<p>Hi\u1ec7n t\u1ea1i,\u00a0Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-619.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6888,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6887","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\/6887","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=6887"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6887\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6888"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}