{"id":644,"date":"2024-12-02T02:37:15","date_gmt":"2024-12-02T02:37:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel\/"},"modified":"2024-12-02T02:37:15","modified_gmt":"2024-12-02T02:37:15","slug":"thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel\/","title":{"rendered":"Th\u1ee7 thu\u1eadt ki\u1ec3m tra sai l\u1ec7ch d\u1eef li\u1ec7u trong b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn c\u1ee7a Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch so s\u00e1nh 2 chu\u1ed7i ch\u1eef trong Excel trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, t\u00ecm ki\u1ebfm t\u1eeb gi\u1ed1ng nhau. B\u1ea1n s\u1ebd h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec3 so s\u00e1nh 2 \u00f4 th\u00f4ng qua gi\u00e1 tr\u1ecb c\u1ee7a \u00f4, \u0111\u1ed9 d\u00e0i c\u1ee7a \u0111o\u1ea1n v\u0103n b\u1ea3n, ho\u1eb7c s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a 1 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t, c\u0169ng nh\u01b0 so s\u00e1nh nhi\u1ec1u \u00f4.<\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng Excel \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, \u0111\u1ed9 ch\u00ednh x\u00e1c l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng nh\u1ea5t. Th\u00f4ng tin sai l\u1ec7ch c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn ch\u1eadm deadlines, ph\u00e1n \u0111o\u00e1n nh\u1ea7m xu h\u01b0\u1edbng, quy\u1ebft \u0111\u1ecbnh sai l\u1ea7m, th\u00e2m h\u1ee5t doanh thu.<\/p>\n<p style=\"text-align: justify\">C\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a Excel lu\u00f4n lu\u00f4n \u0111\u00fang, nh\u01b0ng k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 sai do trong h\u1ec7 th\u1ed1ng c\u00f3 d\u1eef li\u1ec7u l\u1ed7i. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, bi\u1ec7n ph\u00e1p duy nh\u1ea5t l\u00e0 ki\u1ec3m tra d\u1eef li\u1ec7u v\u00e0 \u0111\u1ed9 ch\u00ednh x\u00e1c. N\u1ebfu ch\u1ec9 so s\u00e1nh 2 \u00f4 th\u00ec l\u00e0m theo ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng s\u1ebd kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec, nh\u01b0ng ch\u1ec9 ra s\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0ng tr\u0103m, h\u00e0ng ng\u00e0n chu\u1ed7i ch\u1eef th\u00ec ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 kh\u00f4ng th\u1ec3.<\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft s\u1ebd gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng ho\u00e1 c\u00f4ng vi\u1ec7c so s\u00e1nh c\u00e1c \u00f4 ch\u00e1n ng\u1eaft v\u00e0 d\u1ec5 m\u1eafc l\u1ed7i n\u00e0y, \u0111\u1ed3ng th\u1eddi h\u01b0\u1edbng d\u1eabn c\u00f4ng th\u1ee9c h\u1ee3p l\u00fd nh\u1ea5t trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3.<\/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-674d1d5a28607\" 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\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#SO_SANH_2_O_TRONG_EXCEL\" title=\"SO S\u00c1NH 2 \u00d4 TRONG EXCEL:\">SO S\u00c1NH 2 \u00d4 TRONG EXCEL:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_2_O_KHONG_PHAN_BIET_CHU_VIET_HOA_VIET_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG<\/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\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_2_O_PHAN_BIET_CHU_VIET_HOA_VIET_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#SO_SANH_NHIEU_O_TRONG_EXCEL\" title=\"SO S\u00c1NH NHI\u1ec0U \u00d4 TRONG EXCEL:\">SO S\u00c1NH NHI\u1ec0U \u00d4 TRONG EXCEL:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_NHIEU_O_KHONG_PHAN_BIET_CHU_HOA_CHU_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/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\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_NHIEU_O_PHAN_BIET_CHU_HOA_CHU_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#SO_SANH_DAY_O_VOI_1_O_MAU\" title=\"SO S\u00c1NH D\u00c3Y \u00d4 V\u1edaI 1 \u00d4 M\u1eaaU\u00a0 \">SO S\u00c1NH D\u00c3Y \u00d4 V\u1edaI 1 \u00d4 M\u1eaaU\u00a0 <\/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-8\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_CAC_O_VOI_DOAN_VAN_BAN_MAU_KHONG_PHAN_BIET_CHU_HOA_CHU_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#CONG_THUC_SO_SANH_CAC_O_VOI_DOAN_VAN_BAN_MAU_PHAN_BIET_CHU_HOA_CHU_THUONG\" title=\"C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG\">C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#SO_SANH_2_O_THEO_DO_DAI_CHUOI\" title=\"SO S\u00c1NH 2 \u00d4 THEO \u0110\u1ed8 D\u00c0I CHU\u1ed6I:\">SO S\u00c1NH 2 \u00d4 THEO \u0110\u1ed8 D\u00c0I CHU\u1ed6I:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-kiem-tra-sai-lech-du-lieu-trong-bang-du-lieu-lon-cua-excel.html#SO_SANH_2_O_BANG_SO_LAN_XUAT_HIEN_CUA_1_KY_TU_CU_THE\" title=\"SO S\u00c1NH 2 \u00d4 B\u1eb0NG S\u1ed0 L\u1ea6N XU\u1ea4T HI\u1ec6N C\u1ee6A 1 K\u00dd T\u1ef0 C\u1ee4 TH\u1ec2:\">SO S\u00c1NH 2 \u00d4 B\u1eb0NG S\u1ed0 L\u1ea6N XU\u1ea4T HI\u1ec6N C\u1ee6A 1 K\u00dd T\u1ef0 C\u1ee4 TH\u1ec2:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SO_SANH_2_O_TRONG_EXCEL\"><\/span><strong>SO S\u00c1NH 2 \u00d4 TRONG EXCEL:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f3 2 c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 so s\u00e1nh chu\u1ed7i trong Excel tu\u1ef3 v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm kh\u00f4ng ph\u00e2n bi\u1ec7t hay ph\u00e2n bi\u1ec7t ch\u1eef vi\u1ebft hoa, vi\u1ebft th\u01b0\u1eddng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_2_O_KHONG_PHAN_BIET_CHU_VIET_HOA_VIET_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 so s\u00e1nh 2 \u00f4 trong Excel kh\u00f4ng quan t\u00e2m \u0111\u1ebfn ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=A1=B1 \u00a0\u00a0\u00a0<\/strong><\/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-34.gif\" title=\"ex101_92019-nho-34\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">A1, B1 l\u00e0 \u00f4 m\u00e0 b\u1ea1n \u0111ang so s\u00e1nh. K\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c l\u00e0 TRUE ho\u1eb7c FALSE.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n k\u1ebft qu\u1ea3 th\u1ec3 hi\u1ec7n s\u1ef1 gi\u1ed1ng ho\u1eb7c kh\u00e1c nhau l\u00e0 nh\u1eefng c\u1ee5m t\u1eeb c\u1ee7a ri\u00eang b\u1ea1n, th\u00eam c\u1ee5m \u0111\u00f3 v\u00e0o c\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m IF<\/a> nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(A1=B1, \u201cEqual\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 so s\u00e1nh chu\u1ed7i ch\u1eef, ng\u00e0y v\u00e0 s\u1ed1.<\/p>\n<figure id=\"attachment_4817\" aria-describedby=\"caption-attachment-4817\" style=\"width: 437px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4817 size-full\" title=\"1 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-compare-strings-case-insensitive.png\" alt=\"1 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"437\" height=\"220\"><figcaption id=\"caption-attachment-4817\" class=\"wp-caption-text\">1 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_2_O_PHAN_BIET_CHU_VIET_HOA_VIET_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH 2 \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee VI\u1ebeT HOA, VI\u1ebeT TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1edbi m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, y\u00eau <a href=\"https:\/\/beachyspharmacy.com\/glucophage.aspx\">https:\/\/beachyspharmacy.com<\/a> antibiotics c\u1ea7u kh\u00f4ng ch\u1ec9 so s\u00e1nh ch\u1eef trong 2 m\u00e0 c\u00f2n so s\u00e1nh ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, th\u00ec vi\u1ec7c so s\u00e1nh c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m EXACT trong Excel.<\/p>\n<p style=\"text-align: justify\"><em><strong>EXACT (chu\u1ed7i v\u0103n b\u1ea3n 1, chu\u1ed7i v\u0103n b\u1ea3n 2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">N\u1ebfu chu\u1ed7i v\u0103n b\u1ea3n 1 v\u00e0 chu\u1ed7i v\u0103n b\u1ea3n 2 \u1edf trong 2 \u00f4 m\u00e0 b\u1ea1n c\u1ea7n so s\u00e1nh, gi\u1ea3 s\u1eed \u00f4 A2 v\u00e0 B2 th\u00ec c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=EXACT(A2, B2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c TRUE n\u1ebfu chu\u1ed7i ch\u1eef kh\u1edbp nhau ho\u00e0n to\u00e0n c\u1ea3 v\u1ec1 m\u1eb7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng c\u00f2n kh\u00f4ng s\u1ebd l\u00e0 FALSE.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n h\u00e0m EXACT cho ra k\u1ebft qu\u1ea3 kh\u00e1c TRUE ho\u1eb7c FALSE th\u00ec d\u00f9ng c\u00f4ng th\u1ee9c IF v\u00e0 \u0111\u00e1nh c\u1ee5m t\u1eeb m\u00e0 b\u1ea1n mu\u1ed1n n\u1ebfu k\u1ebft qu\u1ea3 \u0111\u00fang v\u00e0 sai:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(EXACT(A2 ,B2), \u201cExactly equal\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi mi\u00eau t\u1ea3 k\u1ebft qu\u1ea3 trong tr\u01b0\u1eddng h\u1ee3p so s\u00e1nh ph\u00e2n bi\u1ec7t ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng:<\/p>\n<figure id=\"attachment_4818\" aria-describedby=\"caption-attachment-4818\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4818 size-full\" title=\"2 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-compare-strings-case-sensitive.png\" alt=\"2 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"579\" height=\"204\"><figcaption id=\"caption-attachment-4818\" class=\"wp-caption-text\">2 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a h\u1ecdc excel k\u1ebf to\u00e1n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SO_SANH_NHIEU_O_TRONG_EXCEL\"><\/span><strong>SO S\u00c1NH NHI\u1ec0U \u00d4 TRONG EXCEL:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 so s\u00e1nh nhi\u1ec1u h\u01a1n 2 \u00f4 trong 1 h\u00e0ng, d\u00f9ng c\u00f4ng th\u1ee9c nh\u01b0 v\u00ed d\u1ee5 tr\u00ean v\u00e0 k\u1ebft h\u1ee3p th\u00eam AND. Chi ti\u1ebft nh\u01b0 sau:<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_NHIEU_O_KHONG_PHAN_BIET_CHU_HOA_CHU_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Tu\u1ef3 v\u00e0o c\u00e1ch b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3 nh\u01b0 th\u1ebf n\u00e0o, d\u00f9ng 1 trong s\u1ed1 nh\u1eefng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=AND(A2=B2, A2=C2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(AND(A2=B2, A2=C2), \u201cEqual\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c AND tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb gi\u1ed1ng nhau, FALSE n\u1ebfu 1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb kh\u00e1c. C\u00f4ng th\u1ee9c IF gi\u00fap b\u1ea1n vi\u1ebft k\u1ebft qu\u1ea3 b\u1eb1ng t\u1eeb c\u1ee7a ri\u00eang b\u1ea1n, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u201cEqual\u201d v\u00e0 \u201cNot equal\u201d.<\/p>\n<p style=\"text-align: justify\">Trong h\u00ecnh d\u01b0\u1edbi, c\u00f4ng th\u1ee9c \u0111\u00fang v\u1edbi m\u1ecdi ki\u1ec3u d\u1eef li\u1ec7u \u2013 ch\u1eef, s\u1ed1, ng\u00e0y.<\/p>\n<figure id=\"attachment_4819\" aria-describedby=\"caption-attachment-4819\" style=\"width: 591px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4819 size-full\" title=\"3 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-compare-multiple-strings.png\" alt=\"3 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"591\" height=\"222\"><figcaption id=\"caption-attachment-4819\" class=\"wp-caption-text\">3 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_NHIEU_O_PHAN_BIET_CHU_HOA_CHU_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH NHI\u1ec0U \u00d4 PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 so s\u00e1nh nhi\u1ec1u chu\u1ed7i xem ch\u00fang c\u00f3 gi\u1ed1ng nhau ho\u00e0n to\u00e0n kh\u00f4ng, d\u00f9ng 1 trong s\u1ed1 c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=AND(EXACT(A2,B2), EXACT(A2, C2))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(AND(EXACT(A2,B2), EXACT(A2, C2)),\u201dExactly equal\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u0169ng gi\u1ed1ng v\u00ed d\u1ee5 tr\u01b0\u1edbc, c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean cho ra gi\u00e1 tr\u1ecb TRUE \u2013 FALSE, c\u00f4ng th\u1ee9c th\u1ee9 2 cho ra k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n \u0111\u1eb7t t\u00ean ri\u00eang.<\/p>\n<figure id=\"attachment_4820\" aria-describedby=\"caption-attachment-4820\" style=\"width: 619px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4820 size-full\" title=\"4 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-multiple-cells-exact.png\" alt=\"4 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"619\" height=\"224\"><figcaption id=\"caption-attachment-4820\" class=\"wp-caption-text\">4 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">Kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SO_SANH_DAY_O_VOI_1_O_MAU\"><\/span><strong>SO S\u00c1NH D\u00c3Y \u00d4 V\u1edaI 1 \u00d4 M\u1eaaU\u00a0 <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 trong 1 d\u00e3y c\u00f3 ch\u1ee9a \u0111o\u1ea1n v\u0103n b\u1ea3n gi\u1ed1ng nh\u01b0 \u0111o\u1ea1n v\u0103n b\u1ea3n trong \u00f4 m\u1eabu.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_CAC_O_VOI_DOAN_VAN_BAN_MAU_KHONG_PHAN_BIET_CHU_HOA_CHU_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU KH\u00d4NG PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu ch\u1eef hoa hay ch\u1eef th\u01b0\u1eddng kh\u00f4ng quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 so s\u00e1nh c\u00e1c \u00f4 v\u1edbi m\u1eabu:<\/p>\n<p style=\"text-align: justify\"><em><strong>ROWS(d\u00e3y \u00f4)*COLUMNS(d\u00e3y \u00f4)=COUNTIF(d\u00e3y \u00f4, \u00f4 m\u1eabu)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Trong ki\u1ec3m tra logic c\u1ee7a h\u00e0m IF, b\u1ea1n so s\u00e1nh 2 s\u1ed1:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1ed1 \u00f4 c\u00f3 trong 1 kho\u1ea3ng c\u1ee5 th\u1ec3 (s\u1ed1 h\u00e0ng nh\u00e2n v\u1edbi s\u1ed1 c\u1ed9t)<\/li>\n<li>S\u1ed1 \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb gi\u1ed1ng nh\u01b0 gi\u00e1 tr\u1ecb trong \u00f4 m\u1eabu (k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c tr\u1ea3 b\u1edfi h\u00e0ng COUNTIF)<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed \u0111o\u1ea1n v\u0103n b\u1ea3n m\u1eabu c\u00f3 \u00f4 C2 v\u00e0 chu\u1ed7i \u0111\u1ec3 so s\u00e1nh \u1edf c\u00e1c \u00f4 \u1edf kho\u1ea3ng A2:B6, c\u00f4ng th\u1ee9c s\u1ebd nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=ROWS(A2:B6)*COLUMNS(A2:B6)=COUNTIF(A2:B6,C2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng h\u01a1n, v\u00ed d\u1ee5 nh\u01b0 \u201cAll match\u201d ho\u1eb7c \u201cNot all match\u201d thay v\u00ec TRUE v\u00e0 FALSE, d\u00f9ng h\u00e0m IF nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m \u1edf c\u00e1c v\u00ed d\u1ee5 tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(ROWS(A2:B6)*COLUMNS(A2:B6)=COUNTIF(A2:B6,C2),\u201dAll match\u201d, \u201cNot all match\u201d)<\/strong><\/em><\/p>\n<figure id=\"attachment_4821\" aria-describedby=\"caption-attachment-4821\" style=\"width: 459px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4821 size-full\" title=\"5 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-range-sample-text.png\" alt=\"5 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"459\" height=\"201\"><figcaption id=\"caption-attachment-4821\" class=\"wp-caption-text\">5 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 th\u1ea5y \u1edf h\u00ecnh tr\u00ean, c\u00f4ng th\u1ee9c \u0111\u00fang v\u1edbi chu\u1ed7i v\u0103n b\u1ea3n, ng\u00e0y v\u00e0 s\u1ed1.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CONG_THUC_SO_SANH_CAC_O_VOI_DOAN_VAN_BAN_MAU_PHAN_BIET_CHU_HOA_CHU_THUONG\"><\/span><strong>C\u00d4NG TH\u1ee8C SO S\u00c1NH C\u00c1C \u00d4 V\u1edaI \u0110O\u1ea0N V\u0102N B\u1ea2N M\u1eaaU PH\u00c2N BI\u1ec6T CH\u1eee HOA, CH\u1eee TH\u01af\u1edcNG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c M\u1ea3ng sau \u0111\u1ec3 so s\u00e1nh c\u00e1c \u00f4 v\u1edbi m\u1eabu:<\/p>\n<p style=\"text-align: justify\"><em><strong>IF(ROWS(d\u00e3y \u00f4)*COLUMNS(d\u00e3y \u00f4)=SUM(\u2013EXACT(\u00f4 m\u1eabu, d\u00e3y \u00f4)), \u201ct\u1eeb_k\u1ebft_qu\u1ea3_n\u1ebfu _tr\u00f9ng\u201d, \u201d t\u1eeb_k\u1ebft_qu\u1ea3_n\u1ebfu _kh\u00f4ng_tr\u00f9ng \u201c)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u1edbi kho\u1ea3ng \u00f4 t\u1eeb A2:B6 m\u00e0 \u0111o\u1ea1n v\u0103n b\u1ea3n m\u1eabu trong \u00f4 C2, c\u00f4ng th\u1ee9c s\u1ebd th\u00e0nh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(ROWS(A2:B6)*COLUMNS(A2:B6)=SUM(\u2013EXACT(C2, A2:B6)), \u201cAll match\u201d, \u201cNot all match\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng c\u00e1c c\u00f4ng th\u1ee9c th\u00f4ng th\u01b0\u1eddng, c\u00f4ng th\u1ee9c M\u1ea3ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch nh\u1ea5n c\u1ee5m <em><strong>Ctrl + Shift + Enter<\/strong><\/em>. N\u1ebfu nh\u1ea5n \u0111\u00fang, Excel s\u1ebd \u0111\u1ec3 c\u00f4ng th\u1ee9c M\u1ea3ng trong d\u1ea5u ngo\u1eb7c m\u00f3c nh\u01b0 trong h\u00ecnh:<\/p>\n<figure id=\"attachment_4822\" aria-describedby=\"caption-attachment-4822\" style=\"width: 404px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4822 size-full\" title=\"6 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-range-case-sensitive.png\" alt=\"6 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"404\" height=\"201\"><figcaption id=\"caption-attachment-4822\" class=\"wp-caption-text\">6 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SO_SANH_2_O_THEO_DO_DAI_CHUOI\"><\/span><strong>SO S\u00c1NH 2 \u00d4 THEO \u0110\u1ed8 D\u00c0I CHU\u1ed6I:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00f4i khi b\u1ea1n c\u1ea7n ki\u1ec3m tra xem \u0111\u1ed9 d\u00e0i chu\u1ed7i ch\u1eef trong m\u1ed7i h\u00e0ng c\u00f3 b\u1eb1ng nhau kh\u00f4ng. C\u00f4ng th\u1ee9c cho y\u00eau c\u1ea7u n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n. \u0110\u1ea7u ti\u00ean, b\u1ea1n l\u1ea5y \u0111\u1ed9 d\u00e0i chu\u1ed7i ch\u1eef trong 2 \u00f4 b\u1eb1ng c\u00e1ch d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m LEN<\/a>, sau \u0111\u00f3 so s\u00e1nh c\u00e1c con s\u1ed1.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed \u0111o\u1ea1n ch\u1eef c\u1ea7n so s\u00e1nh \u1edf \u00f4 A2 v\u00e0 B2, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng 1 trong s\u1ed1 c\u00e1c c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(A2)=LEN(B2)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Ho\u1eb7c<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(LEN(A2)=LEN(B2), \u201cEqual\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, c\u00f4ng th\u1ee9c th\u1ee9 1 tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 TRUE\/FALSE, c\u00f2n c\u00f4ng th\u1ee9c th\u1ee9 2 l\u00e0 t\u1eeb k\u1ebft qu\u1ea3 c\u1ee7a ri\u00eang b\u1ea1n.<\/p>\n<figure id=\"attachment_4824\" aria-describedby=\"caption-attachment-4824\" style=\"width: 380px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4824 size-full\" title=\"7 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-string-length.png\" alt=\"7 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"380\" height=\"164\"><figcaption id=\"caption-attachment-4824\" class=\"wp-caption-text\">7 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">V\u1edbi h\u00ecnh tr\u00ean, c\u00f4ng th\u1ee9c \u0111\u00fang v\u1edbi \u0111o\u1ea1n v\u0103n b\u1ea3n, s\u1ed1.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o nh\u1ecf:<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu 2 \u0111o\u1ea1n v\u0103n b\u1ea3n d\u01b0\u1eddng nh\u01b0 gi\u1ed1ng nhau l\u1ea1i cho ra \u0111\u1ed9 d\u00e0i kh\u00e1c nhau, th\u00ec v\u1ea5n \u0111\u1ec1 c\u00f3 th\u1ec3 l\u00e0 do d\u1ea5u c\u00e1ch \u1edf tr\u01b0\u1edbc ho\u1eb7c sau \u1edf 1 ho\u1eb7c c\u1ea3 2 \u00f4. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch th\u1eeba b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m TRIM.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"SO_SANH_2_O_BANG_SO_LAN_XUAT_HIEN_CUA_1_KY_TU_CU_THE\"><\/span><strong>SO S\u00c1NH 2 \u00d4 B\u1eb0NG S\u1ed0 L\u1ea6N XU\u1ea4T HI\u1ec6N C\u1ee6A 1 K\u00dd T\u1ef0 C\u1ee4 TH\u1ec2:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 v\u00ed d\u1ee5 cu\u1ed1i c\u00f9ng trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, th\u1ec3 hi\u1ec7n c\u00e1ch l\u00e0m cho 1 c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3. Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 2 c\u1ed9t chu\u1ed7i ch\u1eef c\u00f3 ch\u1ee9a 1 k\u00fd t\u1ef1 quan tr\u1ecdng. M\u1ee5c ti\u00eau c\u1ee7a b\u1ea1n l\u00e0 ki\u1ec3m tra xem trong 2 c\u1ed9t \u1edf m\u1ed7i h\u00e0ng, s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 \u0111\u00f3 c\u00f3 b\u1eb1ng nhau hay kh\u00f4ng.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n, b\u1ea1n h\u00e3y xem v\u00ed d\u1ee5 sau. B\u1ea1n c\u00f3 2 danh s\u00e1ch giao h\u00e0ng (c\u1ed9t B) v\u00e0 nh\u1eadn h\u00e0ng (c\u1ed9t C). M\u1ed7i h\u00e0ng ch\u1ee9a c\u00e1c danh s\u00e1ch \u0111\u01a1n h\u00e0ng cho 1 m\u1eb7t h\u00e0ng c\u1ee5 th\u1ec3, m\u1eb7t h\u00e0ng \u0111\u01b0\u1ee3c ph\u00e2n bi\u1ec7t b\u1eb1ng m\u00e3 ri\u00eang v\u00e0 m\u00e3 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea \u1edf c\u1ed9t A (xem h\u00ecnh b\u00ean d\u01b0\u1edbi). B\u1ea1n mu\u1ed1n ch\u1eafc ch\u1eafn r\u1eb1ng trong m\u1ed7i h\u00e0ng, c\u00f3 ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng giao v\u00e0 h\u00e0ng nh\u1eadn b\u1eb1ng nhau, v\u1edbi m\u00e3 c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, vi\u1ebft c\u00f4ng th\u1ee9c v\u1edbi logic nh\u01b0 sau.<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ea7u ti\u00ean, thay th\u1ebf m\u00e3 ph\u00e2n bi\u1ec7t th\u00e0nh kh\u00f4ng d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-substitute-trong-excel-huong-dan-su-dung-va-co-vi-du-minh-hoa-cu-the.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m SUBSTITUTE<\/a>:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><em><strong>SUBSTITUTE(A1, k\u00fd_hi\u1ec7u_\u0111\u1ec3_\u0111\u1ebfm,\u201d\u201d)<\/strong><\/em><\/p>\n<ul style=\"text-align: justify\">\n<li>Sau \u0111\u00f3, \u0111\u1ebfm xem bao nhi\u00eau l\u1ea7n m\u00e3 ph\u00e2n bi\u1ec7t xu\u1ea5t hi\u1ec7n trong m\u1ed7i \u00f4. C\u00e1ch l\u00e0m: l\u1ea5y \u0111\u1ed9 d\u00e0i chu\u1ed7i khi lo\u1ea1i b\u1ecf m\u00e3 ph\u00e2n bi\u1ec7t, tr\u1eeb m\u00e3 kh\u1ecfi t\u1ed5ng \u0111\u1ed9 d\u00e0i chu\u1ed7i. Ph\u1ea7n n\u00e0y n\u00ean \u0111\u01b0\u1ee3c vi\u1ebft ri\u00eang cho \u00f4 1 v\u00e0 \u00f4 2, v\u00ed d\u1ee5 nh\u01b0:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><em><strong>LEN(cell 1) \u2013 LEN(SUBSTITUTE(cell 1, character_to_count, \u201c\u201d))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u00e0<\/p>\n<p style=\"text-align: justify\"><em><strong>LEN(cell 2) \u2013 LEN(SUBSTITUTE(cell 2, character_to_count, \u201c\u201d))<\/strong><\/em><\/p>\n<ul style=\"text-align: justify\">\n<li>Cu\u1ed1i c\u00f9ng, so s\u00e1nh 2 con s\u1ed1 tr\u00ean b\u1eb1ng c\u00e1ch \u0111\u1eb7t d\u1ea5u b\u1eb1ng gi\u1eefa 2 ph\u1ea7n tr\u00ean<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><em><strong>LEN(cell 1) \u2013 LEN(SUBSTITUTE(cell 1, character_to_count, \u201c\u201d))=<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><em><strong>LEN(cell 2) \u2013 LEN(SUBSTITUTE(cell 2, character_to_count, \u201c\u201d))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 c\u1ee7a ch\u00fang ta, m\u00e3 ph\u00e2n bi\u1ec7t \u1edf \u00f4 A2, v\u00e0 chu\u1ed7i ch\u1eef \u0111\u1ec3 so s\u00e1nh \u1edf \u00f4 B2 v\u00e0 C2. Th\u1ec3 n\u00ean c\u00f4ng th\u1ee9c s\u1ebd l\u00e0:<\/p>\n<p style=\"text-align: justify\"><em><strong>=LEN(B2)-LEN(SUBSTITUTE(B2,$A2,\u201d\u201d))=LEN(C2)-LEN(SUBSTITUTE(C2,$A2,\u201d\u201d))<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c tr\u1ea3 TRUE n\u1ebfu \u00f4 B2 v\u00e0 C2 ch\u1ee9a s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a k\u00fd t\u1ef1 trong \u00f4 A2 b\u1eb1ng nhau, n\u1ebfu kh\u00f4ng th\u00ec FALSE. \u0110\u1ed5i th\u00e0nh k\u1ebft qu\u1ea3 c\u00f3 \u00edch h\u01a1n v\u1edbi ng\u01b0\u1eddi d\u00f9ng, b\u1ea1n d\u00f9ng h\u00e0m IF:<\/p>\n<p style=\"text-align: justify\"><em><strong>=IF(LEN(B2)-LEN(SUBSTITUTE(B2, $A2,\u201d\u201d))=LEN(C2)-LEN(SUBSTITUTE(C2, $A2,\u201d\u201d)), \u201cEqual\u201d, \u201cNot equal\u201d)<\/strong><\/em><\/p>\n<figure id=\"attachment_4825\" aria-describedby=\"caption-attachment-4825\" style=\"width: 454px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4825 size-full\" title=\"8 - so s\u00e1nh chu\u1ed7i trong excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/compare-strings-char.png\" alt=\"8 - so s\u00e1nh chu\u1ed7i trong excel\" width=\"454\" height=\"185\"><figcaption id=\"caption-attachment-4825\" class=\"wp-caption-text\">8 \u2013 so s\u00e1nh chu\u1ed7i trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, c\u00f4ng th\u1ee9c ho\u00e0n to\u00e0n ph\u00f9 h\u1ee3p ngay c\u1ea3 khi c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>K\u00fd t\u1ef1 \u0111\u01b0\u1ee3c \u0111\u1ebfm (m\u00e3 ph\u00e2n bi\u1ec7t) xu\u1ea5t hi\u1ec7n \u1edf b\u1ea5t k\u00ec \u0111\u00e2u trong chu\u1ed7i v\u0103n b\u1ea3n.<\/li>\n<li>Chu\u1ed7i v\u0103n b\u1ea3n ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng k\u00fd t\u1ef1 kh\u00e1c nhau, d\u1ea5u c\u00e2u kh\u00e1c nhau nh\u01b0 \u201c;\u201d, \u201c,\u201d ho\u1eb7c d\u1ea5u c\u00e1ch.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u01b0 v\u00e2\u0323y, blog.hocexcel.online \u0111a\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n ca\u0301ch c\u00e1ch so s\u00e1nh chu\u1ed7i trong Excel. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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\u00a0<a href=\"http:\/\/bit.ly\/2w8iXHK\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-34.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":645,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-644","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\/644","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=644"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/645"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}