{"id":8994,"date":"2024-12-31T08:50:11","date_gmt":"2024-12-31T08:50:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/cach-xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel\/"},"modified":"2024-12-31T08:50:11","modified_gmt":"2024-12-31T08:50:11","slug":"cach-xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/31\/cach-xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel\/","title":{"rendered":"C\u00e1ch x\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u xem l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 h\u1ec3 x\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c cho s\u1eb5n trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/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-6773b042bb693\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel.html#Xoa_dong_thoi_nhieu_dong_theo_dieu_kien_bang_tinh_nang_Find_Replace\" title=\"X\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng t\u00ednh n\u0103ng Find &amp; Replace\">X\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng t\u00ednh n\u0103ng Find &amp; Replace<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel.html#Su_dung_chuc_nang_Find\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find:\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/xoa-dong-thoi-nhieu-dong-theo-dieu-kien-trong-excel.html#Xoa_dong_da_chon_bang_chuc_nang_Delete_Row\" title=\"X\u00f3a d\u00f2ng \u0111\u00e3 ch\u1ecdn b\u1eb1ng ch\u1ee9c n\u0103ng Delete Row\">X\u00f3a d\u00f2ng \u0111\u00e3 ch\u1ecdn b\u1eb1ng ch\u1ee9c n\u0103ng Delete Row<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_dong_thoi_nhieu_dong_theo_dieu_kien_bang_tinh_nang_Find_Replace\"><\/span>X\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng t\u00ednh n\u0103ng Find &amp; Replace<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t trong nh\u1eefng c\u00f4ng d\u1ee5ng c\u1ee7a ch\u1ee9c n\u0103ng Find &amp; Replace trong Excel, \u0111\u00f3 l\u00e0 gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng l\u1ef1a ch\u1ecdn \u00f4 theo \u0111i\u1ec1u ki\u1ec7n d\u1ec5 d\u00e0ng. Ta s\u1ebd \u0111\u1ebfn v\u1edbi v\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26120\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-1.png\" width=\"410\" height=\"301\" title=\"xoa-dong-theo-dieu-kien-1\"><\/p>\n<p>C\u00f4ng vi\u1ec7c c\u1ee7a ta l\u00e0 x\u00f3a \u0111i nh\u1eefng d\u00f2ng \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta theo t\u00e1c nh\u01b0 sau:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_Find\"><\/span>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Find:<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<figure id=\"attachment_26122\" aria-describedby=\"caption-attachment-26122\" style=\"width: 309px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26122 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-2.png\" width=\"309\" height=\"352\" title=\"xoa-dong-theo-dieu-kien-2\"><figcaption id=\"caption-attachment-26122\" class=\"wp-caption-text\">Ph\u00edm t\u1eaft Ctrl + F<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>Khi h\u1ed9p tho\u1ea1i Find and Replace xu\u1ea5t hi\u1ec7n, t\u1ea1i m\u1ee5c Find What nh\u1eadp\u00a0\u0111i\u1ec1u ki\u1ec7n, c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0\u00a0<strong>X\u00f3a<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Find All.<\/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-846.gif\" title=\"ex101_92019-nho-846\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26123\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-3.png\" width=\"450\" height=\"295\" title=\"xoa-dong-theo-dieu-kien-3\"><\/p>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 \u00f4 trong danh s\u00e1ch d\u01b0\u1edbi b\u1eb1ng c\u00e1ch gi\u1eef Shift r\u1ed3i click v\u00e0o \u00f4 cu\u1ed1i. Sau \u0111\u00f3 \u1ea5n\u00a0<strong>Close.<\/strong><\/p>\n<p>Khi \u0111\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd nh\u00ecn nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26124\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-4.png\" width=\"410\" height=\"301\" title=\"xoa-dong-theo-dieu-kien-4\"><\/p>\n<p>B\u1ea1n co th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html\"><strong>x\u00f3a d\u00f2ng tr\u1ed1ng trong Excel<\/strong><\/a> m\u1ed9t c\u00e1ch nhanh ch\u00f3ng h\u01a1n<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Xoa_dong_da_chon_bang_chuc_nang_Delete_Row\"><\/span>X\u00f3a d\u00f2ng \u0111\u00e3 ch\u1ecdn b\u1eb1ng ch\u1ee9c n\u0103ng Delete Row<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Sau khi \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c nh\u01b0 tr\u00ean, ti\u1ebfp theo ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0<strong>Delete Row<\/strong> trong th\u1ebb\u00a0<strong>Home,\u00a0<\/strong>nh\u00f3m\u00a0<strong>Cells<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26125\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-5.png\" width=\"239\" height=\"182\" title=\"xoa-dong-theo-dieu-kien-5\"><\/p>\n<p>T\u1ea1i \u0111\u00e2y, ch\u1ecdn\u00a0<strong>Delete Sheet Rows<\/strong>.<\/p>\n<figure id=\"attachment_26126\" aria-describedby=\"caption-attachment-26126\" style=\"width: 411px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26126 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-dong-theo-dieu-kien-6.png\" width=\"411\" height=\"221\" title=\"xoa-dong-theo-dieu-kien-6\"><figcaption id=\"caption-attachment-26126\" class=\"wp-caption-text\">V\u00e0 k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch x\u00f3a \u0111\u1ed3ng th\u1eddi nhi\u1ec1u d\u00f2ng theo \u0111i\u1ec1u ki\u1ec7n trong Excel r\u1ed3i. Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-xoa-dong-neu-dong-chua-gia-tri-0.html\"><strong>X\u00f3a d\u00f2ng ch\u1ee9a gi\u00e1 tr\u1ecb 0 trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html\"><strong>X\u00f3a\u00a0d\u00f2ng tr\u1ed1ng nhanh ch\u00f3ng<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/find-va-replace-nang-cao-trong-excel-cach-su-dung-hieu-qua-nhat.html\"><strong>S\u1eed d\u1ee5ng Find &amp; Replace trong Excel<\/strong><\/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-846.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8995,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8994","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=8994"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8995"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}