{"id":106804,"date":"2024-11-28T15:26:08","date_gmt":"2024-11-28T08:26:08","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=106804"},"modified":"2024-12-03T10:54:15","modified_gmt":"2024-12-03T03:54:15","slug":"loc-trung-trong-excel-google-sheet","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/","title":{"rendered":"10 c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel, Google Sheet \u0111\u01a1n gi\u1ea3n nh\u1ea5t 2024"},"content":{"rendered":"\n<p>L\u1ecdc tr\u00f9ng trong Excel l\u00e0 m\u1ed9t thao t\u00e1c quen thu\u1ed9c v\u1edbi nh\u1eefng ai l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Vi\u1ec7c lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u s\u1ea1ch s\u1ebd, ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng ph\u00e2n t\u00edch h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/phongvu.vn\/cong-nghe\/\">Phong V\u0169 Tech News<\/a> s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n 10 c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u00e0 Google Sheets, t\u1eeb nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p c\u01a1 b\u1ea3n \u0111\u1ebfn nh\u1eefng th\u1ee7 thu\u1eadt n\u00e2ng cao, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c.<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-sumif-trong-excel-cu-phap-cach-su-dung\/\">H\u00e0m Sumif trong Excel: C\u00fa ph\u00e1p, c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda 2024<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/ham-match-trong-excel\/\">H\u00e0m MATCH trong Excel \u2013 H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5 d\u1ec5 hi\u1ec3u nh\u1ea5t<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/phongvu.vn\/cong-nghe\/cach-xuong-dong-trong-excel-google-sheet\/\">H\u01b0\u1edbng d\u1eabn xu\u1ed1ng d\u00f2ng trong Excel v\u00e0 Google Sheets \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a1a86164c076\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a1a86164c076\"  type=\"checkbox\" id=\"item-6a1a86164c076\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Tai_sao_nen_loc_cac_du_lieu_bi_trung\" title=\"T\u1ea1i sao n\u00ean l\u1ecdc c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng?\">T\u1ea1i sao n\u00ean l\u1ecdc c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Cach_loc_trung_trong_Excel_nhanh_chong_de_thuc_hien\" title=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng, d\u1ec5 th\u1ef1c hi\u1ec7n\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng, d\u1ec5 th\u1ef1c hi\u1ec7n<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Dung_cong_cu_Remove_Duplicates\" title=\"D\u00f9ng c\u00f4ng c\u1ee5 Remove Duplicates\">D\u00f9ng c\u00f4ng c\u1ee5 Remove Duplicates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Cach_loc_trung_trong_Excel_bang_Conditional_Formatting\" title=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Conditional Formatting&nbsp;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Conditional Formatting&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Dung_tinh_nang_Advanced_Filter\" title=\"D\u00f9ng t\u00ednh n\u0103ng Advanced Filter&nbsp;\">D\u00f9ng t\u00ednh n\u0103ng Advanced Filter&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Loc_trung_trong_Excel_bang_Pivot_Table\" title=\"L\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Pivot Table\">L\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Pivot Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Su_dung_ham_de_loc_trung_trong_Excel\" title=\"S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 l\u1ecdc tr\u00f9ng trong Excel\">S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 l\u1ecdc tr\u00f9ng trong Excel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Cach_loc_trung_trong_Google_Sheet_moi_nhat_2024\" title=\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet m\u1edbi nh\u1ea5t 2024\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet m\u1edbi nh\u1ea5t 2024<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Xoa_trung_lap_trong_Google_Sheet_bang_dinh_dang_co_dieu_kien\" title=\"X\u00f3a tr\u00f9ng l\u1eb7p trong Google Sheet b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n\">X\u00f3a tr\u00f9ng l\u1eb7p trong Google Sheet b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Loc_trung_trong_Google_Sheet_bang_ham_Unique\" title=\"L\u1ecdc tr\u00f9ng trong Google Sheet b\u1eb1ng h\u00e0m Unique\">L\u1ecdc tr\u00f9ng trong Google Sheet b\u1eb1ng h\u00e0m Unique<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Su_dung_bo_loc_de_tim_du_lieu_trung_trong_Google_Sheet\" title=\"S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Google Sheet\">S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Google Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Dung_ham_IF_de_loc_trung_tren_trang_tinh\" title=\"D\u00f9ng h\u00e0m IF \u0111\u1ec3 l\u1ecdc tr\u00f9ng tr\u00ean trang t\u00ednh\">D\u00f9ng h\u00e0m IF \u0111\u1ec3 l\u1ecdc tr\u00f9ng tr\u00ean trang t\u00ednh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Su_dung_tien_ich_mo_rong_de_loc_trung\" title=\"S\u1eed d\u1ee5ng ti\u1ec7n \u00edch m\u1edf r\u1ed9ng \u0111\u1ec3 l\u1ecdc tr\u00f9ng\">S\u1eed d\u1ee5ng ti\u1ec7n \u00edch m\u1edf r\u1ed9ng \u0111\u1ec3 l\u1ecdc tr\u00f9ng<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/phongvu.vn\/cong-nghe\/loc-trung-trong-excel-google-sheet\/#Tong_ket\" title=\"T\u1ed5ng k\u1ebft\">T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tai_sao_nen_loc_cac_du_lieu_bi_trung\"><\/span><strong>T\u1ea1i sao n\u00ean l\u1ecdc c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u00e0 m\u1ed9t b\u01b0\u1edbc v\u00f4 c\u00f9ng quan tr\u1ecdng trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn. Vi\u1ec7c lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch, gi\u00fap cho vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh tr\u1edf n\u00ean ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-1024x640.jpg\" alt=\" Bi\u1ebft c\u00e1ch t\u00ecm v\u00e0 lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p trong Excel s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nguy c\u01a1 sai s\u00f3t trong vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 t\u00ednh to\u00e1n\" class=\"wp-image-106805\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Bi\u1ebft c\u00e1ch t\u00ecm v\u00e0 lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p trong Excel s\u1ebd gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nguy c\u01a1 sai s\u00f3t trong vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 t\u00ednh to\u00e1n<\/figcaption><\/figure>\n\n\n\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u00fd do ch\u00ednh t\u1ea1i sao b\u1ea1n n\u00ean l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng:<\/p>\n\n\n\n<ul>\n<li><strong>\u0110\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u<\/strong>: D\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn c\u00e1c k\u1ebft qu\u1ea3 ph\u00e2n t\u00edch sai l\u1ec7ch, l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn ch\u1ea5t l\u01b0\u1ee3ng c\u1ee7a c\u00e1c b\u00e1o c\u00e1o v\u00e0 quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u \u0111\u00f3.<\/li>\n\n\n\n<li><strong>T\u1ed1i \u01b0u h\u00f3a kh\u00f4ng gian l\u01b0u tr\u1eef: <\/strong>B\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3n ghi tr\u00f9ng l\u1eb7p, b\u1ea1n s\u1ebd gi\u1ea3m k\u00edch th\u01b0\u1edbc c\u1ee7a b\u1ea3ng t\u00ednh, gi\u00fap ti\u1ebft ki\u1ec7m kh\u00f4ng gian l\u01b0u tr\u1eef v\u00e0 t\u0103ng t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>C\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c:<\/strong> Khi l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u, vi\u1ec7c l\u1ecdc tr\u00f9ng gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm, s\u1eafp x\u1ebfp v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u h\u01a1n.<\/li>\n\n\n\n<li><strong>Tr\u00e1nh c\u00e1c l\u1ed7i t\u00ednh to\u00e1n:<\/strong> C\u00e1c ph\u00e9p t\u00ednh nh\u01b0 \u0111\u1ebfm, t\u1ed5ng, trung b\u00ecnh s\u1ebd tr\u1edf n\u00ean ch\u00ednh x\u00e1c h\u01a1n khi kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/li>\n\n\n\n<li><strong>T\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o chuy\u00ean nghi\u1ec7p:<\/strong> B\u00e1o c\u00e1o \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng tr\u00ean d\u1eef li\u1ec7u s\u1ea1ch s\u1ebd v\u00e0 ch\u00ednh x\u00e1c s\u1ebd t\u1ea1o \u1ea5n t\u01b0\u1ee3ng t\u1ed1t h\u01a1n v\u1edbi ng\u01b0\u1eddi xem.<\/li>\n<\/ul>\n\n\n\n<p>T\u00f3m l\u1ea1i, l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng kh\u00f4ng ch\u1ec9 n\u00e2ng cao ch\u1ea5t l\u01b0\u1ee3ng d\u1eef li\u1ec7u m\u00e0 c\u00f2n t\u0103ng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c v\u00e0 gi\u1ea3m thi\u1ec3u r\u1ee7i ro trong x\u1eed l\u00fd th\u00f4ng tin.<\/p>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_Excel_nhanh_chong_de_thuc_hien\"><\/span><strong>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng, d\u1ec5 th\u1ef1c hi\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L\u1ecdc tr\u00f9ng trong Excel kh\u00f4ng h\u1ec1 ph\u1ee9c t\u1ea1p n\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch t\u1eadn d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 t\u00ednh n\u0103ng c\u00f3 s\u1eb5n. D\u00f9 b\u1ea1n m\u1edbi l\u00e0m quen v\u1edbi Excel hay \u0111\u00e3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o, c\u00e1c ph\u01b0\u01a1ng ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 t\u1eebng c\u00e1ch:<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Dung_cong_cu_Remove_Duplicates\"><\/span><strong>D\u00f9ng c\u00f4ng c\u1ee5 Remove Duplicates<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>T\u00ednh n\u0103ng Remove Duplicates trong Excel cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong b\u1ea3ng t\u00ednh. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 tr\u1ef1c quan nh\u1ea5t d\u00e0nh cho m\u1ecdi \u0111\u1ed1i t\u01b0\u1ee3ng ng\u01b0\u1eddi d\u00f9ng.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u: <\/strong>B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc tr\u00f9ng.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2: Truy c\u1eadp t\u00ednh n\u0103ng: <\/strong>V\u00e0o<strong> <\/strong>tab<strong> Data, <\/strong>ch\u1ecdn<strong> Remove Duplicates.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-1024x640.jpg\" alt=\"Ch\u1ecdn Remove Duplicates\" class=\"wp-image-106806\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-2.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn Remove Duplicates<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3: Ch\u1ecdn c\u1ed9t: <\/strong>Trong h\u1ed9p tho\u1ea1i Remove Duplicates hi\u1ec7n ra, t\u00edch v\u00e0o c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n d\u1ef1a v\u00e0o \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-1024x640.jpg\" alt=\"Ch\u1ecdn c\u1ed9t\" class=\"wp-image-106807\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-3.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn c\u1ed9t<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: X\u00e1c nh\u1eadn:<\/strong> Nh\u1ea5n <strong>OK<\/strong>. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng lo\u1ea1i b\u1ecf c\u00e1c d\u00f2ng tr\u00f9ng l\u1eb7p d\u1ef1a tr\u00ean c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-1024x640.jpg\" alt=\"X\u00e1c nh\u1eadn: Nh\u1ea5n OK\" class=\"wp-image-106808\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-4.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">X\u00e1c nh\u1eadn: Nh\u1ea5n OK<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_Excel_bang_Conditional_Formatting\"><\/span><strong>C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Conditional Formatting&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Conditional Formatting gi\u00fap l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong b\u1ea3ng t\u00ednh, h\u1ed7 tr\u1ee3 b\u1ea1n d\u1ec5 d\u00e0ng nh\u1eadn di\u1ec7n c\u00e1c d\u00f2ng ho\u1eb7c \u00f4 b\u1ecb l\u1eb7p \u0111\u1ec3 x\u1eed l\u00fd ch\u00fang th\u1ee7 c\u00f4ng n\u1ebfu c\u1ea7n.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc tr\u00f9ng trong Excel: <\/strong>B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng: <\/strong>V\u00e0o tab<strong> Home, <\/strong>ch\u1ecdn<strong> Conditional Formatting &gt; Highlight Cells Rules &gt; Duplicate Values.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-1024x640.jpg\" alt=\"T\u00ecm \u0111\u1ebfn Duplicate Values\" class=\"wp-image-106809\" width=\"1022\" height=\"639\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-5.jpg 1440w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00ecm \u0111\u1ebfn Duplicate Values<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3: T\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng: <\/strong>Trong h\u1ed9p tho\u1ea1i, ch\u1ecdn ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng (m\u00e0u s\u1eafc) \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u tr\u00f9ng.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-1024x640.jpg\" alt=\"T\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng\" class=\"wp-image-106810\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-6.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: X\u00e1c nh\u1eadn:<\/strong> Nh\u1ea5n <strong>OK<\/strong>. C\u00e1c \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u \u0111\u1ec3 b\u1ea1n d\u1ec5 nh\u1eadn di\u1ec7n.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-1024x640.jpg\" alt=\"X\u00e1c nh\u1eadn: Nh\u1ea5n OK\" class=\"wp-image-106811\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-7.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">X\u00e1c nh\u1eadn: Nh\u1ea5n OK<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Dung_tinh_nang_Advanced_Filter\"><\/span><strong>D\u00f9ng t\u00ednh n\u0103ng Advanced Filter&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>V\u1edbi Advanced Filter, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u1eeb m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. C\u00f4ng c\u1ee5 n\u00e0y l\u00fd t\u01b0\u1edfng khi b\u1ea1n c\u1ea7n t\u1ea1o ra danh s\u00e1ch kh\u00f4ng tr\u00f9ng l\u1eb7p m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u g\u1ed1c.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n l\u1ecdc: <\/strong>B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2: Truy c\u1eadp t\u00ednh n\u0103ng: <\/strong>V\u00e0o tab<strong> Data, <\/strong>ch\u1ecdn<strong> Advanced.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-1024x640.jpg\" alt=\"V\u00e0o tab Data, ch\u1ecdn Advanced\" class=\"wp-image-106812\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-8.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00e0o tab Data, ch\u1ecdn Advanced<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3: T\u1ea1o m\u1ed9t b\u1ea3n sao c\u1ee7a d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc<\/strong>: Ch\u1ecdn <strong>Copy to another location.<\/strong><\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 4: Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1eb7t d\u1eef li\u1ec7u l\u1ecdc: <\/strong>Nh\u1ea5n v\u00e0o <strong>Copy to. <\/strong>T\u00edch ch\u1ecdn<strong> Unique records only <\/strong>v\u00e0 nh\u1ea5n <strong>OK.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-1024x640.jpg\" alt=\"Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1eb7t d\u1eef li\u1ec7u l\u1ecdc: Nh\u1ea5n v\u00e0o Copy to\" class=\"wp-image-106813\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-9.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1eb7t d\u1eef li\u1ec7u l\u1ecdc: Nh\u1ea5n v\u00e0o Copy to<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 5: <\/strong>B\u1ea3ng d\u1eef li\u1ec7u m\u1edbi s\u1ebd n\u1eb1m ngay b\u00ean c\u1ea1nh \u00f4 b\u1ea1n \u0111\u00e3 t\u00edch ch\u1ecdn \u1edf m\u1ee5c Copy to.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-1024x640.jpg\" alt=\"B\u1ea3ng d\u1eef li\u1ec7u m\u1edbi\" class=\"wp-image-106814\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-10.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">B\u1ea3ng d\u1eef li\u1ec7u m\u1edbi<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loc_trung_trong_Excel_bang_Pivot_Table\"><\/span><strong>L\u1ecdc tr\u00f9ng trong Excel b\u1eb1ng Pivot Table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pivot Table kh\u00f4ng ch\u1ec9 d\u00f9ng \u0111\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u00e0 c\u00f2n gi\u00fap b\u1ea1n nh\u1eadn di\u1ec7n c\u00e1c m\u1ee5c tr\u00f9ng l\u1eb7p b\u1eb1ng c\u00e1ch t\u1ed5ng h\u1ee3p th\u00f4ng tin t\u1eeb c\u00e1c c\u1ed9t. \u0110\u00e2y l\u00e0 gi\u1ea3i ph\u00e1p m\u1ea1nh m\u1ebd khi l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1: T\u1ea1o PivotTable: <\/strong>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc, v\u00e0o tab <strong>Insert <\/strong>ch\u1ecdn <strong>PivotTable.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-1024x640.jpg\" alt=\"T\u1ea1o PivotTable\" class=\"wp-image-106815\" width=\"1026\" height=\"641\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-11.jpg 1440w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u1ea1o PivotTable<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2: Ch\u1ecdn tr\u01b0\u1eddng: <\/strong>Click chu\u1ed9t v\u00e0o c\u00e1c tr\u01b0\u1eddng m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra tr\u00f9ng l\u1eb7p v\u00e0o v\u00f9ng <strong>Rows<\/strong> ho\u1eb7c <strong>Columns<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-1024x640.jpg\" alt=\"Ch\u1ecdn tr\u01b0\u1eddng d\u1eef li\u1ec7u\" class=\"wp-image-106816\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-12.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn tr\u01b0\u1eddng d\u1eef li\u1ec7u<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3: <\/strong>V\u00e0o tab<strong> Design &gt; Report Layout<\/strong> \u0111\u1ec3 PivotTable c\u00f3 d\u1ea1ng nh\u01b0 h\u00ecnh. L\u00fac n\u00e0y, h\u00e3y ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t <strong>Show in Tabular Form<\/strong> v\u00e0 <strong>Repeat All Item Labels.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-1024x640.jpg\" alt=\"V\u00e0o tab Design &gt; Report Layout\" class=\"wp-image-106817\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-13.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">V\u00e0o tab Design &gt; Report Layout<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: X\u00f3a b\u1ecf nh\u1eefng subtotals kh\u1ecfi Pivot Table: <\/strong>Nh\u1ea5n v\u00e0o <strong>Design &gt;&nbsp; Subtotals Click &gt; Do Not Show Subtotals.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-1024x640.jpg\" alt=\"Ch\u1ecdn Do Not Show Subtotals\" class=\"wp-image-106818\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-14.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn Do Not Show Subtotals<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_de_loc_trung_trong_Excel\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 l\u1ecdc tr\u00f9ng trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 COUNTIF, FREQUENCY \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed7i gi\u00e1 tr\u1ecb v\u00e0 t\u1eeb \u0111\u00f3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 IF \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u ho\u1eb7c l\u1ecdc c\u00e1c d\u00f2ng d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1o th\u00eam 1 c\u1ed9t <strong>Ki\u1ec3m tra<\/strong> b\u00ean c\u1ea1nh b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc tr\u00f9ng trong Excel.<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp h\u00e0m <strong>=IF(ISNA(VLOOKUP(D3,Sheet1!D:F,1,0)),&#8221;Unique&#8221;,&#8221;Duplicate&#8221;)<\/strong><\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong> \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t <strong>Ki\u1ec3m Tra. <\/strong>Nh\u1eefng gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201c<strong>Duplicate<\/strong>\u201d, gi\u00e1 tr\u1ecb duy nh\u1ea5t s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u201c<strong>Unique<\/strong>\u201d.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-1024x640.jpg\" alt=\"Nh\u1eadp h\u00e0m =IF(ISNA(VLOOKUP(D3,Sheet1!D:F,1,0)),&quot;Unique&quot;,&quot;Duplicate&quot;)\n\" class=\"wp-image-106819\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-15.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Nh\u1eadp h\u00e0m =IF(ISNA(VLOOKUP(D3,Sheet1!D:F,1,0)),&#8221;Unique&#8221;,&#8221;Duplicate&#8221;)<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Cach_loc_trung_trong_Google_Sheet_moi_nhat_2024\"><\/span><strong>C\u00e1ch l\u1ecdc tr\u00f9ng trong Google Sheet m\u1edbi nh\u1ea5t 2024<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ngo\u00e0i vi\u1ec7c l\u1ecdc tr\u00f9ng trong Excel, Google Sheets hi\u1ec7n \u0111ang cung c\u1ea5p nhi\u1ec1u c\u00e1ch th\u1ee9c kh\u00e1c nhau \u0111\u1ec3 b\u1ea1n th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 ph\u01b0\u01a1ng ph\u00e1p l\u1ecdc tr\u00f9ng ph\u1ed5 bi\u1ebfn v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng ngay trong n\u0103m 2024:&nbsp;<\/p>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Xoa_trung_lap_trong_Google_Sheet_bang_dinh_dang_co_dieu_kien\"><\/span><strong>X\u00f3a tr\u00f9ng l\u1eb7p trong Google Sheet b\u1eb1ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y gi\u00fap b\u1ea1n tr\u1ef1c quan h\u00f3a c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i m\u00e0u s\u1eafc ho\u1eb7c ki\u1ec3u font ch\u1eef c\u1ee7a ch\u00fang. Tuy nhi\u00ean, n\u00f3 kh\u00f4ng t\u1ef1 \u0111\u1ed9ng x\u00f3a d\u1eef li\u1ec7u \u0111i.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem c\u00f3 d\u1eef li\u1ec7u n\u00e0o b\u1ecb tr\u00f9ng l\u1eb7p hay kh\u00f4ng. Tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n ch\u1ecdn <strong>\u0110\u1ecbnh d\u1ea1ng &gt;<\/strong> <strong>\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-1024x640.jpg\" alt=\"Ch\u1ecdn \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n\" class=\"wp-image-106822\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-16-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p v\u00e0o m\u0169i t\u00ean m\u1edf r\u1ed9ng ch\u1ecdn <strong>C\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh l\u00e0.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-1024x640.jpg\" alt=\"Ch\u1ecdn C\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh l\u00e0\" class=\"wp-image-106842\" width=\"1027\" height=\"642\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-17-1.jpg 1440w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u1ecdn C\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh l\u00e0<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau: <strong>=COUNTIF(A:A,A1)&gt;1. <\/strong>Trong \u0111\u00f3, A trong c\u00f4ng th\u1ee9c l\u00e0 c\u1ed9t b\u1ea1n l\u1ef1a ch\u1ecdn l\u1ecdc d\u1eef li\u1ec7u. Sau khi nh\u1eadp c\u00f4ng th\u1ee9c, h\u00e3y nh\u1ea5p v\u00e0o \u0111\u1ec3 ch\u1ecdn ki\u1ec3u t\u00f4 m\u00e0u, ki\u1ec3u ch\u1eef, ho\u1eb7c b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng cho c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-1024x640.jpg\" alt=\"B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau: =COUNTIF(A:A,A1)&gt;1\" class=\"wp-image-106826\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-18-1.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c sau: =COUNTIF(A:A,A1)&gt;1<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: <\/strong>Nh\u1ea5p <strong>OK<\/strong> \u0111\u1ec3 \u00e1p d\u1ee5ng quy t\u1eafc. Ngay l\u1eadp t\u1ee9c, c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng theo c\u00e1ch b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-1024x640.jpg\" alt=\"C\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u\" class=\"wp-image-106827\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-19.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">C\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Loc_trung_trong_Google_Sheet_bang_ham_Unique\"><\/span><strong>L\u1ecdc tr\u00f9ng trong Google Sheet b\u1eb1ng h\u00e0m Unique<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m UNIQUE s\u1ebd t\u1ea1o ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u1eeb m\u1ed9t d\u00e3y d\u1eef li\u1ec7u. \u0110\u00e2y l\u00e0 c\u00e1ch nhanh ch\u00f3ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p v\u00e0 t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ea7u ti\u00ean, \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Nh\u1eadp c\u00f4ng th\u1ee9c: G\u00f5 c\u00f4ng th\u1ee9c <strong>=UNIQUE(A2:C8)<\/strong> v\u00e0o \u00f4 \u0111\u00f3. Trong \u0111\u00f3, <strong>A2:C8<\/strong> l\u00e0 kho\u1ea3ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ecdc. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i kho\u1ea3ng n\u00e0y cho ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-1024x640.jpg\" alt=\"G\u00f5 c\u00f4ng th\u1ee9c =UNIQUE(A2:C8)\" class=\"wp-image-106828\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-20.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">G\u00f5 c\u00f4ng th\u1ee9c =UNIQUE(A2:C8)<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c. Ngay l\u1eadp t\u1ee9c, Google Sheet s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u1eeb kho\u1ea3ng d\u1eef li\u1ec7u b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-1024x640.jpg\" alt=\"B\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng\" class=\"wp-image-106829\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-21.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">B\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_bo_loc_de_tim_du_lieu_trung_trong_Google_Sheet\"><\/span><strong>S\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u tr\u00f9ng trong Google Sheet<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>T\u00ednh n\u0103ng l\u1ecdc gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 ngay b\u00ean c\u1ea1nh c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra (v\u00ed d\u1ee5: n\u1ebfu d\u1eef li\u1ec7u \u1edf c\u1ed9t A, b\u1ea1n ch\u1ecdn c\u1ed9t B). Nh\u1eadp c\u00f4ng th\u1ee9c <strong>=COUNTIF(A:A;A1)=1<\/strong> v\u00e0o \u00f4 \u0111\u00e3 ch\u1ecdn. C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u1ea7n gi\u00e1 tr\u1ecb t\u1ea1i \u00f4 A1 xu\u1ea5t hi\u1ec7n trong to\u00e0n b\u1ed9 c\u1ed9t A. N\u1ebfu ch\u1ec9 xu\u1ea5t hi\u1ec7n 1 l\u1ea7n (k\u1ebft qu\u1ea3 l\u00e0 TRUE), ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb \u0111\u00f3 kh\u00f4ng tr\u00f9ng l\u1eb7p.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-1024x640.jpg\" alt=\"Nh\u1eadp c\u00f4ng th\u1ee9c =COUNTIF(A:A;A1)=1\" class=\"wp-image-106830\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-22.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Nh\u1eadp c\u00f4ng th\u1ee9c =COUNTIF(A:A;A1)=1<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ebfn cu\u1ed1i danh s\u00e1ch d\u1eef li\u1ec7u \u0111\u1ec3 \u00e1p d\u1ee5ng cho to\u00e0n b\u1ed9 c\u1ed9t.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-1024x640.jpg\" alt=\"K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ebfn cu\u1ed1i danh s\u00e1ch\" class=\"wp-image-106831\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-23.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ebfn cu\u1ed1i danh s\u00e1ch<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u00e0 TRUE, b\u1ea1n ch\u00e8n th\u00eam m\u1ed9t h\u00e0ng tr\u00ean nh\u01b0 h\u00ecnh.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-1024x640.jpg\" alt=\"Ch\u00e8n th\u00eam m\u1ed9t h\u00e0ng\" class=\"wp-image-106833\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-24.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Ch\u00e8n th\u00eam m\u1ed9t h\u00e0ng<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: <\/strong>V\u00e0o tab <strong>D\u1eef li\u1ec7u<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn <strong>T\u1ea1o b\u1ed9 l\u1ecdc.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-1024x640.jpg\" alt=\"T\u1ea1o b\u1ed9 l\u1ecdc \" class=\"wp-image-106832\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-25.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u1ea1o b\u1ed9 l\u1ecdc <\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 5: <\/strong>Nh\u1ea5p v\u00e0o m\u0169i t\u00ean nh\u1ecf tr\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t &#8220;True &#8211; False&#8221;. B\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn FALSE v\u00e0 ch\u1ec9 gi\u1eef l\u1ea1i t\u00f9y ch\u1ecdn <strong>TRUE<\/strong>. Nh\u1ea5p v\u00e0o <strong>OK <\/strong>l\u00e0 xong.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-1024x640.jpg\" alt=\"B\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn FALSE\" class=\"wp-image-106834\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-26.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">B\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn FALSE<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 6: <\/strong>Google Sheet s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ecdc v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb TRUE trong c\u1ed9t c\u00f4ng th\u1ee9c, t\u1ee9c l\u00e0 c\u00e1c h\u00e0ng ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u1eb7p.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-1024x640.jpg\" alt=\"Google Sheet s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ecdc\" class=\"wp-image-106835\" width=\"1027\" height=\"642\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-27.jpg 1440w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" title=\"\"><figcaption class=\"wp-element-caption\">Google Sheet s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ecdc<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Dung_ham_IF_de_loc_trung_tren_trang_tinh\"><\/span><strong>D\u00f9ng h\u00e0m IF \u0111\u1ec3 l\u1ecdc tr\u00f9ng tr\u00ean trang t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>H\u00e0m IF k\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m kh\u00e1c nh\u01b0 COUNTIF gi\u00fap b\u1ea1n t\u1ea1o ra c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u00e0 \u0111\u00e1nh d\u1ea5u c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p. T\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3 l\u1ecdc b\u1ecf d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n l\u1ea7n 2 tr\u1edf \u0111i:<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> \u1ede \u00f4 b\u00ean c\u1ea1nh c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ki\u1ec3m tra, nh\u1eadp c\u00f4ng th\u1ee9c: <strong>=IF(COUNTIF($A$2:A2;A2)=1;A2;&#8221;K\u1ebft qu\u1ea3 tr\u00f9ng&#8221;).&nbsp;<\/strong><\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 2:<\/strong> \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u00f4 v\u1eeba nh\u1eadp c\u00f4ng th\u1ee9c (bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng nh\u1ecf), sau \u0111\u00f3 k\u00e9o xu\u1ed1ng h\u1ebft c\u1ed9t \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-1024x640.jpg\" alt=\"Nh\u1eadp c\u00f4ng th\u1ee9c: =IF(COUNTIF($A$2:A2;A2)=1;A2;&quot;K\u1ebft qu\u1ea3 tr\u00f9ng&quot;)\" class=\"wp-image-106836\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-28.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">Nh\u1eadp c\u00f4ng th\u1ee9c: =IF(COUNTIF($A$2:A2;A2)=1;A2;&#8221;K\u1ebft qu\u1ea3 tr\u00f9ng&#8221;)<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 3:<\/strong> Click v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong h\u00e0ng ch\u1ee9a ti\u00eau \u0111\u1ec1 c\u1ed9t. V\u00e0o tab <strong>D\u1eef li\u1ec7u<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn <strong>T\u1ea1o b\u1ed9 l\u1ecdc.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-1024x640.jpg\" alt=\"T\u1ea1o b\u1ed9 l\u1ecdc\" class=\"wp-image-106837\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-29.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u1ea1o b\u1ed9 l\u1ecdc<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: <\/strong>B\u1ea1n s\u1ebd c\u00f3 m\u1ed9t c\u1ed9t m\u1edbi hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng \u0111\u00e2u l\u00e0 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u1ecdc v\u00e0 x\u1eed l\u00fd th\u00f4ng tin.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"640\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-1024x640.jpg\" alt=\"L\u1ecdc \u0111\u01b0\u1ee3c b\u1ea3ng m\u1edbi\" class=\"wp-image-106839\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-30.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">L\u1ecdc \u0111\u01b0\u1ee3c b\u1ea3ng m\u1edbi<\/figcaption><\/figure>\n\n\n\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_tien_ich_mo_rong_de_loc_trung\"><\/span><strong>S\u1eed d\u1ee5ng ti\u1ec7n \u00edch m\u1edf r\u1ed9ng \u0111\u1ec3 l\u1ecdc tr\u00f9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>C\u00f3 nhi\u1ec1u ti\u1ec7n \u00edch m\u1edf r\u1ed9ng nh\u01b0 Remove Duplicates, Supermetrics, Ablebits Data,&#8230; cung c\u1ea5p c\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao \u0111\u1ec3 l\u1ecdc tr\u00f9ng, \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa.&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn v\u00e0o <strong>Ti\u1ec7n \u00edch &gt; Ti\u1ec7n \u00edch b\u1ed5 sung &gt; T\u1ea3i ti\u1ec7n \u00edch b\u1ed5 sung.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-1024x640.jpg\" alt=\"T\u1ea3i ti\u1ec7n \u00edch b\u1ed5 sung\" class=\"wp-image-106838\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-31.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">T\u1ea3i ti\u1ec7n \u00edch b\u1ed5 sung<\/figcaption><\/figure>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 2:<\/strong> G\u00f5 v\u00e0 t\u00ecm ki\u1ebfm ti\u1ec7n \u00edch \u201c<strong>remove duplicates<\/strong>\u201d. Ch\u1ecdn v\u00e0o ti\u1ec7n \u00edch \u0111\u00f3 v\u00e0 nh\u1ea5n <strong>C\u00e0i \u0111\u1eb7t <\/strong>\u0111\u1ec3 t\u1ea3i v\u1ec1.&nbsp;<\/li>\n\n\n\n<li><strong>B\u01b0\u1edbc 3:<\/strong> Sau khi t\u1ea3i xong ti\u1ec7n \u00edch m\u1edf r\u1ed9ng, b\u1ea1n h\u00e3y truy c\u1eadp v\u00e0o trang t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p. Nh\u1ea5p v\u00e0o <strong>Ti\u1ec7n \u00edch m\u1edf r\u1ed9ng &gt; <\/strong>ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Remove Duplicates.<\/strong><\/li>\n<\/ul>\n\n\n\n<ul>\n<li><strong>B\u01b0\u1edbc 4: <\/strong>\u0110\u00e1nh d\u1ea5u v\u00e0o \u00f4 b\u00ean c\u1ea1nh t\u00ean c\u1ee7a t\u1eebng c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n x\u1eed l\u00fd. N\u1ebfu c\u00f3 c\u1ed9t n\u00e0o kh\u00f4ng c\u1ea7n ki\u1ec3m tra tr\u00f9ng l\u1eb7p, h\u00e3y b\u1ecf \u0111\u00e1nh d\u1ea5u. Nh\u1ea5n <strong>Save <\/strong>\u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-1024x640.jpg\" alt=\"\u0110\u00e1nh d\u1ea5u v\u00e0o \u00f4 b\u00ean c\u1ea1nh t\u00ean c\u1ee7a t\u1eebng c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n x\u1eed l\u00fd\" class=\"wp-image-106840\" width=\"1024\" height=\"640\" srcset=\"https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-1024x640.jpg 1024w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-300x188.jpg 300w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-768x480.jpg 768w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-150x94.jpg 150w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-600x375.jpg 600w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-696x435.jpg 696w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-1392x870.jpg 1392w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-1068x668.jpg 1068w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-672x420.jpg 672w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33-1344x840.jpg 1344w, https:\/\/phongvu.vn\/cong-nghe\/wp-content\/uploads\/2024\/11\/loc-trung-trong-excel-33.jpg 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><figcaption class=\"wp-element-caption\">\u0110\u00e1nh d\u1ea5u v\u00e0o \u00f4 b\u00ean c\u1ea1nh t\u00ean c\u1ee7a t\u1eebng c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n x\u1eed l\u00fd<\/figcaption><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><strong>T\u1ed5ng k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>V\u1edbi nh\u1eefng c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u00e0 Google Sheets m\u00e0 ch\u00fang t\u00f4i \u0111\u00e3 gi\u1edbi thi\u1ec7u, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 nhanh ch\u00f3ng. Vi\u1ec7c lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t b\u1ea3ng t\u00ednh g\u1ecdn g\u00e0ng, ch\u00ednh x\u00e1c m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u1ed1t h\u01a1n, \u0111\u01b0a ra nh\u1eefng quy\u1ebft \u0111\u1ecbnh kinh doanh s\u00e1ng su\u1ed1t.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L\u1ecdc tr\u00f9ng trong Excel l\u00e0 m\u1ed9t thao t\u00e1c quen thu\u1ed9c v\u1edbi nh\u1eefng ai l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Vi\u1ec7c lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u s\u1ea1ch s\u1ebd, ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 d\u00e0ng ph\u00e2n t\u00edch h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y, Phong V\u0169 Tech News s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":106820,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[74,1029,24],"tags":[],"_links":{"self":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/106804"}],"collection":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/comments?post=106804"}],"version-history":[{"count":2,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/106804\/revisions"}],"predecessor-version":[{"id":106844,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/posts\/106804\/revisions\/106844"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media\/106820"}],"wp:attachment":[{"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/media?parent=106804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/categories?post=106804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phongvu.vn\/cong-nghe\/wp-json\/wp\/v2\/tags?post=106804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}