{"id":4931,"date":"2024-12-08T15:01:37","date_gmt":"2024-12-08T15:01:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel\/"},"modified":"2024-12-08T15:01:37","modified_gmt":"2024-12-08T15:01:37","slug":"huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng Text trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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, H\u1ecdc\u00a0Excel Online 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\u00a0Excel\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\u00a0Excel 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 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-6755b4d0ef0f9\" 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-text-trong-excel.html#Bai_5_Huong_dan_cach_xu_ly_loi_du_lieu_dang_Text_trong_Excel\" title=\"B\u00e0i 5:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng\u00a0Text\u00a0trong\u00a0Excel\">B\u00e0i 5:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng\u00a0Text\u00a0trong\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-text-trong-excel.html#1_Cac_ky_thuat_tim_loi_ky_tu_Text\" title=\"1. C\u00e1c k\u1ef9 thu\u1eadt t\u00ecm l\u1ed7i k\u00fd t\u1ef1 Text\">1. C\u00e1c k\u1ef9 thu\u1eadt t\u00ecm l\u1ed7i k\u00fd t\u1ef1 Text<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel.html#a_Su_dung_AutoFilter\" title=\"a. S\u1eed d\u1ee5ng AutoFilter\">a. S\u1eed d\u1ee5ng AutoFilter<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel.html#b_Su_dung_chuc_nang_Conditional_Formatting_de_so_sanh_noi_dung_trong_bang_voi_1_danh_sach_da_co\" title=\"b. S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional Formatting\u00a0\u0111\u1ec3 so s\u00e1nh n\u1ed9i dung\u00a0trong b\u1ea3ng v\u1edbi 1 danh s\u00e1ch\u00a0\u0111\u00e3 c\u00f3\">b. S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional Formatting\u00a0\u0111\u1ec3 so s\u00e1nh n\u1ed9i dung\u00a0trong b\u1ea3ng v\u1edbi 1 danh s\u00e1ch\u00a0\u0111\u00e3 c\u00f3<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xu-ly-loi-du-lieu-dang-text-trong-excel.html#2_Cac_ky_thuat_sua_loi_du_lieu_Text\" title=\"2. C\u00e1c k\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u Text\">2. C\u00e1c k\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u Text<\/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-text-trong-excel.html#a_Su_dung_Replace_de_loai_bo_ky_tu_thua\" title=\"a. S\u1eed d\u1ee5ng Replace\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba\">a. S\u1eed d\u1ee5ng Replace\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba<\/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-text-trong-excel.html#b_Su_dung_bo_loc_de_loc_nhung_loi_phat_hien_boi_Conditional_Formatting\" title=\"b. S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc\u00a0\u0111\u1ec3 l\u1ecdc nh\u1eefng l\u1ed7i ph\u00e1t hi\u1ec7n b\u1edfi Conditional Formatting\">b. S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc\u00a0\u0111\u1ec3 l\u1ecdc nh\u1eefng l\u1ed7i ph\u00e1t hi\u1ec7n b\u1edfi Conditional Formatting<\/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-text-trong-excel.html#c_Su_dung_Remove_Duplicate_de_tao_danh_sach_khong_trung\" title=\"c. S\u1eed d\u1ee5ng Remove Duplicate\u00a0\u0111\u1ec3 t\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng\">c. S\u1eed d\u1ee5ng Remove Duplicate\u00a0\u0111\u1ec3 t\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng<\/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_5_Huong_dan_cach_xu_ly_loi_du_lieu_dang_Text_trong_Excel\"><\/span>B\u00e0i 5:\u00a0H\u01b0\u1edbng d\u1eabn\u00a0c\u00e1ch x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u\u00a0d\u1ea1ng\u00a0Text\u00a0trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>D\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i k\u00fd t\u1ef1 (Text) l\u00e0 d\u1ea1ng th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u0169ng th\u01b0\u1eddng m\u1eafc l\u1ed7i nh\u1ea5t trong qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u tr\u00ean\u00a0Excel. Nguy\u00ean nh\u00e2n ch\u1ee7 y\u1ebfu c\u1ee7a vi\u1ec7c n\u00e0y\u00a0c\u00f3 th\u1ec3 k\u1ec3 ra nh\u01b0:<\/p>\n<ul>\n<li>Th\u00f3i quen x\u1ea5u khi nh\u1eadp xong hay th\u00eam d\u1ea5u c\u00e1ch th\u1eeba \u1edf cu\u1ed1i k\u00fd t\u1ef1. V\u1ec1 hi\u1ec3n th\u1ecb ch\u00fang ta kh\u00f4ng th\u1ea5y d\u1ea5u c\u00e1ch th\u1eeba n\u00e0y, nh\u01b0ng\u00a0Excel\u00a0\u0111\u00e3 hi\u1ec3u vi\u1ec7c c\u00f3 d\u1ea5u c\u00e1ch hay kh\u00f4ng c\u00f3 d\u1ea5u c\u00e1ch l\u00e0 kh\u00e1c nhau v\u1ec1 n\u1ed9i dung c\u1ee7a to\u00e0n b\u1ed9 chu\u1ed7i k\u00fd t\u1ef1 trong\u00a0\u00f4.<\/li>\n<li>Kh\u00f4ng c\u1ea9n th\u1eadn trong vi\u1ec7c nh\u1eadp d\u1eef li\u1ec7u khi\u1ebfn nh\u1eadp sai ch\u00ednh t\u1ea3<\/li>\n<li>Thi\u1ebfu bi\u1ec7n ph\u00e1p ki\u1ec3m so\u00e1t qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u d\u1eabn t\u1edbi kh\u00f4ng bi\u1ebft nh\u1eadp\u00a0\u0111\u00fang hay sai,\u00a0\u0111\u1eb7c bi\u1ec7t v\u1edbi nh\u1eefng n\u1ed9i dung theo 1 danh s\u00e1ch cho tr\u01b0\u1edbc.<\/li>\n<\/ul>\n<p>Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 k\u1ef9 thu\u1eadt x\u1eed l\u00fd l\u1ed7i d\u1eef li\u1ec7u d\u1ea1ng Text trong\u00a0Excel, bao g\u1ed3m: T\u00ecm v\u1ecb tr\u00ed l\u1ed7i v\u00e0 k\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Cac_ky_thuat_tim_loi_ky_tu_Text\"><\/span>1. C\u00e1c k\u1ef9 thu\u1eadt t\u00ecm l\u1ed7i k\u00fd t\u1ef1 Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"a_Su_dung_AutoFilter\"><\/span>a. S\u1eed d\u1ee5ng AutoFilter<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng AutoFilter t\u00ecm l\u1ed7i k\u00fd t\u1ef1 d\u1ea1ng Date, Number th\u00ec AutoFilter c\u0169ng h\u1ed7 tr\u1ee3 ch\u00fang ta trong vi\u1ec7c t\u00ecm l\u1ed7i k\u00fd t\u1ef1 Text. D\u1ef1a theo quy lu\u1eadt hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u d\u1ea1ng Text trong AutoFilter nh\u01b0 sau:<\/p>\n<ul>\n<li>S\u1eafp x\u1ebfp t\u1ef1\u00a0\u0111\u1ed9ng\u00a0theo th\u1ee9 t\u1ef1 t\u1eeb A\u00a0\u0111\u1ebfn Z<\/li>\n<li>M\u1ed7i n\u1ed9i dung gi\u1ed1ng nhau s\u1ebd ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n tr\u00ean b\u1ed9 l\u1ecdc t\u1ef1\u00a0\u0111\u1ed9ng.<\/li>\n<\/ul>\n<p>D\u1ef1a tr\u00ean 2\u00a0\u0111\u1eb7c\u00a0\u0111i\u1ec3m n\u00e0y ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y d\u1eef li\u1ec7u Text b\u1ecb sai th\u01b0\u1eddng l\u00e0:<\/p>\n<ul>\n<li>L\u1eb7p l\u1ea1i nhi\u1ec1u l\u1ea7n tr\u00ean c\u00f9ng 1 v\u1ecb tr\u00ed k\u00fd t\u1ef1 (kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c g\u1ed9p t\u1ef1\u00a0\u0111\u1ed9ng)<\/li>\n<li>Kh\u00f4ng n\u1eb1m\u00a0\u0111\u00fang v\u1ecb tr\u00ed th\u1ee9 t\u1ef1\u00a0k\u00fd t\u1ef1<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17193\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-autofilter-text-01.png\" width=\"650\" height=\"543\" title=\"heo-autofilter-text-01\"><\/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-408.gif\" title=\"ex101_92019-nho-408\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta th\u1ea5y t\u00ean \u201c\u0110\u00e0o Thanh Th\u00fay\u201d xu\u1ea5t hi\u1ec7n 2 l\u1ea7n b\u1edfi trong n\u1ed9i dung n\u00e0y c\u00f3 xu\u1ea5t hi\u1ec7n d\u1ea5u c\u00e1ch th\u1eeba<\/p>\n<h4><span class=\"ez-toc-section\" id=\"b_Su_dung_chuc_nang_Conditional_Formatting_de_so_sanh_noi_dung_trong_bang_voi_1_danh_sach_da_co\"><\/span>b. S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional Formatting\u00a0\u0111\u1ec3 so s\u00e1nh n\u1ed9i dung\u00a0trong b\u1ea3ng v\u1edbi 1 danh s\u00e1ch\u00a0\u0111\u00e3 c\u00f3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Gi\u1ea3 s\u1eed\u00a0\u1edf\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 1 danh s\u00e1ch nh\u00e2n vi\u00ean t\u1ea1i c\u1ed9t G<\/p>\n<p>S\u1eed d\u1ee5ng Conditional Formatting\u00a0\u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u nh\u1eadp v\u00e0o\u00a0\u1edf c\u1ed9t B v\u1edbi d\u1eef li\u1ec7u\u00a0\u1edf c\u1ed9t G nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17194\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-autofilter-text-02.png\" width=\"1050\" height=\"492\" title=\"heo-autofilter-text-02\"><\/p>\n<p>S\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm m\u1ed7i gi\u00e1 tr\u1ecb\u00a0\u1edf c\u1ed9t B (b\u1eaft \u0111\u1ea7u t\u1eeb B2), so s\u00e1nh trong v\u00f9ng danh s\u00e1ch\u00a0\u1edf c\u1ed9t G (c\u1ed1\u00a0\u0111\u1ecbnh v\u00f9ng G2:G7)<\/p>\n<p>Khi\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17195\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-autofilter-text-03.png\" width=\"654\" height=\"193\" title=\"heo-autofilter-text-03\"><\/p>\n<p>\u1ede\u00a0\u00f4 B6 kh\u00f4ng t\u00ecm th\u1ea5y trong danh s\u00e1ch n\u00ean kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ecbnh d\u1ea1ng t\u00f4 m\u00e0u<\/p>\n<p><strong>\u0110\u1ec3 l\u00e0m ng\u01b0\u1ee3c l\u1ea1i: T\u00ean sai th\u00ec t\u00f4 m\u00e0u<\/strong><\/p>\n<p>S\u1eeda c\u00f4ng th\u1ee9c trong Conditional Formatting nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=COUNTIF($G$2:$G$7,$B2)=0<\/p>\n<p>T\u1ee9c l\u00e0: n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y theo danh s\u00e1ch th\u00ec s\u1ebd t\u00f4 m\u00e0u (Kh\u00f4ng t\u00ecm th\u1ea5y t\u1ee9c l\u00e0 k\u1ebft qu\u1ea3 h\u00e0m COUNTIF = 0)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Cac_ky_thuat_sua_loi_du_lieu_Text\"><\/span>2. C\u00e1c k\u1ef9 thu\u1eadt s\u1eeda l\u1ed7i d\u1eef li\u1ec7u Text<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi s\u1eeda l\u1ed7i d\u1eef li\u1ec7u, ch\u00fang ta c\u1ea7n tu\u00e2n th\u1ee7 1 nguy\u00ean t\u1eafc: Copy d\u1eef li\u1ec7u r\u1ed3i s\u1eeda tr\u00ean b\u1ea3n Copy. Sau khi ki\u1ec3m tra l\u1ea1i k\u1ebft qu\u1ea3 s\u1eeda\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh th\u00ec m\u1edbi Copy k\u1ebft qu\u1ea3\u00a0\u0111\u00fang tr\u1ea3 v\u1ec1 b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch: Tr\u00e1nh vi\u1ec7c m\u1ea5t d\u1eef li\u1ec7u g\u1ed1c khi thao t\u00e1c s\u1eeda ch\u01b0a ho\u00e0n thi\u1ec7n s\u1ebd kh\u00f4ng c\u00f3 c\u0103n c\u1ee9\u00a0\u0111\u1ed1i chi\u1ebfu, so s\u00e1nh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"a_Su_dung_Replace_de_loai_bo_ky_tu_thua\"><\/span>a. S\u1eed d\u1ee5ng Replace\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf k\u00fd t\u1ef1 th\u1eeba<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17206\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-find-replace-01.png\" width=\"669\" height=\"251\" title=\"heo-find-replace-01\"><\/p>\n<p>Nh\u1eefng k\u00fd t\u1ef1 th\u1eeba nh\u01b0\u00a0c\u00e1c d\u1ea5u ( . , \/ \u2018 ; ) m\u00e0 trong qu\u00e1 tr\u00ecnh nh\u1eadp d\u1eef li\u1ec7u do b\u1ea5t c\u1ea9n th\u00eam v\u00e0o th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 x\u00f3a b\u1ecf b\u1eb1ng c\u00e1ch:<\/p>\n<ul>\n<li>Find\u00a0what: Nh\u1eadp k\u00fd t\u1ef1 c\u1ea7n x\u00f3a b\u1ecf<\/li>\n<li>Replace\u00a0with: kh\u00f4ng nh\u1eadp n\u1ed9i dung g\u00ec<\/li>\n<\/ul>\n<p>B\u1ea5m Replace All<\/p>\n<h4><span class=\"ez-toc-section\" id=\"b_Su_dung_bo_loc_de_loc_nhung_loi_phat_hien_boi_Conditional_Formatting\"><\/span>b. S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc\u00a0\u0111\u1ec3 l\u1ecdc nh\u1eefng l\u1ed7i ph\u00e1t hi\u1ec7n b\u1edfi Conditional Formatting<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>S\u1eed d\u1ee5ng AutoFilter v\u00e0 t\u1eadn d\u1ee5ng ch\u1ee9c n\u0103ng l\u1ecdc theo m\u00e0u\u00a0\u0111\u1ec3 l\u1ecdc nh\u1eefng n\u1ed9i dung l\u1ed7i\u00a0\u0111\u01b0\u1ee3c ph\u00e1t hi\u1ec7n b\u1edfi ch\u1ee9c n\u0103ng Conditional Formatting\u00a0\u0111\u00e3 tr\u00ecnh b\u00e0y\u00a0\u1edf tr\u00ean: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng L\u1ecdc theo m\u00e0u trong AutoFilter<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17207\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-filter-by-colour-01.png\" width=\"475\" height=\"496\" title=\"heo-filter-by-colour-01\"><\/p>\n<p>Sau khi l\u1ecdc ra nh\u1eefng n\u1ed9i dung l\u1ed7i ch\u00fang ta c\u00f3 th\u1ec3 s\u1eeda tr\u1ef1c ti\u1ebfp b\u1eb1ng tay.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"c_Su_dung_Remove_Duplicate_de_tao_danh_sach_khong_trung\"><\/span>c. S\u1eed d\u1ee5ng Remove Duplicate\u00a0\u0111\u1ec3 t\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Theo nguy\u00ean t\u1eafc D\u1eef li\u1ec7u \u0111\u00fang\u00a0th\u00ec kh\u00f4ng\u00a0xu\u1ea5t hi\u1ec7n 2 l\u1ea7n trong danh s\u00e1ch c\u1ee7a AutoFilter n\u00ean ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1<\/strong>:\u00a0S\u1eafp x\u1ebfp danh s\u00e1ch c\u1ea7n s\u1eeda theo th\u1ee9 t\u1ef1 t\u1eeb A\u00a0\u0111\u1ebfn Z v\u1edbi c\u00f4ng c\u1ee5 <strong>Sort<\/strong> trong tab <strong>Data<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17208\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-sort-a-z.png\" width=\"346\" height=\"156\" title=\"heo-data-sort-a-z\"><\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 2<\/strong>: L\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng v\u1edbi c\u00f4ng c\u1ee5 <strong>Remove Duplicate<\/strong> trong tab <strong>Data<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17209\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-data-remove-dupplicate-1.png\" width=\"710\" height=\"152\" title=\"heo-data-remove-dupplicate-1\"><\/p>\n<p>Sau m\u1ed7i 1 l\u1ea7n l\u1ecdc b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng, ch\u00fang ta s\u1ebd thu\u00a0\u0111\u01b0\u1ee3c 1 danh s\u00e1ch m\u1edbi ch\u1ec9 bao g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng.<\/p>\n<p>N\u1ebfu danh s\u00e1ch\u00a0\u0111\u00f3 v\u1eabn c\u00f2n l\u1ed7i th\u00ec ti\u1ebfp t\u1ee5c s\u1eeda &gt; S\u1eafp x\u1ebfp &gt; Lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng cho t\u1edbi khi thu\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch kh\u00f4ng tr\u00f9ng v\u00e0 kh\u00f4ng c\u00f3 l\u1ed7i.<\/p>\n<p>Khi ho\u00e0n th\u00e0nh b\u01b0\u1edbc n\u00e0y th\u00ec ch\u00fang ta ki\u1ec3m tra l\u1ea1i tr\u00ean danh s\u00e1ch g\u1ed1c\u00a0\u0111\u1ec3\u00a0\u0111\u1ed1i chi\u1ebfu v\u1edbi danh s\u00e1ch kh\u00f4ng tr\u00f9ng theo\u00a0c\u00e1ch s\u1eed d\u1ee5ng Conditional formatting\u00a0\u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u trong b\u1ea3ng v\u1edbi danh s\u00e1ch b\u00ean ngo\u00e0i =&gt; Ph\u00e1t hi\u1ec7n v\u1ecb tr\u00ed l\u1ed7i =&gt; L\u1ecdc c\u00e1c v\u1ecb tr\u00ed l\u1ed7i v\u00e0 s\u1eeda.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ky-thuat-loai-bo-gia-tri-trung-lap-trong-danh-sach-excel.html\">K\u1ef9 thu\u1eadt lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p trong danh s\u00e1ch<\/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.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\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\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\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\u00a0Excel.<\/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-408.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4931","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\/4931","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=4931"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4931\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4932"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}