{"id":5119,"date":"2024-12-09T07:00:00","date_gmt":"2024-12-09T07:00:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-tu-dong-phat-hien-noi-dung-xuat-hien-dong-thoi-o-nhieu-sheet\/"},"modified":"2024-12-09T07:00:00","modified_gmt":"2024-12-09T07:00:00","slug":"huong-dan-cach-tu-dong-phat-hien-noi-dung-xuat-hien-dong-thoi-o-nhieu-sheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-tu-dong-phat-hien-noi-dung-xuat-hien-dong-thoi-o-nhieu-sheet\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111\u1ed9ng ph\u00e1t hi\u1ec7n n\u1ed9i dung xu\u1ea5t hi\u1ec7n \u0111\u1ed3ng th\u1eddi \u1edf nhi\u1ec1u sheet"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u00a0<\/p>\n<p>V\u1eeba r\u1ed3i H\u1ecdc\u00a0Excel Online c\u00f3 nh\u1eadn\u00a0\u0111\u01b0\u1ee3c 1 c\u00e2u h\u1ecfi r\u1eb1ng: L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng ph\u00e1t hi\u1ec7n n\u1ed9i dung xu\u1ea5t hi\u1ec7n\u00a0\u0111\u1ed3ng th\u1eddi\u00a0\u1edf nhi\u1ec1u Sheet. C\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p>C\u00f3 2 Sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14950\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cf-nhie1bb81u-sheet-01.png\" width=\"544\" height=\"642\" title=\"heo-cf-nhie1bb81u-sheet-01\"><\/p>\n<p>L\u00e0m c\u00e1ch n\u00e0o\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng ph\u00e2n bi\u1ec7t\u00a0\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf Sheet2 nh\u1eefng m\u00e3 n\u00e0o c\u00f3 xu\u1ea5t hi\u1ec7n c\u1ea3 trong\u00a0Sheet1?<\/p>\n<p>Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u01b0 sau:<\/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-6756956f22bdc\" 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\/huong-dan-cach-tu-dong-phat-hien-noi-dung-xuat-hien-dong-thoi-o-nhieu-sheet.html#1_Phan_tich_yeu_cau\" title=\"1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u\">1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tu-dong-phat-hien-noi-dung-xuat-hien-dong-thoi-o-nhieu-sheet.html#2_Cach_thuc_hien\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau\"><\/span>1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u1ede\u00a0\u0111\u00e2y c\u1ea7n hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c\u00a0\u00fd ngh\u0129a c\u1ee7a c\u00e2u: \u201c<em>T\u1ef1\u00a0\u0111\u1ed9ng\u00a0ph\u00e2n bi\u1ec7t\u00a0\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf Sheet2 nh\u1eefng m\u00e3 n\u00e0o c\u00f3 xu\u1ea5t hi\u1ec7n c\u1ea3 trong\u00a0Sheet1<\/em>\u201c<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-170.gif\" title=\"vba101_92019-nho-170\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-433.gif\" title=\"ex101_92019-nho-433\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Bao g\u1ed3m:<\/p>\n<ul>\n<li>Th\u1ee9 1: So s\u00e1nh t\u1eebng m\u00e3 trong danh s\u00e1ch \u1edf Sheet2 v\u1edbi danh s\u00e1ch\u00a0\u1edf Sheet1<\/li>\n<li>Th\u1ee9 2: M\u00e3 n\u00e0o c\u00f3 xu\u1ea5t hi\u1ec7n\u00a0\u1edf\u00a0Sheet1 s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng ph\u00e2n bi\u1ec7t (b\u1eb1ng\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0u) trong danh s\u00e1ch sheet2<\/li>\n<\/ul>\n<p>V\u1edbi y\u00eau c\u1ea7u th\u1ee9 1, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTIF\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c so s\u00e1nh<\/p>\n<p>V\u1edbi y\u00eau c\u1ea7u th\u1ee9 2, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Conditional formatting trong\u00a0Excel\u00a0\u0111\u1ec3 gi\u00fap t\u1ef1\u00a0\u0111\u1ed9ng c\u1ea3nh b\u00e1o<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Cach_thuc_hien\"><\/span>2. C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>2.1. S\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/strong><\/p>\n<p>(Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTIF<\/a>)<\/p>\n<p>Ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m Countif nh\u01b0 sau:<\/p>\n<ul>\n<li>Range: x\u00e9t t\u1edbi danh s\u00e1ch\u00a0\u1edf Sheet1, c\u1ee5 th\u1ec3 l\u00e0 Sheet1!A2:A15. V\u00f9ng n\u00e0y s\u1ebd c\u1ed1\u00a0\u0111\u1ecbnh trong c\u00f4ng th\u1ee9c v\u00ec lu\u00f4n tham chi\u1ebfu t\u1edbi v\u00f9ng n\u00e0y.<\/li>\n<li>Criteria: m\u1ed7i n\u1ed9i dung trong Sheet2 s\u1ebd l\u00e0 1\u00a0\u0111i\u1ec1u ki\u1ec7n, n\u00ean s\u1ebd\u00a0\u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c theo t\u1eebng n\u1ed9i dung.<\/li>\n<\/ul>\n<p>T\u1ea1i c\u1ed9t B c\u1ee7a Sheet2 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c COUNTIF\u00a0thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14951\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cf-nhie1bb81u-sheet-03.png\" width=\"596\" height=\"634\" title=\"heo-cf-nhie1bb81u-sheet-03\"><\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi nh\u1eefng\u00a0\u00f4 c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 1 th\u00ec l\u00e0 tr\u00f9ng v\u1edbi danh s\u00e1ch t\u1ea1i Sheet1<\/p>\n<p><strong>2.2. S\u1eed d\u1ee5ng Conditional formatting\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng c\u1ea3nh b\u00e1o<\/strong><\/p>\n<p>(Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/21-%E2%97%8F-dinh-dang-du-lieu-theo-dieu-kien-trong-excel-su-dung-conditional-formatting.html\">Ch\u1ee9c n\u0103ng Conditional formatting trong Excel<\/a>)<\/p>\n<p>\u0110\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng c\u1ea3nh b\u00e1o trong danh s\u00e1ch\u00a0\u1edf Sheet2, v\u00f9ng A2:A26 ch\u00fang ta s\u1ebd\u00a0\u00e1p d\u1ee5ng Conditional formatting cho v\u00f9ng n\u00e0y.<\/p>\n<p>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng A2:A26 t\u1ea1i Sheet2, b\u1ea5m ch\u1ecdn ch\u1ee9c n\u0103ng Conditional formatting trong tab HOME<\/p>\n<p><strong><em>* Tr\u01b0\u1eddng h\u1ee3p\u00a0\u00e1p d\u1ee5ng h\u00e0m Countif trong c\u1ed9t ph\u1ee5 l\u00e0 c\u1ed9t B<\/em><\/strong><\/p>\n<p>X\u00e9t gi\u00e1 tr\u1ecb n\u00e0o\u00a0\u1edf c\u1ed9t B b\u1eb1ng 1 th\u00ec s\u1ebd\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0u cho n\u1ed9i dung t\u01b0\u01a1ng\u00a0\u1ee9ng\u00a0\u1edf c\u1ed9t A:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14952\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cf-nhie1bb81u-sheet-04.png\" width=\"1034\" height=\"642\" title=\"heo-cf-nhie1bb81u-sheet-04\"><\/p>\n<p>Ch\u00fa\u00a0\u00fd: c\u00f4ng th\u1ee9c trong Conditional formatting l\u00e0 =$B2=1 (\u00f4 B2 ch\u1ec9 c\u1ed1\u00a0\u0111\u1ecbnh c\u1ed9t m\u00e0 kh\u00f4ng c\u1ed1\u00a0\u0111\u1ecbnh d\u00f2ng, nh\u01b0 v\u1eady s\u1ebd hi\u1ec3u l\u00e0 x\u00e9t t\u1eebng n\u1ed9i dung\u00a0\u1edf c\u1ed9t B, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb d\u00f2ng 2)<\/p>\n<p><strong><em>* Tr\u01b0\u1eddng h\u1ee3p\u00a0\u00e1p d\u1ee5ng tr\u1ef1c ti\u1ebfp h\u00e0m COUNTIF trong Conditional formatting<\/em><\/strong><\/p>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y kh\u00f4ng c\u1ea7n t\u1edbi c\u1ed9t ph\u1ee5 m\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ngay c\u00f4ng th\u1ee9c countif trong ph\u1ea7n vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a Conditional formatting nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14953\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-cf-nhie1bb81u-sheet-05.png\" width=\"634\" height=\"635\" title=\"heo-cf-nhie1bb81u-sheet-05\"><\/p>\n<p>C\u1ea3 2 c\u00e1ch vi\u1ebft\u00a0\u0111i\u1ec1u ki\u1ec7n trong Conditional formatting\u00a0\u0111\u1ec1u\u00a0\u0111\u00fang.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 thu\u00a0\u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 mong mu\u1ed1n r\u1ed3i.<\/p>\n<p>T\u00e0i li\u1ec7u k\u00e8m theo:\u00a0<a href=\"http:\/\/bit.ly\/2v8GcDn\">http:\/\/bit.ly\/2v8GcDn<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>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<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-170.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5120,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5119","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\/5119","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=5119"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5119\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5120"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}