{"id":1089,"date":"2024-12-02T04:04:33","date_gmt":"2024-12-02T04:04:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel\/"},"modified":"2024-12-02T04:04:33","modified_gmt":"2024-12-02T04:04:33","slug":"huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a ch\u00fang ta khi h\u1ecdc\u00a0Excel\u00a0\u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t, t\u1eeb\u00a0\u0111\u00f3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c. Th\u1ebf nh\u01b0ng ch\u00fang ta c\u0169ng g\u1eb7p ph\u1ea3i v\u00f4 v\u00e0n nh\u1eefng th\u1eafc m\u1eafc nh\u01b0:<\/p>\n<ul>\n<li>T\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o l\u00e0 t\u1ed1t?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o tr\u00ean\u00a0Excel?<\/li>\n<li>B\u00e1o c\u00e1o th\u1ebf n\u00e0o l\u00e0\u00a0\u0111\u1eb9p, khoa h\u1ecdc?<\/li>\n<li>\u2026<\/li>\n<\/ul>\n<p>Nh\u1eb1m gi\u00fap c\u00e1c b\u1ea1n h\u00ecnh th\u00e0nh t\u01b0 duy t\u1ed1t trong vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel, <strong>H\u1ecdc\u00a0Excel Online<\/strong> xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n seri b\u00e0i vi\u1ebft v\u1ec1 \u201cK\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel\u201d. B\u00e0i vi\u1ebft c\u1ee7a t\u00e1c gi\u1ea3 D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n \u2013 Gi\u1ea3ng vi\u00ean c\u1ee7a H\u1ecdc Excel Online, d\u1ef1a tr\u00ean nh\u1eefng kinh nghi\u1ec7m gi\u1ea3ng d\u1ea1y trong th\u1ef1c t\u1ebf c\u1ee7a th\u1ea7y li\u00ean quan t\u1edbi n\u1ed9i dung n\u00e0y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch x\u1eed l\u00fd <strong>l\u1ed7i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong excel<\/strong> nh\u00e9.<\/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-674d31d00fac7\" 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\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#Bai_4_Huong_dan_cach_xu_ly_loi_du_lieu_dang_so_Number_trong_Excel\" title=\"B\u00e0i 4:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1 (Number) trong\u00a0Excel\">B\u00e0i 4:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1 (Number) trong\u00a0Excel<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#1_Phat_hien_loi_du_lieu_dang_so_voi_bo_loc_tu_dong_trong_Excel_cong_cu_AutoFilter\" title=\"1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1\u00a0v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)\">1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1\u00a0v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#2_Nguyen_tac_sap_xep_du_lieu_dang_so_trong_AutoFilter\" title=\"2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 trong AutoFilter\">2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 trong AutoFilter<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#3_Nguyen_tac_du_lieu_dang_Number_co_the_tinh_toan_duoc\" title=\"3. Nguy\u00ean t\u1eafc d\u1eef li\u1ec7u d\u1ea1ng Number c\u00f3 th\u1ec3 t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c\">3. Nguy\u00ean t\u1eafc d\u1eef li\u1ec7u d\u1ea1ng Number c\u00f3 th\u1ec3 t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c<\/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\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#4_Cach_xu_ly_sua_loi_du_lieu\" title=\"4. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u\">4. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#Buoc_1_Thong_nhat_ve_dinh_dang_du_lieu\" title=\"B\u01b0\u1edbc 1: Th\u1ed1ng nh\u1ea5t v\u1ec1\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u\">B\u01b0\u1edbc 1: Th\u1ed1ng nh\u1ea5t v\u1ec1\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#Buoc_2_Loc_nhung_loi_ky_tu_de_sua_cach_thu_1\" title=\"B\u01b0\u1edbc 2: L\u1ecdc nh\u1eefng l\u1ed7i k\u00fd t\u1ef1\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 1)\">B\u01b0\u1edbc 2: L\u1ecdc nh\u1eefng l\u1ed7i k\u00fd t\u1ef1\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 1)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-so-trong-excel.html#Buoc_3_Su_dung_ham_Value_de_sua_cach_thu_2\" title=\"B\u01b0\u1edbc 3: S\u1eed d\u1ee5ng h\u00e0m Value\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 2)\">B\u01b0\u1edbc 3: S\u1eed d\u1ee5ng h\u00e0m Value\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 2)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_4_Huong_dan_cach_xu_ly_loi_du_lieu_dang_so_Number_trong_Excel\"><\/span>B\u00e0i 4:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1 (Number) trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c sai d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 c\u00f3\u00a0\u1ea3nh h\u01b0\u1edfng r\u1ea5t l\u1edbn trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 l\u1eadp b\u00e1o c\u00e1o. B\u1edfi k\u1ebft qu\u1ea3 c\u1ee7a b\u00e1o c\u00e1o ph\u1ee5 thu\u1ed9c r\u1ea5t l\u1edbn v\u00e0o n\u1ed9i dung n\u00e0y. L\u1ed7i v\u1ec1 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 c\u00f3 th\u1ec3 k\u1ec3 t\u1edbi nh\u01b0:<\/p>\n<ul>\n<li>Sai v\u1ec1\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u: c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n hay kh\u00f4ng, d\u1eef li\u1ec7u l\u00e0 % hay d\u1ea1ng s\u1ed1 th\u00f4ng th\u01b0\u1eddng, c\u00f3 l\u1eabn l\u1ed9n gi\u1eefa d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng (date) v\u00e0o trong d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 kh\u00f4ng (v\u00ec d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng v\u1ec1 b\u1ea3n ch\u1ea5t c\u0169ng l\u00e0 d\u1ea1ng s\u1ed1)<\/li>\n<li>Sai v\u1ec1 thao t\u00e1c nh\u1eadp d\u1eef li\u1ec7u: Trong qu\u00e1 tr\u00ecnh nh\u1eadp c\u00f3 l\u1eabn 1 k\u00fd t\u1ef1 text v\u00e0o chung v\u1edbi k\u00fd t\u1ef1 s\u1ed1, d\u1eabn t\u1edbi\u00a0Excel s\u1ebd coi\u00a0\u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u Text thay v\u00ec d\u1ea1ng Number<\/li>\n<\/ul>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ph\u00e1t hi\u1ec7n nh\u1eefng l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1\u00a0\u0111\u00e3 c\u00f3 trong 1 b\u1ea3ng d\u1eef li\u1ec7u? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u nh\u00e9.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Phat_hien_loi_du_lieu_dang_so_voi_bo_loc_tu_dong_trong_Excel_cong_cu_AutoFilter\"><\/span>1. Ph\u00e1t hi\u1ec7n l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1\u00a0v\u1edbi b\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng trong Excel (c\u00f4ng c\u1ee5\u00a0AutoFilter)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1ec1 c\u00e1ch m\u1edf c\u00f4ng c\u1ee5 AutoFilter th\u00ec m\u00ecnh\u00a0\u0111\u00e3 h\u01b0\u1edbng d\u1eabn\u00a0\u1edf trong b\u00e0i h\u1ecdc tr\u01b0\u1edbc, m\u1eddi c\u00e1c b\u1ea1n xem l\u1ea1i b\u00e0i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp ng\u00e0y th\u00e1ng trong excel<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Nguyen_tac_sap_xep_du_lieu_dang_so_trong_AutoFilter\"><\/span>2. Nguy\u00ean t\u1eafc s\u1eafp x\u1ebfp d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1 trong AutoFilter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi d\u1eef li\u1ec7u\u00a0d\u1ea1ng s\u1ed1 s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp trong c\u1eeda s\u1ed5 d\u1eef li\u1ec7u l\u1ecdc c\u1ee7a AutoFilter theo quy t\u1eafc:<\/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-75.gif\" title=\"ex101_92019-nho-75\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>T\u0103ng d\u1ea7n t\u1eeb nh\u1ecf t\u1edbi l\u1edbn (n\u1ebfu c\u00f3 s\u1ed1\u00a0\u00e2m th\u00ec s\u1ebd t\u00ednh c\u1ea3 t\u1eeb ph\u1ea7n s\u1ed1\u00a0\u00e2m tr\u1edf\u00a0\u0111i ch\u1ee9 kh\u00f4ng ph\u1ea3i b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb s\u1ed1 0)<\/li>\n<li>N\u1ebfu c\u00f3 ch\u1ee9a k\u00fd t\u1ef1 kh\u00f4ng ph\u1ea3i d\u1ea1ng s\u1ed1 th\u00ec s\u1ebd n\u1eb1m\u00a0\u1edf cu\u1ed1i danh s\u00e1ch l\u1ecdc t\u1ef1\u00a0\u0111\u1ed9ng n\u00e0y.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17082\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofilter-number-01.png\" width=\"949\" height=\"562\" title=\"autofilter-number-01\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y s\u1ed1 124,235 l\u00e0 s\u1ed1 nh\u1ecf h\u01a1n 12,489,621 nh\u01b0ng l\u1ea1i\u00a0\u0111\u01b0\u1ee3c x\u1ebfp ph\u00eda sau =&gt; S\u1ed1\u00a0\u0111\u00f3\u00a0\u0111ang b\u1ecb sai lo\u1ea1i d\u1eef li\u1ec7u b\u1edfi v\u00ec c\u00f3 ch\u1ee9a d\u1ea5u c\u00e1ch<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Nguyen_tac_du_lieu_dang_Number_co_the_tinh_toan_duoc\"><\/span>3. Nguy\u00ean t\u1eafc d\u1eef li\u1ec7u d\u1ea1ng Number c\u00f3 th\u1ec3 t\u00ednh to\u00e1n\u00a0\u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng AutoFilter\u00a0\u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u l\u1ed7i, ch\u00fang ta c\u00f3 th\u1ec3 d\u1ef1a tr\u00ean 1 nguy\u00ean t\u1eafc n\u1eefa\u00a0\u0111\u1ec3 ph\u00e1t hi\u1ec7n d\u1eef li\u1ec7u l\u1ed7i:<\/p>\n<p style=\"padding-left: 30px\"><strong>D\u1eef li\u1ec7u d\u1ea1ng Number c\u00f3 th\u1ec3 t\u00ednh to\u00e1n (c\u1ed9ng, tr\u1eeb, nh\u00e2n, chia)\u00a0\u0111\u01b0\u1ee3c; c\u00f2n d\u1eef li\u1ec7u d\u1ea1ng Text th\u00ec kh\u00f4ng.<\/strong><\/p>\n<p>Theo nguy\u00ean t\u1eafc n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 ki\u1ec3m tra xem d\u1eef li\u1ec7u nghi ng\u1edd l\u00e0 sai c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n kh\u00f4ng. N\u1ebfu ra l\u1ed7i #VALUE! th\u00ec kh\u00f4ng ph\u1ea3i d\u1eef li\u1ec7u d\u1ea1ng Number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Cach_xu_ly_sua_loi_du_lieu\"><\/span>4. C\u00e1ch x\u1eed l\u00fd, s\u1eeda l\u1ed7i d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_1_Thong_nhat_ve_dinh_dang_du_lieu\"><\/span><strong>B\u01b0\u1edbc 1: Th\u1ed1ng nh\u1ea5t v\u1ec1\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1(v\u00ed d\u1ee5\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 c\u1ed9t E)<\/p>\n<p>V\u00e0o m\u1ee5c Format Cells &gt; Ch\u1ecdn m\u1ee5c Number theo h\u00ecnh sau<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17101\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofilter-number-02.png\" width=\"1056\" height=\"493\" title=\"autofilter-number-02\"><\/p>\n<ul>\n<li><strong>Decimal places<\/strong>: s\u1ed1\u00a0sau d\u1ea5u ph\u1ea9y l\u00e0 m\u1ea5y ch\u1eef s\u1ed1<\/li>\n<li><strong>Use 1000 separator<\/strong> : S\u1eed d\u1ee5ng d\u1ea5u ng\u0103n c\u00e1ch h\u00e0ng ngh\u00ecn<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 d\u1ea1ng Number c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c d\u1ea1ng Accounting ho\u1eb7c Currency (n\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u lo\u1ea1i ti\u1ec1n t\u1ec7 th\u00ec ch\u1ecdn None)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17104\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofilter-number-03.png\" width=\"784\" height=\"290\" title=\"autofilter-number-03\"><\/p>\n<p>B\u01b0\u1edbc n\u00e0y gi\u00fap ch\u00fang ta th\u1ed1ng nh\u1ea5t v\u1ec1 c\u00e1ch hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u,\u00a0\u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u khi nh\u1eadp v\u00e0o\u00a0\u0111\u1ec3 tr\u00e1nh vi\u1ec7c quy\u00a0\u01b0\u1edbc hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u kh\u00f4ng\u00a0\u0111\u1ed3ng nh\u1ea5t trong c\u00f9ng 1 c\u1ed9t.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_2_Loc_nhung_loi_ky_tu_de_sua_cach_thu_1\"><\/span>B\u01b0\u1edbc 2: L\u1ecdc nh\u1eefng l\u1ed7i k\u00fd t\u1ef1\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 1)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u0103n c\u1ee9 v\u00e0o gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong d\u00e3y s\u1ed1\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1ef1\u00a0\u0111\u1ed9ng trong Auto Filter:<\/p>\n<ul>\n<li>Ph\u1ea7n ph\u00eda tr\u01b0\u1edbc\u00a0s\u1ed1\u00a0\u0111\u00f3: L\u00e0 nh\u1eefng s\u1ed1\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u0111\u00fang<\/li>\n<li>Ph\u1ea7n ph\u00eda sau s\u1ed1\u00a0\u0111\u00f3: L\u00e0 nh\u1eefng s\u1ed1 c\u00f3 l\u1ed7i<\/li>\n<\/ul>\n<p>Sau khi l\u1ecdc nh\u1eefng s\u1ed1 c\u00f3 l\u1ed7i th\u00ec th\u1ef1c hi\u1ec7n nh\u1eadp l\u1ea1i c\u00e1c s\u1ed1\u00a0\u0111\u00f3<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Buoc_3_Su_dung_ham_Value_de_sua_cach_thu_2\"><\/span>B\u01b0\u1edbc 3: S\u1eed d\u1ee5ng h\u00e0m Value\u00a0\u0111\u1ec3 s\u1eeda (c\u00e1ch th\u1ee9 2)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eeda tr\u1ef1c ti\u1ebfp v\u00e0o b\u1ea3ng, c\u00f3 th\u1ec3 t\u1ea1o c\u1ed9t ph\u1ee5 v\u00e0 s\u1eed d\u1ee5ng h\u00e0m VALUE trong c\u1ed9t ph\u1ee5\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 chuy\u1ec3n gi\u00e1 tr\u1ecb trong b\u1ea3ng v\u1ec1\u00a0\u0111\u00fang d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1.<\/p>\n<p>Tr\u00ecnh t\u1ef1 th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Tr\u01b0\u1edbc khi s\u1eeda l\u1ed7i c\u1ea7n copy d\u1eef li\u1ec7u g\u1ed1c ra 1 Sheet m\u1edbi v\u00e0 x\u1eed l\u00fd tr\u00ean n\u1ed9i dung copy\u00a0\u1edf Sheet m\u1edbi\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o kh\u00f4ng b\u1ecb m\u1ea5t d\u1eef li\u1ec7u.<\/li>\n<li>Th\u1eeba\u00a0k\u00fd t\u1ef1: c\u00e1c d\u1ea5u c\u00e1ch th\u1eeba, d\u1ea5u ch\u1ea5m, d\u1ea5u ph\u1ea9y, d\u1ea5u ch\u1ea5m ph\u1ea9y, d\u1ea5u nh\u00e1y\u2026 l\u1eabn v\u00e0o k\u00fd t\u1ef1 d\u1ea1ng s\u1ed1 =&gt; S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Replace\u00a0\u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c k\u00fd t\u1ef1 th\u1eeba<\/li>\n<li>\u1ede c\u00e1c\u00a0\u0111\u1ecbnh d\u1ea1ng kh\u00e1c (kh\u00f4ng ph\u1ea3i d\u1ea1ng Number nh\u01b0ng\u00a0\u0111\u00e3\u00a0\u0111\u1ea3m b\u1ea3o ch\u1ec9 to\u00e0n k\u00fd t\u1ef1\u00a0d\u1ea1ng s\u1ed1) th\u00ec s\u1eed d\u1ee5ng h\u00e0m Value tr\u1ef1c ti\u1ebfp cho c\u00e1c gi\u00e1 tr\u1ecb\u00a0\u0111\u00f3. Sau khi c\u00f3 k\u1ebft qu\u1ea3 h\u00e0m Value th\u00ec s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Copy\/Paste special&gt;Value\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 5: Ki\u1ec3m tra l\u1ea1i n\u1ed9i dung xem nh\u1eefng d\u1eef li\u1ec7u l\u1ed7i\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c s\u1eeda\u00a0th\u00e0nh c\u00f4ng ch\u01b0a<\/strong><\/p>\n<p>\u0110\u1ec3 cho ch\u1eafc ch\u1eafn ch\u00fang ta n\u00ean c\u00f3 thao t\u00e1c ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u\u00a0\u0111\u1ec3 tr\u00e1nh vi\u1ec7c s\u1eeda b\u1ecb s\u00f3t, thi\u1ebfu.<\/p>\n<p>N\u00ean l\u01b0u tr\u1eef 1 b\u1ea3n copy d\u1eef li\u1ec7u g\u1ed1c\u00a0\u0111\u1ec3 tr\u00e1nh vi\u1ec7c l\u00e0m m\u1ea5t d\u1eef li\u1ec7u trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng Text trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c. \u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t \u0111\u1ea7y \u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong Excel \u0111\u1ec3 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel, \u0111\u0103ng k\u00fd b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o \u1ea3nh ph\u00eda d\u01b0\u1edbi:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-75.gif\" title=\"ex101_92019-nho-75\"><br \/>\n<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-75.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1090,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1089","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\/1089","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=1089"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1089\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1090"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}