{"id":524916,"date":"2026-01-27T07:06:24","date_gmt":"2026-01-27T00:06:24","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=524916"},"modified":"2026-01-27T07:06:24","modified_gmt":"2026-01-27T00:06:24","slug":"cach-loc-du-lieu-trung-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c"},"content":{"rendered":"<p data-path-to-node=\"5\">Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi t\u1ed5ng h\u1ee3p b\u00e1o c\u00e1o t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau, vi\u1ec7c xu\u1ea5t hi\u1ec7n c\u00e1c d\u00f2ng th\u00f4ng tin l\u1eb7p l\u1ea1i l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. N\u1ebfu kh\u00f4ng n\u1eafm v\u1eefng <b data-path-to-node=\"5\" data-index-in-node=\"183\">c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel<\/b>, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng r\u01a1i v\u00e0o t\u00ecnh tr\u1ea1ng sai l\u1ec7ch s\u1ed1 li\u1ec7u, g\u00e2y \u1ea3nh h\u01b0\u1edfng nghi\u00eam tr\u1ecdng \u0111\u1ebfn k\u1ebft qu\u1ea3 ph\u00e2n t\u00edch cu\u1ed1i c\u00f9ng. Vi\u1ec7c d\u1ecdn d\u1eb9p d\u1eef li\u1ec7u (Data Cleaning) l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean v\u00e0 quan tr\u1ecdng nh\u1ea5t \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 ai l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u. May m\u1eafn thay, Microsoft Excel cung c\u1ea5p cho ch\u00fang ta r\u1ea5t nhi\u1ec1u c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y. T\u1eeb nh\u1eefng t\u00ednh n\u0103ng &#8220;m\u00ec \u0103n li\u1ec1n&#8221; nh\u01b0 Remove Duplicates \u0111\u1ebfn c\u00e1c h\u00e0m chuy\u00ean s\u00e2u, b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n m\u1ecdi thao t\u00e1c m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t.<\/p>\n<h2 data-path-to-node=\"9\">V\u00ec sao c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel?<\/h2>\n<p data-path-to-node=\"10\">S\u1edf d\u0129 vi\u1ec7c t\u00ecm hi\u1ec3u c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel tr\u1edf th\u00e0nh k\u1ef9 n\u0103ng &#8220;s\u1ed1ng c\u00f2n&#8221; c\u1ee7a d\u00e2n v\u0103n ph\u00f2ng l\u00e0 b\u1edfi t\u00ednh to\u00e0n v\u1eb9n c\u1ee7a th\u00f4ng tin. D\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p kh\u00f4ng ch\u1ec9 l\u00e0m t\u0103ng dung l\u01b0\u1ee3ng file m\u1ed9t c\u00e1ch v\u00f4 \u00edch m\u00e0 c\u00f2n tr\u1ef1c ti\u1ebfp l\u00e0m sai l\u1ec7ch c\u00e1c ph\u00e9p t\u00ednh t\u1ed5ng (SUM), trung b\u00ecnh (AVERAGE) hay c\u00e1c h\u00e0m \u0111\u1ebfm (COUNT). H\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng b\u1ea1n \u0111ang qu\u1ea3n l\u00fd danh s\u00e1ch 1.000 kh\u00e1ch h\u00e0ng, nh\u01b0ng trong \u0111\u00f3 c\u00f3 200 ng\u01b0\u1eddi b\u1ecb l\u1eb7p l\u1ea1i do l\u1ed7i nh\u1eadp li\u1ec7u; n\u1ebfu kh\u00f4ng l\u1ecdc tr\u00f9ng, ng\u00e2n s\u00e1ch qu\u00e0 t\u1eb7ng ho\u1eb7c chi\u1ebfn d\u1ecbch marketing c\u1ee7a b\u1ea1n s\u1ebd b\u1ecb l\u00e3ng ph\u00ed \u0111\u00e1ng k\u1ec3.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"10\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-525066 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"11\">B\u00ean c\u1ea1nh \u0111\u00f3, m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u s\u1ea1ch s\u1ebd gi\u00fap vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 truy xu\u1ea5t th\u00f4ng tin tr\u1edf n\u00ean nhanh ch\u00f3ng h\u01a1n. Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c tinh l\u1ecdc, c\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 VLOOKUP hay Pivot Table s\u1ebd ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c 100%. Ch\u00ednh v\u00ec v\u1eady, bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel ch\u00ednh l\u00e0 c\u00e1ch b\u1ea1n n\u00e2ng cao uy t\u00edn trong c\u00f4ng vi\u1ec7c th\u00f4ng qua nh\u1eefng b\u00e1o c\u00e1o ch\u1ea5t l\u01b0\u1ee3ng v\u00e0 tin c\u1eady.<\/p>\n<h2 data-path-to-node=\"13\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates<\/h2>\n<p data-path-to-node=\"2\">T\u00ednh n\u0103ng Remove Duplicates l\u00e0 c\u00f4ng c\u1ee5 tr\u1ef1c ti\u1ebfp nh\u1ea5t m\u00e0 Microsoft trang b\u1ecb cho Excel \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng lo\u1ea1i b\u1ecf c\u00e1c d\u00f2ng c\u00f3 n\u1ed9i dung gi\u1ed1ng nhau. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p &#8220;x\u00f3a v\u0129nh vi\u1ec5n&#8221;, v\u00ec v\u1eady b\u1ea1n n\u00ean c\u00e2n nh\u1eafc k\u1ef9 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/p>\n<p data-path-to-node=\"4,0,0\"><b data-path-to-node=\"4,0,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 1: <\/b>B\u1ea1n h\u00e3y d\u00f9ng chu\u1ed9t b\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p. L\u01b0u \u00fd n\u00ean bao g\u1ed3m c\u1ea3 ph\u1ea7n ti\u00eau \u0111\u1ec1 (Header) \u0111\u1ec3 Excel d\u1ec5 d\u00e0ng ph\u00e2n lo\u1ea1i c\u00e1c c\u1ed9t. N\u1ebfu mu\u1ed1n nhanh h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 click v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng v\u00e0 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <b data-path-to-node=\"4,0,0\" data-index-in-node=\"280\">Ctrl + A<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,0,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-525042 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 2:<\/b>\u00a0Tr\u00ean thanh Ribbon ph\u00eda tr\u00ean m\u00e0n h\u00ecnh, b\u1ea1n t\u00ecm v\u00e0 nh\u1ea5n v\u00e0o th\u1ebb <b data-path-to-node=\"4,1,0\" data-index-in-node=\"102\">Data<\/b>. Sau \u0111\u00f3, t\u1ea1i nh\u00f3m c\u00f4ng c\u1ee5 <strong>Data Tools<\/strong>, b\u1ea1n nh\u1ea5n ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <b data-path-to-node=\"4,1,0\" data-index-in-node=\"170\">Remove Duplicates<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,1,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-525043 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,2,0\"><b data-path-to-node=\"4,2,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 3:\u00a0<\/b>H\u00e3y t\u00edch v\u00e0o \u00f4 <b data-path-to-node=\"4,2,1,0,0\" data-index-in-node=\"15\">My data has headers<\/b> n\u1ebfu v\u00f9ng ch\u1ecdn c\u1ee7a b\u1ea1n c\u00f3 bao g\u1ed3m d\u00f2ng ti\u00eau \u0111\u1ec1. Trong ph\u1ea7n <b data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"11\">Columns<\/b>, b\u1ea1n t\u00edch ch\u1ecdn c\u00e1c c\u1ed9t mu\u1ed1n d\u00f9ng l\u00e0m c\u0103n c\u1ee9 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh tr\u00f9ng l\u1eb7p. N\u1ebfu b\u1ea1n mu\u1ed1n x\u00f3a d\u00f2ng khi <i data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"112\">to\u00e0n b\u1ed9<\/i> c\u00e1c th\u00f4ng tin tr\u00ean d\u00f2ng \u0111\u00f3 \u0111\u1ec1u gi\u1ed1ng h\u1ec7t nhau, h\u00e3y ch\u1ecdn <b data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"176\">Select All<\/b>. N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n l\u1ecdc tr\u00f9ng d\u1ef1a tr\u00ean m\u1ed9t c\u1ed9t nh\u1ea5t \u0111\u1ecbnh (v\u00ed d\u1ee5: MSSV), h\u00e3y ch\u1ec9 t\u00edch ch\u1ecdn c\u1ed9t \u0111\u00f3.<\/p>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525044 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,3,0\"><b data-path-to-node=\"4,3,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 4: <\/b>Nh\u1ea5n n\u00fat <b data-path-to-node=\"4,3,0\" data-index-in-node=\"81\">OK<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,3,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525045 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 data-path-to-node=\"19\">C\u00e1ch \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u tr\u00f9ng b\u1eb1ng Conditional Formatting<\/h2>\n<p data-path-to-node=\"2\">Kh\u00e1c v\u1edbi vi\u1ec7c x\u00f3a tr\u1ef1c ti\u1ebfp, Conditional Formatting (\u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n) gi\u00fap c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i tr\u1edf n\u00ean n\u1ed5i b\u1eadt h\u01a1n b\u1eb1ng c\u00e1ch t\u00f4 m\u00e0u. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u tr\u1ef1c quan v\u00e0 tr\u00e1nh nh\u1eefng sai s\u00f3t \u0111\u00e1ng ti\u1ebfc do x\u00f3a nh\u1ea7m.<\/p>\n<p data-path-to-node=\"4,0,0\"><b data-path-to-node=\"4,0,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 1: <\/b>B\u1ea1n d\u00f9ng chu\u1ed9t b\u00f4i \u0111en d\u1ea3i \u00f4 ho\u1eb7c c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n nghi ng\u1edd c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t c\u1ed9t \u0111\u01a1n l\u1ebb (nh\u01b0 c\u1ed9t ID) ho\u1eb7c ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh \u0111\u1ec3 Excel th\u1ef1c hi\u1ec7n qu\u00e9t tr\u00ean ph\u1ea1m vi r\u1ed9ng h\u01a1n.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,0,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525046 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 2: <\/b>Tr\u00ean thanh Ribbon c\u1ee7a Excel, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o th\u1ebb <b data-path-to-node=\"4,1,0\" data-index-in-node=\"86\">Home<\/b>. T\u1ea1i nh\u00f3m c\u00f4ng c\u1ee5 <i data-path-to-node=\"4,1,0\" data-index-in-node=\"109\">Styles<\/i>, b\u1ea1n t\u00ecm v\u00e0 ch\u1ecdn m\u1ee5c <b data-path-to-node=\"4,1,0\" data-index-in-node=\"137\">Conditional Formatting<\/b>.<\/p>\n<p data-path-to-node=\"4,2,0\"><b data-path-to-node=\"4,2,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 3: <\/b>T\u1eeb menu th\u1ea3 xu\u1ed1ng, b\u1ea1n di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn d\u00f2ng \u0111\u1ea7u ti\u00ean l\u00e0 <b data-path-to-node=\"4,2,0\" data-index-in-node=\"105\">Highlight Cells Rules<\/b>, sau \u0111\u00f3 ch\u1ecdn ti\u1ebfp m\u1ee5c <b data-path-to-node=\"4,2,0\" data-index-in-node=\"149\">Duplicate Values&#8230;<\/b> \u1edf cu\u1ed1i danh s\u00e1ch hi\u1ec7n ra.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,2,0\">\u00a0\u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525049 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,3,0\"><b data-path-to-node=\"4,3,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 4: <\/b>M\u1ed9t h\u1ed9p tho\u1ea1i nh\u1ecf s\u1ebd xu\u1ea5t hi\u1ec7n. T\u1ea1i \u00f4 b\u00ean tr\u00e1i, h\u00e3y \u0111\u1ea3m b\u1ea3o t\u00f9y ch\u1ecdn \u0111ang l\u00e0 <b data-path-to-node=\"4,3,0\" data-index-in-node=\"113\">Duplicate<\/b>. \u1ede \u00f4 b\u00ean ph\u1ea3i (Values with), b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c b\u1ea3ng m\u00e0u c\u00f3 s\u1eb5n nh\u01b0 <i data-path-to-node=\"4,3,0\" data-index-in-node=\"192\">Light Red Fill with Dark Red Text<\/i> (N\u1ec1n \u0111\u1ecf ch\u1eef \u0111\u1ecf \u0111\u1eadm) ho\u1eb7c ch\u1ecdn <i data-path-to-node=\"4,3,0\" data-index-in-node=\"256\">Custom Format<\/i> \u0111\u1ec3 t\u1ef1 t\u1ea1o m\u00e0u s\u1eafc theo \u00fd th\u00edch c\u00e1 nh\u00e2n.<\/p>\n<p data-path-to-node=\"4,4,0\"><b data-path-to-node=\"4,4,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 5: <\/b>Nh\u1ea5n <b data-path-to-node=\"4,4,0\" data-index-in-node=\"31\">OK<\/b> \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,4,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525048 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,5,0\"><b data-path-to-node=\"4,5,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 6: C\u00e1ch x\u00f3a \u0111\u00e1nh d\u1ea5u (n\u1ebfu c\u1ea7n).<\/b> Sau khi \u0111\u00e3 x\u1eed l\u00fd xong v\u00e0 mu\u1ed1n b\u1ea3ng t\u00ednh quay v\u1ec1 tr\u1ea1ng th\u00e1i ban \u0111\u1ea7u, b\u1ea1n ch\u1ec9 c\u1ea7n v\u00e0o l\u1ea1i <b data-path-to-node=\"4,5,0\" data-index-in-node=\"125\">Conditional Formatting<\/b> &gt; ch\u1ecdn <b data-path-to-node=\"4,5,0\" data-index-in-node=\"155\">Clear Rules<\/b> &gt; ch\u1ecdn <b data-path-to-node=\"4,5,0\" data-index-in-node=\"174\">Clear Rules from Selected Cells<\/b> \u0111\u1ec3 g\u1ee1 b\u1ecf l\u1edbp m\u00e0u \u0111\u00e1nh d\u1ea5u.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,5,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525050 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 data-path-to-node=\"25\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Advanced Filter<\/h2>\n<p data-path-to-node=\"2\">Kh\u00e1c v\u1edbi Remove Duplicates, Advanced Filter ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t b\u1ed9 l\u1ecdc th\u00f4ng minh, cho ph\u00e9p b\u1ea1n sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t (Unique records) sang m\u1ed9t v\u00f9ng m\u1edbi.<\/p>\n<p data-path-to-node=\"4,0,0\"><b data-path-to-node=\"4,0,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 1: <\/b>B\u1ea1n click ch\u1ecdn v\u00f9ng b\u1ea3ng t\u00ednh c\u1ea7n l\u1ecdc tr\u00f9ng. \u0110\u1ea3m b\u1ea3o r\u1eb1ng v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1 c\u1ed9t r\u00f5 r\u00e0ng \u0111\u1ec3 Excel c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,0,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525051 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 2: <\/b>Tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n ch\u1ecdn th\u1ebb <b data-path-to-node=\"4,1,0\" data-index-in-node=\"68\">Data<\/b>. T\u1ea1i nh\u00f3m <i data-path-to-node=\"4,1,0\" data-index-in-node=\"83\">Sort &amp; Filter<\/i>, thay v\u00ec ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Filter th\u00f4ng th\u01b0\u1eddng, b\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o m\u1ee5c <b data-path-to-node=\"4,1,0\" data-index-in-node=\"164\">Advanced<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,1,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525052 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,2,0\"><b data-path-to-node=\"4,2,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 3: <\/b>L\u00fac n\u00e0y h\u1ed9p tho\u1ea1i Advanced Filter s\u1ebd hi\u1ec7n ra, b\u1ea1n c\u1ea7n l\u1ef1a ch\u1ecdn m\u1ed9t trong hai ch\u1ebf \u0111\u1ed9 t\u1ea1i m\u1ee5c <b data-path-to-node=\"4,2,0\" data-index-in-node=\"127\">Action<\/b>:<\/p>\n<ul>\n<li data-path-to-node=\"4,2,1,0,0\"><b data-path-to-node=\"4,2,1,0,0\" data-index-in-node=\"0\">Filter the list, in-place:<\/b> L\u1ecdc v\u00e0 \u1ea9n c\u00e1c d\u00f2ng tr\u00f9ng ngay t\u1ea1i b\u1ea3ng hi\u1ec7n t\u1ea1i (d\u1eef li\u1ec7u tr\u00f9ng ch\u1ec9 b\u1ecb \u1ea9n \u0111i, kh\u00f4ng b\u1ecb x\u00f3a).<\/li>\n<li data-path-to-node=\"4,2,1,1,0\"><b data-path-to-node=\"4,2,1,1,0\" data-index-in-node=\"0\">Copy to another location:<\/b> Tr\u00edch xu\u1ea5t c\u00e1c d\u00f2ng kh\u00f4ng tr\u00f9ng sang m\u1ed9t v\u1ecb tr\u00ed m\u1edbi (Khuy\u00ean d\u00f9ng \u0111\u1ec3 gi\u1eef an to\u00e0n d\u1eef li\u1ec7u).<\/li>\n<\/ul>\n<p style=\"text-align: center;\" data-path-to-node=\"4,3,0\">\u00a0 \u00a0\u00a0<picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525053 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,3,0\"><b data-path-to-node=\"4,3,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 4:<\/b><\/p>\n<ul>\n<li data-path-to-node=\"4,3,0\">T\u1ea1i m\u1ee5c <b data-path-to-node=\"4,3,0\" data-index-in-node=\"48\">List range<\/b>: Excel \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00f9ng b\u1ea1n ch\u1ecdn \u1edf B\u01b0\u1edbc 1.<\/li>\n<li data-path-to-node=\"4,3,1,0,0\">T\u1ea1i m\u1ee5c <b data-path-to-node=\"4,3,1,0,0\" data-index-in-node=\"8\">Copy to<\/b>: B\u1ea1n nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean v\u00e0 click ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng tr\u00ean b\u1ea3ng t\u00ednh (n\u01a1i b\u1ea1n mu\u1ed1n danh s\u00e1ch k\u1ebft qu\u1ea3 hi\u1ec7n ra).<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525054 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,4,0\"><b data-path-to-node=\"4,4,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 5: <\/b>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng nh\u1ea5t. B\u1ea1n ph\u1ea3i t\u00edch v\u00e0o \u00f4 <b data-path-to-node=\"4,4,0\" data-index-in-node=\"78\">Unique records only<\/b> \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng c\u1ee7a h\u1ed9p tho\u1ea1i. N\u1ebfu thi\u1ebfu d\u1ea5u t\u00edch n\u00e0y, Excel s\u1ebd ch\u1ec9 th\u1ef1c hi\u1ec7n l\u1ec7nh copy th\u00f4ng th\u01b0\u1eddng m\u00e0 kh\u00f4ng l\u1ecdc b\u1ecf c\u00e1c d\u00f2ng tr\u00f9ng.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,4,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525055 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,5,0\"><b data-path-to-node=\"4,5,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 6: <\/b>Nh\u1ea5n <b data-path-to-node=\"4,5,0\" data-index-in-node=\"23\">OK<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,5,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525056 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 data-path-to-node=\"31\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Pivot Table<\/h2>\n<p data-path-to-node=\"2\">Pivot Table kh\u00f4ng ch\u1ec9 l\u00e0 c\u00f4ng c\u1ee5 b\u00e1o c\u00e1o m\u1ea1nh m\u1ebd m\u00e0 c\u00f2n l\u00e0 b\u1ed9 l\u1ecdc th\u00f4ng minh gi\u00fap &#8220;nh\u00f3m&#8221; c\u00e1c gi\u00e1 tr\u1ecb gi\u1ed1ng h\u1ec7t nhau th\u00e0nh m\u1ed9t \u0111\u1ea1i di\u1ec7n duy nh\u1ea5t. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u1eb7c bi\u1ec7t an to\u00e0n v\u00ec n\u00f3 kh\u00f4ng t\u00e1c \u0111\u1ed9ng hay x\u00f3a b\u1ea5t k\u1ef3 d\u00f2ng n\u00e0o tr\u00ean d\u1eef li\u1ec7u g\u1ed1c c\u1ee7a b\u1ea1n.<\/p>\n<p data-path-to-node=\"4,0,0\"><b data-path-to-node=\"4,0,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 1: <\/b>B\u1ea1n b\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc tr\u00f9ng (bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1 c\u1ed9t). Ti\u1ebfp theo, di chuy\u1ec3n chu\u1ed9t l\u00ean thanh Ribbon, ch\u1ecdn th\u1ebb <b data-path-to-node=\"4,0,0\" data-index-in-node=\"157\">Insert<\/b> v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <b data-path-to-node=\"4,0,0\" data-index-in-node=\"187\">PivotTable<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,0,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525057 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 2: <\/b>M\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd hi\u1ec7n ra h\u1ecfi b\u1ea1n mu\u1ed1n \u0111\u1eb7t k\u1ebft qu\u1ea3 \u1edf \u0111\u00e2u. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn <b data-path-to-node=\"4,1,0\" data-index-in-node=\"103\">New Worksheet<\/b> (trang t\u00ednh m\u1edbi) ho\u1eb7c <b data-path-to-node=\"4,1,0\" data-index-in-node=\"139\">Existing Worksheet<\/b> (v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 tr\u00ean trang hi\u1ec7n t\u1ea1i). Sau \u0111\u00f3 nh\u1ea5n <b data-path-to-node=\"4,1,0\" data-index-in-node=\"207\">OK<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,1,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525060 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,1,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525059 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,2,0\"><b data-path-to-node=\"4,2,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 3: <\/b>L\u00fac n\u00e0y, \u1edf ph\u00eda b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n b\u1ea3ng <i data-path-to-node=\"4,2,0\" data-index-in-node=\"105\">PivotTable Fields<\/i>. B\u1ea1n t\u00ecm t\u00ean c\u1ed9t mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng, sau \u0111\u00f3 d\u00f9ng chu\u1ed9t nh\u1ea5n gi\u1eef v\u00e0 k\u00e9o tr\u01b0\u1eddng \u0111\u00f3 th\u1ea3 v\u00e0o \u00f4 <b data-path-to-node=\"4,2,0\" data-index-in-node=\"218\">Rows<\/b>.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,2,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525058 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,4,0\"><b data-path-to-node=\"4,4,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 4: <\/b>N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft m\u1ed7i gi\u00e1 tr\u1ecb \u0111\u00e3 xu\u1ea5t hi\u1ec7n bao nhi\u00eau l\u1ea7n trong b\u1ea3ng g\u1ed1c, h\u00e3y k\u00e9o ch\u00ednh tr\u01b0\u1eddng d\u1eef li\u1ec7u \u0111\u00f3 m\u1ed9t l\u1ea7n n\u1eefa v\u00e0 th\u1ea3 v\u00e0o \u00f4 <b data-path-to-node=\"4,4,0\" data-index-in-node=\"172\">Values<\/b>. Excel s\u1ebd \u0111\u1ebfm (Count) s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a t\u1eebng m\u1ee5c.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"4,4,0\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525062 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-21-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"4,5,0\"><b data-path-to-node=\"4,5,0\" data-index-in-node=\"0\">B\u01b0\u1edbc 5: <\/b>N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng danh s\u00e1ch n\u00e0y cho m\u1ee5c \u0111\u00edch kh\u00e1c, h\u00e3y b\u00f4i \u0111en v\u00f9ng k\u1ebft qu\u1ea3, nh\u1ea5n <b data-path-to-node=\"4,5,0\" data-index-in-node=\"116\">Ctrl + C<\/b> v\u00e0 <b data-path-to-node=\"4,5,0\" data-index-in-node=\"128\">Paste Values<\/b> ra m\u1ed9t v\u1ecb tr\u00ed m\u1edbi \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c danh s\u00e1ch v\u0103n b\u1ea3n thu\u1ea7n t\u00fay \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc s\u1ea1ch.<\/p>\n<h2 data-path-to-node=\"37\">C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c<\/h2>\n<p data-path-to-node=\"38\">V\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel m\u1edbi (Office 365), Microsoft \u0111\u00e3 cung c\u1ea5p h\u00e0m <b data-path-to-node=\"38\" data-index-in-node=\"68\">UNIQUE<\/b> \u2013 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng hi\u1ec7n \u0111\u1ea1i v\u00e0 &#8220;l\u01b0\u1eddi bi\u1ebfng&#8221; nh\u1ea5t.<\/p>\n<p data-path-to-node=\"39\"><b data-path-to-node=\"39\" data-index-in-node=\"0\">C\u00fa ph\u00e1p:<\/b> <code data-path-to-node=\"39\" data-index-in-node=\"9\">$ =UNIQUE(v\u00f9ng_d\u1eef_li\u1ec7u) $<\/code><\/p>\n<p data-path-to-node=\"40\">Ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 m\u1ed9t m\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc s\u1ea1ch. N\u1ebfu b\u1ea1n d\u00f9ng phi\u00ean b\u1ea3n Excel c\u0169, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0m ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 <b data-path-to-node=\"40\" data-index-in-node=\"168\">COUNTIF<\/b> \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh d\u00f2ng tr\u00f9ng: <code data-path-to-node=\"40\" data-index-in-node=\"200\">$ =COUNTIF($A$2:A2, A2) $<\/code>. N\u1ebfu k\u1ebft qu\u1ea3 l\u1edbn h\u01a1n 1, d\u00f2ng \u0111\u00f3 l\u00e0 d\u00f2ng tr\u00f9ng.<\/p>\n<h2 data-path-to-node=\"42\">So s\u00e1nh c\u00e1c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel<\/h2>\n<table data-path-to-node=\"43\">\n<thead>\n<tr>\n<td><strong>Ph\u01b0\u01a1ng ph\u00e1p<\/strong><\/td>\n<td><strong>\u01afu \u0111i\u1ec3m<\/strong><\/td>\n<td><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/strong><\/td>\n<td><strong>Ph\u00f9 h\u1ee3p cho<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span data-path-to-node=\"43,1,0,0\"><b data-path-to-node=\"43,1,0,0\" data-index-in-node=\"0\">Remove Duplicates<\/b><\/span><\/td>\n<td><span data-path-to-node=\"43,1,1,0\">Nhanh, d\u1ec5 d\u00f9ng, x\u00f3a tri\u1ec7t \u0111\u1ec3.<\/span><\/td>\n<td><span data-path-to-node=\"43,1,2,0\">X\u00f3a m\u1ea5t d\u1eef li\u1ec7u g\u1ed1c.<\/span><\/td>\n<td><span data-path-to-node=\"43,1,3,0\">D\u1ecdn d\u1eb9p d\u1eef li\u1ec7u nhanh.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-path-to-node=\"43,2,0,0\"><b data-path-to-node=\"43,2,0,0\" data-index-in-node=\"0\">Conditional Formatting<\/b><\/span><\/td>\n<td><span data-path-to-node=\"43,2,1,0\">D\u1ec5 quan s\u00e1t, kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u.<\/span><\/td>\n<td><span data-path-to-node=\"43,2,2,0\">Ph\u1ea3i x\u00f3a th\u1ee7 c\u00f4ng sau \u0111\u00f3.<\/span><\/td>\n<td><span data-path-to-node=\"43,2,3,0\">Ki\u1ec3m tra, r\u00e0 so\u00e1t l\u1ed7i.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-path-to-node=\"43,3,0,0\"><b data-path-to-node=\"43,3,0,0\" data-index-in-node=\"0\">Advanced Filter<\/b><\/span><\/td>\n<td><span data-path-to-node=\"43,3,1,0\">Gi\u1eef nguy\u00ean g\u1ed1c, tr\u00edch xu\u1ea5t sang v\u1ecb tr\u00ed m\u1edbi.<\/span><\/td>\n<td><span data-path-to-node=\"43,3,2,0\">Thao t\u00e1c h\u01a1i ph\u1ee9c t\u1ea1p.<\/span><\/td>\n<td><span data-path-to-node=\"43,3,3,0\">T\u1ea1o danh m\u1ee5c duy nh\u1ea5t.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span data-path-to-node=\"43,4,0,0\"><b data-path-to-node=\"43,4,0,0\" data-index-in-node=\"0\">H\u00e0m UNIQUE<\/b><\/span><\/td>\n<td><span data-path-to-node=\"43,4,1,0\">T\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt, c\u1ef1c nhanh.<\/span><\/td>\n<td><span data-path-to-node=\"43,4,2,0\">Ch\u1ec9 c\u00f3 tr\u00ean Office 365.<\/span><\/td>\n<td><span data-path-to-node=\"43,4,3,0\">B\u00e1o c\u00e1o \u0111\u1ed9ng, linh ho\u1ea1t.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 data-path-to-node=\"45\">L\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/h2>\n<p data-path-to-node=\"3\">D\u00f9 b\u1ea1n \u00e1p d\u1ee5ng <b data-path-to-node=\"3\" data-index-in-node=\"15\">c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel<\/b> n\u00e0o \u0111i ch\u0103ng n\u1eefa, k\u1ebft qu\u1ea3 \u0111\u00f4i khi v\u1eabn kh\u00f4ng ch\u00ednh x\u00e1c do nh\u1eefng &#8220;h\u1ea1t s\u1ea1n&#8221; trong d\u1eef li\u1ec7u th\u00f4. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch x\u1eed l\u00fd hai l\u1ed7i kinh \u0111i\u1ec3n nh\u1ea5t:<\/p>\n<h3 data-path-to-node=\"4\">L\u1ed7i do kho\u1ea3ng tr\u1eafng d\u01b0 th\u1eeba (Space) v\u00e0 k\u00fd t\u1ef1 kh\u00f4ng hi\u1ec3n th\u1ecb<\/h3>\n<p data-path-to-node=\"5\">\u0110\u00e2y l\u00e0 nguy\u00ean nh\u00e2n h\u00e0ng \u0111\u1ea7u khi\u1ebfn c\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 Remove Duplicates hay h\u00e0m UNIQUE &#8220;b\u00f3 tay&#8221;. Trong m\u1eaft ng\u01b0\u1eddi d\u00f9ng, hai \u00f4 ch\u1ee9a ch\u1eef &#8220;Ho\u00e0ng H\u00e0&#8221; nh\u00ecn ho\u00e0n to\u00e0n gi\u1ed1ng nhau, nh\u01b0ng n\u1ebfu m\u1ed9t \u00f4 ch\u1ee9a kho\u1ea3ng tr\u1eafng \u1edf cu\u1ed1i (v\u00ed d\u1ee5: &#8220;Ho\u00e0ng H\u00e0 &#8220;) ho\u1eb7c kho\u1ea3ng tr\u1eafng k\u00e9p \u1edf gi\u1eefa, Excel s\u1ebd \u0111\u1ecbnh ngh\u0129a ch\u00fang l\u00e0 hai gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t. L\u1ed7i n\u00e0y th\u01b0\u1eddng ph\u00e1t sinh khi b\u1ea1n copy d\u1eef li\u1ec7u t\u1eeb website, ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n ho\u1eb7c do th\u00f3i quen nh\u1ea5n ph\u00edm c\u00e1ch v\u00f4 t\u1ed9i v\u1ea1 c\u1ee7a ng\u01b0\u1eddi nh\u1eadp li\u1ec7u.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"5\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525063 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"5\">\u0110\u1ec3 kh\u1eafc ph\u1ee5c tri\u1ec7t \u0111\u1ec3, b\u1ea1n kh\u00f4ng n\u00ean l\u1ecdc tr\u00f9ng ngay m\u00e0 h\u00e3y t\u1ea1o m\u1ed9t c\u1ed9t ph\u1ee5 v\u00e0 s\u1eed d\u1ee5ng h\u00e0m <b data-path-to-node=\"5\" data-index-in-node=\"542\">TRIM<\/b>. H\u00e0m n\u00e0y s\u1ebd gi\u00fap lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 kho\u1ea3ng tr\u1eafng th\u1eeba \u1edf \u0111\u1ea7u, cu\u1ed1i v\u00e0 \u0111\u01b0a c\u00e1c kho\u1ea3ng tr\u1eafng gi\u1eefa v\u1ec1 d\u1ea1ng \u0111\u01a1n. Sau \u0111\u00f3, h\u00e3y copy k\u1ebft qu\u1ea3 t\u1eeb h\u00e0m TRIM v\u00e0 d\u00e1n d\u01b0\u1edbi d\u1ea1ng gi\u00e1 tr\u1ecb (Paste Values) \u0111\u00e8 l\u00ean c\u1ed9t c\u0169. Khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c &#8220;chu\u1ea9n h\u00f3a&#8221; v\u1ec1 m\u1eb7t hi\u1ec3n th\u1ecb, c\u00e1c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel s\u1ebd ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c 100%, \u0111\u1ea3m b\u1ea3o kh\u00f4ng b\u1ecf s\u00f3t b\u1ea5t k\u1ef3 d\u00f2ng l\u1eb7p l\u1ea1i n\u00e0o.<\/p>\n<h3 data-path-to-node=\"6\">L\u1ed7i do \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t (Data Type)<\/h3>\n<p data-path-to-node=\"7\">L\u1ed7i n\u00e0y th\u01b0\u1eddng x\u1ea3y ra \u1edf c\u00e1c c\u1ed9t ch\u1ee9a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, m\u00e3 \u0111\u1ecbnh danh ho\u1eb7c ng\u00e0y th\u00e1ng. M\u1ed9t t\u00ecnh hu\u1ed1ng r\u1ea5t hay g\u1eb7p l\u00e0 s\u1ed1 &#8220;0912345678&#8221; \u1edf d\u00f2ng n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng l\u00e0 <b data-path-to-node=\"7\" data-index-in-node=\"157\">Text<\/b> (c\u00f3 d\u1ea5u nh\u00e1y \u0111\u01a1n ph\u00eda tr\u01b0\u1edbc), nh\u01b0ng \u1edf d\u00f2ng kh\u00e1c l\u1ea1i l\u00e0 d\u1ea1ng <b data-path-to-node=\"7\" data-index-in-node=\"222\">Number<\/b> ho\u1eb7c <b data-path-to-node=\"7\" data-index-in-node=\"234\">General<\/b>. M\u1eb7c d\u00f9 n\u1ed9i dung s\u1ed1 gi\u1ed1ng h\u1ec7t nhau, nh\u01b0ng thu\u1eadt to\u00e1n c\u1ee7a Excel s\u1ebd ph\u00e2n lo\u1ea1i ch\u00fang v\u00e0o hai nh\u00f3m ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau, d\u1eabn \u0111\u1ebfn vi\u1ec7c c\u00f4ng c\u1ee5 l\u1ecdc tr\u00f9ng b\u1ecf qua ch\u00fang. T\u01b0\u01a1ng t\u1ef1 v\u1edbi \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, vi\u1ec7c m\u1ed9t \u00f4 l\u00e0 &#8220;24\/01\/2026&#8221; d\u1ea1ng ng\u00e0y v\u00e0 \u00f4 kia l\u00e0 chu\u1ed7i v\u0103n b\u1ea3n s\u1ebd khi\u1ebfn b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n tr\u1edf n\u00ean l\u1ed9n x\u1ed9n.<\/p>\n<p style=\"text-align: center;\" data-path-to-node=\"7\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-525064 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23.jpg\" alt=\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p data-path-to-node=\"7\">C\u00e1ch kh\u1eafc ph\u1ee5c t\u1ed1t nh\u1ea5t l\u00e0 b\u1ea1n h\u00e3y b\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t d\u1eef li\u1ec7u, s\u1eed d\u1ee5ng t\u00ednh n\u0103ng <b data-path-to-node=\"7\" data-index-in-node=\"630\">Text to Columns<\/b> trong th\u1ebb Data \u0111\u1ec3 \u00e9p t\u1ea5t c\u1ea3 v\u1ec1 c\u00f9ng m\u1ed9t \u0111\u1ecbnh d\u1ea1ng nh\u1ea5t \u0111\u1ecbnh, ho\u1eb7c ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng chung trong h\u1ed9p tho\u1ea1i <b data-path-to-node=\"7\" data-index-in-node=\"749\">Format Cells<\/b>. Khi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u00e3 &#8220;c\u00f9ng h\u1ec7 quy chi\u1ebfu&#8221;, vi\u1ec7c \u00e1p d\u1ee5ng c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel s\u1ebd gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n c\u00e1c d\u00f2ng th\u1eeba, mang l\u1ea1i m\u1ed9t b\u1ea3ng t\u00ednh s\u1ea1ch s\u1ebd v\u00e0 tin c\u1eady \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o.<\/p>\n<h2 data-path-to-node=\"52\">T\u1ea1m k\u1ebft<\/h2>\n<p data-path-to-node=\"53\">Vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n l\u00e0m s\u1ea1ch b\u1ea3ng t\u00ednh m\u00e0 c\u00f2n kh\u1eb3ng \u0111\u1ecbnh s\u1ef1 chuy\u00ean nghi\u1ec7p trong c\u00e1ch x\u1eed l\u00fd s\u1ed1 li\u1ec7u. T\u00f9y v\u00e0o m\u1ee5c \u0111\u00edch l\u00e0 x\u00f3a b\u1ecf ho\u00e0n to\u00e0n hay ch\u1ec9 mu\u1ed1n \u0111\u00e1nh d\u1ea5u, h\u00e3y ch\u1ecdn cho m\u00ecnh c\u00f4ng c\u1ee5 ph\u00f9 h\u1ee3p nh\u1ea5t. N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t chi\u1ebfc laptop v\u0103n ph\u00f2ng m\u1ea1nh m\u1ebd \u0111\u1ec3 x\u1eed l\u00fd m\u01b0\u1ee3t m\u00e0 nh\u1eefng file Excel h\u00e0ng tri\u1ec7u d\u00f2ng, h\u00e3y gh\u00e9 ngay Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u01b0 v\u1ea5n c\u00e1c d\u00f2ng m\u00e1y m\u1edbi nh\u1ea5t v\u1edbi m\u1ee9c gi\u00e1 c\u1ef1c k\u1ef3 \u01b0u \u0111\u00e3i nh\u00e9!<\/p>\n<p data-path-to-node=\"54\"><em><strong>XEM TH\u00caM:<\/strong><\/em><\/p>\n<ul>\n<li data-path-to-node=\"54\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tim-kiem-trong-excel\/\">7 c\u00e1ch t\u00ecm ki\u1ebfm trong Excel v\u00e0 thay th\u1ebf v\u1edbi Find v\u00e0 Replace<\/a><\/strong><\/li>\n<li data-path-to-node=\"54\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mid-excel\/\">H\u00e0m MID trong Excel: C\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda chi ti\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd b\u1ea3ng t\u00ednh, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi t\u1ed5ng h\u1ee3p b\u00e1o c\u00e1o t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau, vi\u1ec7c xu\u1ea5t hi\u1ec7n c\u00e1c d\u00f2ng th\u00f4ng tin l\u1eb7p l\u1ea1i l\u00e0 \u0111i\u1ec1u kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi. N\u1ebfu kh\u00f4ng n\u1eafm v\u1eefng c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng r\u01a1i v\u00e0o t\u00ecnh tr\u1ea1ng sai [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":525065,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,412],"tags":[],"class_list":["post-524916","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c<\/title>\n<meta name=\"description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c\" \/>\n<meta property=\"og:description\" content=\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-27T00:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Lan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Lan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\"},\"author\":{\"name\":\"Vo Lan\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\"},\"headline\":\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c\",\"datePublished\":\"2026-01-27T00:06:24+00:00\",\"dateModified\":\"2026-01-27T00:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\"},\"wordCount\":3371,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\",\"name\":\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg\",\"datePublished\":\"2026-01-27T00:06:24+00:00\",\"dateModified\":\"2026-01-27T00:06:24+00:00\",\"description\":\"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-24\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0\",\"name\":\"Vo Lan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g\",\"caption\":\"Vo Lan\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c","og_description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2026-01-27T00:06:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg","type":"image\/jpeg"}],"author":"Vo Lan","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Lan","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"17 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/"},"author":{"name":"Vo Lan","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0"},"headline":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c","datePublished":"2026-01-27T00:06:24+00:00","dateModified":"2026-01-27T00:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/"},"wordCount":3371,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/","name":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg","datePublished":"2026-01-27T00:06:24+00:00","dateModified":"2026-01-27T00:06:24+00:00","description":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng Remove Duplicates, h\u00e0m UNIQUE, Advanced Filter v\u00e0 Pivot Table.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2026\/01\/cach-loc-du-lieu-trung-trong-excel-24.jpg","width":1200,"height":628,"caption":"cach-loc-du-lieu-trung-trong-excel-nhanh-chong-va-chinh-xac-24"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trung-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0a812d5b8175a4091883285291c094d0","name":"Vo Lan","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fd70d1838a6fc3aa34a3a78f6253c3d4?s=96&d=mm&r=g","caption":"Vo Lan"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/vo-lan\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/524916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=524916"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/524916\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/525065"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=524916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=524916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=524916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}