{"id":8684,"date":"2024-12-24T17:01:30","date_gmt":"2024-12-24T17:01:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-cach-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel\/"},"modified":"2024-12-24T17:01:30","modified_gmt":"2024-12-24T17:01:30","slug":"huong-dan-cach-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/huong-dan-cach-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc ri\u00eang s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong 1 c\u1ed9t ch\u1ee9a nhi\u1ec1u s\u1ed1 kh\u00e1c nhau, l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ph\u00e2n bi\u1ec7t\u00a0\u0111\u01b0\u1ee3c s\u1ed1 n\u00e0o l\u00e0 s\u1ed1 nguy\u00ean, s\u1ed1 n\u00e0o c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n? Hay cao h\u01a1n l\u00e0 l\u1ecdc ri\u00eang s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n, l\u1ecdc ri\u00eang c\u00e1c s\u1ed1 nguy\u00ean b\u1eb1ng c\u00f4ng c\u1ee5 Filter trong\u00a0Excel? Ch\u00fang ta h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a>\u00a0\u0111i t\u00ecm l\u1eddi gi\u1ea3i cho nh\u1eefng c\u00e2u h\u1ecfi n\u00e0y nh\u00e9.<\/em><\/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-676ae8e94e462\" 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-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel.html#Cach_loc_rieng_so_co_phan_thap_phan_trong_bang_tinh_Excel\" title=\"C\u00e1ch l\u1ecdc ri\u00eang s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh Excel\">C\u00e1ch l\u1ecdc ri\u00eang s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh 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\/huong-dan-cach-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel.html#Dinh_dang_so_co_phan_thap_phan\" title=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n<\/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-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel.html#Cong_thuc_tach_rieng_phan_thap_phan_khoi_mot_so\" title=\"C\u00f4ng th\u1ee9c t\u00e1ch ri\u00eang ph\u1ea7n th\u1eadp ph\u00e2n kh\u1ecfi m\u1ed9t s\u1ed1\">C\u00f4ng th\u1ee9c t\u00e1ch ri\u00eang ph\u1ea7n th\u1eadp ph\u00e2n kh\u1ecfi m\u1ed9t s\u1ed1<\/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-loc-rieng-so-co-phan-thap-phan-trong-bang-tinh-excel.html#Loc_so_co_phan_thap_phan_bang_AutoFilter\" title=\"L\u1ecdc s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n b\u1eb1ng AutoFilter\">L\u1ecdc s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n b\u1eb1ng AutoFilter<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_rieng_so_co_phan_thap_phan_trong_bang_tinh_Excel\"><\/span>C\u00e1ch l\u1ecdc ri\u00eang s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Dinh_dang_so_co_phan_thap_phan\"><\/span>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t c\u00e1ch\u00a0\u0111\u01a1n gi\u1ea3n\u00a0\u0111\u1ec3 ph\u00e2n bi\u1ec7t s\u1ed1 nguy\u00ean v\u1edbi s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n l\u00e0 d\u1ef1a v\u00e0o\u00a0\u0111\u1ecbnh d\u1ea1ng. V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 1 d\u00e3y s\u1ed1 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27288\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/day-so-dinh-dang-number-decimal-places-0.png\" width=\"129\" height=\"258\" title=\"day-so-dinh-dang-number-decimal-places-0\"><\/p>\n<p>D\u00e3y s\u1ed1 tr\u00ean tho\u1ea1t nh\u00ecn t\u01b0\u1edfng nh\u01b0\u00a0\u0111\u1ec1u l\u00e0 s\u1ed1 nguy\u00ean, kh\u00f4ng c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n. Nh\u01b0ng b\u1ea1n h\u00e3y ch\u00fa\u00a0\u00fd t\u1edbi\u00a0\u0111\u1ecbnh d\u1ea1ng (format cells) c\u1ee7a nh\u1eefng\u00a0\u00f4 trong v\u00f9ng A2:A10, b\u1edfi n\u1ebfu thi\u1ebft l\u1eadp d\u1ea1ng Number v\u1edbi Decimal places = 0 th\u00ec b\u1ea1n s\u1ebd kh\u00f4ng nh\u00ecn th\u1ea5y ph\u1ea7n th\u1eadp ph\u00e2n c\u1ee7a c\u00e1c s\u1ed1\u00a0\u0111\u00f3. H\u00e3y nh\u00ecn h\u00ecnh b\u00ean d\u01b0\u1edbi b\u1ea1n s\u1ebd th\u1ea5y\u00a0\u0111i\u1ec1u\u00a0\u0111\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27289\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/check-format-cell-number.png\" width=\"811\" height=\"322\" title=\"check-format-cell-number\"><\/p>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c 1 s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n hay kh\u00f4ng, b\u1ea1n c\u1ea7n\u00a0\u0111\u1ecbnh d\u1ea1ng cho ph\u00e9p nh\u00ecn th\u1ea5y ph\u1ea7n th\u1eadp ph\u00e2n. S\u1eed d\u1ee5ng\u00a0\u0111\u1ecbnh d\u1ea1ng General ho\u1eb7c d\u00f9ng s\u1ed1 &gt;0 trong m\u1ee5c Decimal places.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u1edf d\u1ea1ng General nh\u01b0 sau:<\/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-807.gif\" title=\"ex101_92019-nho-807\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27290\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-lai-day-so-bang-general-de-nhin-thay-phan-thap-phan.png\" width=\"816\" height=\"284\" title=\"dinh-dang-lai-day-so-bang-general-de-nhin-thay-phan-thap-phan\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cong_thuc_tach_rieng_phan_thap_phan_khoi_mot_so\"><\/span>C\u00f4ng th\u1ee9c t\u00e1ch ri\u00eang ph\u1ea7n th\u1eadp ph\u00e2n kh\u1ecfi m\u1ed9t s\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Format cells v\u1ec1 b\u1ea3n ch\u1ea5t ch\u1ec9 l\u00e0m thay\u00a0\u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c d\u01b0\u1edbi\u00a0\u0111\u00e2y\u00a0\u0111\u1ec3 t\u00e1ch ri\u00eang ph\u1ea7n th\u1eadp ph\u00e2n v\u00e0 ph\u1ea7n s\u1ed1 nguy\u00ean c\u1ee7a 1 s\u1ed1 nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u00e1ch ph\u1ea7n s\u1ed1 nguy\u00ean b\u1eb1ng h\u00e0m TRUNC ho\u1eb7c<a href=\"http:\/\/blog.ezworkapp.com\/ham-int-ham-lay-phan-nguyen-trong-excel.html\"><strong> h\u00e0m INT<\/strong><\/a><\/p>\n<p style=\"padding-left: 30px\">H\u00e0m TRUNC c\u00f3 t\u00e1c d\u1ee5ng c\u1eaft b\u1ecf to\u00e0n b\u1ed9 ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n, ch\u1ec9 gi\u1eef l\u1ea1i ph\u1ea7n s\u1ed1 nguy\u00ean<\/p>\n<p style=\"padding-left: 30px\">H\u00e0m INT c\u00f3 t\u00e1c d\u1ee5ng l\u00e0m tr\u00f2n xu\u1ed1ng t\u1edbi s\u1ed1\u00a0nguy\u00ean g\u1ea7n nh\u1ea5t.<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: T\u00e1ch ph\u1ea7n s\u1ed1 th\u1eadp ph\u00e2n b\u1eb1ng c\u00e1ch l\u1ea5y s\u1ed1 ban\u00a0\u0111\u1ea7u tr\u1eeb\u00a0\u0111i k\u1ebft qu\u1ea3 c\u1ee7a b\u01b0\u1edbc 1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27297\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-phan-thap-phan-so-nguyen.png\" width=\"417\" height=\"353\" title=\"tach-phan-thap-phan-so-nguyen\"><\/p>\n<p>Nh\u01b0 v\u1eady nh\u1eefng s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n (decimal places) =\u00a00 l\u00e0 s\u1ed1 nguy\u00ean, tr\u00f2n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loc_so_co_phan_thap_phan_bang_AutoFilter\"><\/span>L\u1ecdc s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n b\u1eb1ng AutoFilter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc ri\u00eang nh\u1eefng s\u1ed1\u00a0c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n b\u1eb1ng c\u00f4ng c\u1ee5 Auto Filter (b\u1ed9 l\u1ecdc t\u1ef1\u00a0\u0111\u1ed9ng c\u1ee7a\u00a0Excel) th\u00ec ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>B\u01b0\u1edbc 1:\u00a0\u00c1p d\u1ee5ng Auto Filter tr\u00ean v\u00f9ng A1:C10<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-27298\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/thiet-lap-auto-filter-1024x435-1.png\" width=\"1024\" height=\"435\" title=\"thiet-lap-auto-filter-1024x435-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Khi\u00a0\u0111\u00f3 ch\u00fang ta ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n l\u1ecdc trong c\u1ed9t Decimal places, ch\u1ecdn\u00a0\u0111i\u1ec1u ki\u1ec7n l\u1ecdc l\u00e0 gi\u00e1 tr\u1ecb &gt; 0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27299\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dieu-kien-loc-auto-filter.png\" width=\"956\" height=\"276\" title=\"dieu-kien-loc-auto-filter\"><\/p>\n<p>Khi\u00a0\u0111\u00f3 k\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 nh\u1eefng s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n (trong c\u1ed9t A)<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft th\u00fa v\u1ecb kh\u00e1c v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-du-lieu-trong-excel.html\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-filter-trong-excel-office-365.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER trong Excel Office 365<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-ket-qua-loc-autofilter-voi-ham-subtotal.html\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3 l\u1ecdc Autofilter v\u1edbi h\u00e0m Subtotal<\/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-807.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8684","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\/8684","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=8684"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8684\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8685"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}