{"id":491718,"date":"2025-09-20T10:47:30","date_gmt":"2025-09-20T03:47:30","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=491718"},"modified":"2025-09-20T10:47:30","modified_gmt":"2025-09-20T03:47:30","slug":"cach-loc-trung-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/","title":{"rendered":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">D\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p l\u00e0 m\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn g\u00e2y sai l\u1ec7ch k\u1ebft qu\u1ea3 khi ph\u00e2n t\u00edch tr\u00ean Excel. V\u00ec v\u1eady, c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel l\u00e0 thao t\u00e1c quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u lu\u00f4n ch\u00ednh x\u00e1c v\u00e0 g\u1ecdn g\u00e0ng. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t s\u1ed1 c\u00e1ch l\u1ecdc tr\u00f9ng d\u1ec5 \u00e1p d\u1ee5ng trong Excel, ph\u00f9 h\u1ee3p c\u1ea3 cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u l\u1eabn ng\u01b0\u1eddi d\u00f9ng chuy\u00ean nghi\u1ec7p.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel l\u00e0 g\u00ec? Khi n\u00e0o c\u1ea7n d\u00f9ng?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">L\u1ecdc tr\u00f9ng trong Microsoft Excel l\u00e0 thao t\u00e1c d\u00f9ng \u0111\u1ec3 ph\u00e1t hi\u1ec7n v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n l\u1eb7p l\u1ea1i trong b\u1ea3ng t\u00ednh. T\u00ednh n\u0103ng n\u00e0y gi\u00fap b\u1ea1n gi\u1eef l\u1ea1i duy nh\u1ea5t m\u1ed9t b\u1ea3n ghi cho m\u1ed7i gi\u00e1 tr\u1ecb, t\u1eeb \u0111\u00f3 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 tr\u00e1nh t\u00ecnh tr\u1ea1ng th\u1ed1ng k\u00ea sai l\u1ec7ch do d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n n\u00ean s\u1eed d\u1ee5ng l\u1ecdc tr\u00f9ng khi:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1eef li\u1ec7u nh\u1eadp t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau c\u00f3 kh\u1ea3 n\u0103ng ch\u1ee9a th\u00f4ng tin tr\u00f9ng l\u1eb7p.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u1ea7n t\u1ed5ng h\u1ee3p danh s\u00e1ch kh\u00e1ch h\u00e0ng, s\u1ea3n ph\u1ea9m, m\u00e3 \u0111\u01a1n h\u00e0ng\u2026 m\u00e0 kh\u00f4ng b\u1ecb l\u1eb7p gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ec3 ph\u00e2n t\u00edch, l\u1eadp b\u00e1o c\u00e1o ho\u1eb7c t\u1ea1o bi\u1ec3u \u0111\u1ed3 &#8211; y\u00eau c\u1ea7u d\u1eef li\u1ec7u ch\u00ednh x\u00e1c v\u00e0 duy nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-491720 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1.jpg\" alt=\"cach-loc-trung-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">Top 5+ c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch l\u1ecdc tr\u00f9ng Excel \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 nh\u1ea5t gi\u00fap b\u1ea1n l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i b\u01b0\u1edbc thao t\u00e1c:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel v\u1edbi Remove Duplicates<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ednh n\u0103ng Remove Duplicates trong Microsoft Excel cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng x\u00f3a c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i trong b\u1ea3ng t\u00ednh ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. H\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean b\u1ea3ng t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng, b\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra \u0111\u1ec3 chu\u1ea9n b\u1ecb l\u1ecdc tr\u00f9ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-491721 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2.jpg\" alt=\"cach-loc-trung-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn tab Data, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Remove Duplicates trong nh\u00f3m Data Tools.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-491722 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3.jpg\" alt=\"cach-loc-trung-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi h\u1ed9p tho\u1ea1i Remove Duplicates hi\u1ec7n ra, \u0111\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o c\u00e1c c\u1ed9t b\u1ea1n mu\u1ed1n ki\u1ec3m tra tr\u00f9ng l\u1eb7p; n\u1ebfu c\u1ea7n l\u1ecdc to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t, nh\u1ea5n Select All, sau \u0111\u00f3 b\u1ea5m OK.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491723 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4.jpg\" alt=\"cach-loc-trung-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3, hi\u1ec3n th\u1ecb s\u1ed1 d\u00f2ng tr\u00f9ng \u0111\u00e3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf v\u00e0 s\u1ed1 d\u00f2ng d\u1eef li\u1ec7u duy nh\u1ea5t c\u00f2n l\u1ea1i.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491724 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5.jpg\" alt=\"cach-loc-trung-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Tr\u01b0\u1edbc khi l\u1ecdc, n\u00ean sao l\u01b0u file g\u1ed1c \u0111\u1ec3 tr\u00e1nh m\u1ea5t d\u1eef li\u1ec7u quan tr\u1ecdng trong qu\u00e1 tr\u00ecnh x\u00f3a gi\u00e1 tr\u1ecb tr\u00f9ng.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u tr\u00f9ng trong Microsoft Excel b\u1eb1ng Conditional Formatting<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ednh n\u0103ng Conditional Formatting trong Microsoft Excel gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u00f4 m\u00e0u v\u00e0 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p \u0111\u1ec3 ti\u1ec7n theo d\u00f5i ho\u1eb7c l\u1ecdc l\u1ea1i d\u1eef li\u1ec7u. C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn (t\u00f4 \u0111en) to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o b\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491725 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6.jpg\" alt=\"cach-loc-trung-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean thanh menu, ch\u1ecdn Home \u2192 Conditional Formatting \u2192 Highlight Cells Rules \u2192 Duplicate Values.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491726 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7.jpg\" alt=\"cach-loc-trung-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi h\u1ed9p tho\u1ea1i Duplicate Values xu\u1ea5t hi\u1ec7n, b\u1ea1n s\u1ebd th\u1ea5y:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Duplicate: \u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n l\u1eb7p l\u1ea1i trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Unique: \u0110\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491727 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8.jpg\" alt=\"cach-loc-trung-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Trong c\u00f9ng h\u1ed9p tho\u1ea1i, ch\u1ecdn ki\u1ec3u \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng, v\u00ed d\u1ee5:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Light red fill with dark red text: N\u1ec1n \u0111\u1ecf nh\u1ea1t, ch\u1eef \u0111\u1ecf \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Yellow fill with dark yellow text: N\u1ec1n v\u00e0ng, ch\u1eef v\u00e0ng \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Green fill with dark green text: N\u1ec1n xanh, ch\u1eef xanh \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Red text \/ Red border: Ch\u1ec9 \u0111\u1ed5i m\u00e0u ch\u1eef ho\u1eb7c t\u1ea1o vi\u1ec1n \u0111\u1ecf quanh \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Custom format: T\u00f9y ch\u1ec9nh m\u00e0u n\u1ec1n v\u00e0 m\u00e0u ch\u1eef theo \u00fd th\u00edch.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491728 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9.jpg\" alt=\"cach-loc-trung-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Nh\u1ea5n OK, c\u00e1c \u00f4 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p s\u1ebd \u0111\u01b0\u1ee3c t\u00f4 m\u00e0u ngay l\u1eadp t\u1ee9c, gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft \u0111\u1ec3 x\u1eed l\u00fd ho\u1eb7c l\u1ecdc gi\u00e1 tr\u1ecb tr\u00f9ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491729 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10.jpg\" alt=\"cach-loc-trung-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">M\u1eb9o nh\u1ecf: Sau khi \u0111\u00e3 \u0111\u00e1nh d\u1ea5u c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng b\u1ed9 l\u1ecdc (Filter) \u0111\u1ec3 nhanh ch\u00f3ng l\u1ecdc v\u00e0 lo\u1ea1i b\u1ecf ch\u00fang n\u1ebfu c\u1ea7n.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi Advanced Filter<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ednh n\u0103ng Advanced Filter trong Microsoft Excel cho ph\u00e9p b\u1ea1n t\u00e1ch ra danh s\u00e1ch ch\u1ec9 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 b\u1ea3n ghi tr\u00f9ng l\u1eb7p. B\u1ea1n h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng \u00f4 ho\u1eb7c c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ecdc \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491730 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11.jpg\" alt=\"cach-loc-trung-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean thanh menu, chuy\u1ec3n sang tab Data, t\u1ea1i nh\u00f3m Sort &amp; Filter b\u1ea5m v\u00e0o Advanced.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491731 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12.jpg\" alt=\"cach-loc-trung-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi h\u1ed9p tho\u1ea1i Advanced Filter m\u1edf ra, ch\u1ecdn t\u00f9y ch\u1ecdn Copy to another location \u0111\u1ec3 t\u1ea1o danh s\u00e1ch m\u1edbi kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb tr\u00f9ng.<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede m\u1ee5c Copy to, ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh b\u1ea3ng d\u1eef li\u1ec7u hi\u1ec7n c\u00f3 \u0111\u1ec3 \u0111\u1eb7t k\u1ebft qu\u1ea3 l\u1ecdc.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00edch ch\u1ecdn v\u00e0o Unique records only \u0111\u1ec3 ch\u1ec9 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5n OK \u0111\u1ec3 b\u1eaft \u0111\u1ea7u l\u1ecdc.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491732 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13.jpg\" alt=\"cach-loc-trung-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ngay sau \u0111\u00f3, t\u1ea1i khu v\u1ef1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn \u1edf m\u1ee5c Copy to, b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c danh s\u00e1ch \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc b\u1ecf to\u00e0n b\u1ed9 d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491733 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14.jpg\" alt=\"cach-loc-trung-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Advanced Filter s\u1ebd kh\u00f4ng x\u00f3a c\u00e1c d\u00f2ng tr\u00f9ng trong v\u00f9ng g\u1ed1c m\u00e0 ch\u1ec9 t\u1ea1o m\u1ed9t danh s\u00e1ch m\u1edbi g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t, gi\u00fap b\u1ea1n b\u1ea3o to\u00e0n d\u1eef li\u1ec7u ban \u0111\u1ea7u.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi Pivot Table<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng Pivot Table l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ec9 g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Microsoft Excel m\u00e0 kh\u00f4ng c\u1ea7n x\u00f3a d\u1eef li\u1ec7u g\u1ed1c. B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u hi\u1ec7n c\u00f3, ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong v\u00f9ng d\u1eef li\u1ec7u (ho\u1eb7c b\u00f4i \u0111en to\u00e0n b\u1ed9). V\u00e0o tab Insert tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea5m PivotTable r\u1ed3i nh\u1ea5n OK \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u1ed5ng h\u1ee3p m\u1edbi.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491736 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17.jpg\" alt=\"cach-loc-trung-trong-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Khi Pivot Table tr\u1ed1ng xu\u1ea5t hi\u1ec7n, k\u00e9o c\u1ed9t ch\u1ee9a t\u00ean ho\u1eb7c gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc v\u00e0o khu v\u1ef1c Rows \u0111\u1ec3 hi\u1ec3n th\u1ecb to\u00e0n b\u1ed9 danh s\u00e1ch gi\u00e1 tr\u1ecb.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491737 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18.jpg\" alt=\"cach-loc-trung-trong-excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Chuy\u1ec3n sang tab Design, v\u00e0o Report Layout r\u1ed3i ch\u1ecdn l\u1ea7n l\u01b0\u1ee3t Show in Tabular Form v\u00e0 Repeat All Item Labels \u0111\u1ec3 d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng r\u00f5 r\u00e0ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491738 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19.jpg\" alt=\"cach-loc-trung-trong-excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Trong tab Design, b\u1ea5m Subtotals v\u00e0 ch\u1ecdn Do Not Show Subtotals \u0111\u1ec3 \u1ea9n c\u00e1c d\u00f2ng t\u1ed5ng ph\u1ee5, gi\u00fap b\u1ea3ng g\u1ecdn h\u01a1n.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491739 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20.jpg\" alt=\"cach-loc-trung-trong-excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Ho\u00e0n t\u1ea5t c\u00e1c b\u01b0\u1edbc, b\u1ea3ng Pivot Table s\u1ebd tr\u1ea3 v\u1ec1 danh s\u00e1ch c\u00e1c t\u00ean duy nh\u1ea5t \u2014 \u0111\u00e2y ch\u00ednh l\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491741 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22.jpg\" alt=\"cach-loc-trung-trong-excel-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">M\u1eb9o nh\u1ecf: B\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p danh s\u00e1ch t\u00ean duy nh\u1ea5t n\u00e0y ra v\u1ecb tr\u00ed kh\u00e1c \u0111\u1ec3 s\u1eed d\u1ee5ng, \u0111\u1ea3m b\u1ea3o kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng t\u1edbi b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel v\u1edbi Power Query<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00ednh n\u0103ng Power Query h\u1ed7 tr\u1ee3 m\u1ea1nh m\u1ebd trong vi\u1ec7c x\u1eed l\u00fd, chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u v\u00e0 \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch \u0111\u1ec3 ph\u00e1t hi\u1ec7n \u2013 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng l\u1eb7p. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m tra tr\u00f9ng. Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn tab Data, sau \u0111\u00f3 nh\u1ea5n From Table\/Range \u0111\u1ec3 m\u1edf d\u1eef li\u1ec7u trong Power Query.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491754 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21.jpg\" alt=\"cach-loc-trung-trong-excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Trong c\u1eeda s\u1ed5 Power Query, v\u00e0o tab Home, b\u1ea5m Remove Duplicates \u0111\u1ec3 h\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u1ed9ng lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p trong c\u1ed9t \u0111\u00e3 ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491742 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23.jpg\" alt=\"cach-loc-trung-trong-excel-23\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-23-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Sau khi x\u1eed l\u00fd, b\u1ea3ng s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc b\u1ecf ho\u00e0n to\u00e0n c\u00e1c d\u00f2ng tr\u00f9ng nhau.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491743 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24.jpg\" alt=\"cach-loc-trung-trong-excel-24\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-24-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: \u0110\u1ec3 \u0111\u01b0a d\u1eef li\u1ec7u \u0111\u00e3 l\u00e0m s\u1ea1ch quay l\u1ea1i Excel, v\u00e0o File \u2192 ch\u1ecdn Close &amp; Load \u2192 nh\u1ea5n ti\u1ebfp Close &amp; Load \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh xu\u1ea5t.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491744 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25.jpg\" alt=\"cach-loc-trung-trong-excel-25\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-25-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: B\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f2n gi\u00e1 tr\u1ecb tr\u00f9ng s\u1ebd \u0111\u01b0\u1ee3c t\u1ea3i v\u1ec1 m\u1ed9t trang t\u00ednh m\u1edbi trong Excel \u0111\u1ec3 b\u1ea1n ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491746 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27.jpg\" alt=\"cach-loc-trung-trong-excel-27\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-27-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Power Query kh\u00f4ng l\u00e0m thay \u0111\u1ed5i d\u1eef li\u1ec7u g\u1ed1c, b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n y\u00ean t\u00e2m khi \u00e1p d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 ki\u1ec3m tra v\u00e0 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng tr\u00ean nhi\u1ec1u sheet<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi c\u1ea7n so s\u00e1nh d\u1eef li\u1ec7u gi\u1eefa hai sheet kh\u00e1c nhau, nh\u1eefng c\u00e1ch th\u00f4ng th\u01b0\u1eddng nh\u01b0 Remove Duplicates ho\u1eb7c Conditional Formatting s\u1ebd kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c. Trong t\u00ecnh hu\u1ed1ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb b\u1ecb tr\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u00ecnh hu\u1ed1ng v\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sheet1: Ch\u1ee9a danh s\u00e1ch s\u1ea3n ph\u1ea9m hi\u1ec7n c\u00f3, v\u1edbi m\u00e3 s\u1ea3n ph\u1ea9m n\u1eb1m \u1edf c\u1ed9t A.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sheet2: Ch\u1ee9a danh s\u00e1ch s\u1ea3n ph\u1ea9m m\u1edbi, b\u1ea1n mu\u1ed1n ki\u1ec3m tra xem m\u00e3 s\u1ea3n ph\u1ea9m \u1edf c\u1ed9t A (Sheet2) c\u00f3 tr\u00f9ng v\u1edbi Sheet1 hay kh\u00f4ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491747 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28.jpg\" alt=\"cach-loc-trung-trong-excel-28\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-28-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">M\u1ee5c ti\u00eau: \u0110\u00e1nh d\u1ea5u c\u00e1c m\u00e3 s\u1ea3n ph\u1ea9m tr\u00ean Sheet2 c\u00f3 xu\u1ea5t hi\u1ec7n trong Sheet1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean Sheet2, th\u00eam m\u1ed9t c\u1ed9t m\u1edbi \u0111\u1eb7t t\u00ean l\u00e0 Tr\u1ea1ng Th\u00e1i. \u0110\u00e2y s\u1ebd l\u00e0 n\u01a1i hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u201cTr\u00f9ng L\u1eb7p\u201d ho\u1eb7c \u201cKh\u00f4ng Tr\u00f9ng\u201d cho t\u1eebng m\u00e3 s\u1ea3n ph\u1ea9m.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491748 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29.jpg\" alt=\"cach-loc-trung-trong-excel-29\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-29-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t Tr\u1ea1ng Th\u00e1i (v\u00ed d\u1ee5 \u00f4 C2), nh\u1eadp c\u00f4ng th\u1ee9c: <\/span>=IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),&#8221;Tr\u00f9ng L\u1eb7p&#8221;,&#8221;Kh\u00f4ng Tr\u00f9ng&#8221;). Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A2: L\u00e0 \u00f4 ch\u1ee9a m\u00e3 s\u1ea3n ph\u1ea9m c\u1ea7n ki\u1ec3m tra tr\u00ean Sheet2.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sheet1!A:A: L\u00e0 to\u00e0n b\u1ed9 c\u1ed9t m\u00e3 s\u1ea3n ph\u1ea9m tr\u00ean Sheet1 \u0111\u1ec3 so s\u00e1nh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">MATCH(A2,Sheet1!A:A,0): T\u00ecm v\u1ecb tr\u00ed c\u1ee7a gi\u00e1 tr\u1ecb trong A2 c\u00f3 t\u1ed3n t\u1ea1i trong Sheet1 hay kh\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ISNUMBER(&#8230;): Tr\u1ea3 v\u1ec1 TRUE n\u1ebfu t\u00ecm th\u1ea5y gi\u00e1 tr\u1ecb, ng\u01b0\u1ee3c l\u1ea1i l\u00e0 FALSE.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">IF(&#8230;): N\u1ebfu t\u00ecm th\u1ea5y s\u1ebd hi\u1ec3n th\u1ecb \u201cTr\u00f9ng L\u1eb7p\u201d, n\u1ebfu kh\u00f4ng th\u00ec \u201cKh\u00f4ng Tr\u00f9ng\u201d.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491749 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30.jpg\" alt=\"cach-loc-trung-trong-excel-30\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-30-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u00c1p d\u1ee5ng cho to\u00e0n b\u1ed9 c\u1ed9t: K\u00e9o c\u00f4ng th\u1ee9c v\u1eeba nh\u1eadp xu\u1ed1ng t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng trong c\u1ed9t Tr\u1ea1ng Th\u00e1i \u0111\u1ec3 ki\u1ec3m tra to\u00e0n b\u1ed9 danh s\u00e1ch m\u00e3 s\u1ea3n ph\u1ea9m tr\u00ean Sheet2.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491750 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31.jpg\" alt=\"cach-loc-trung-trong-excel-31\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-31-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eefng m\u00e3 s\u1ea3n ph\u1ea9m c\u00f3 xu\u1ea5t hi\u1ec7n tr\u00ean Sheet1 s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 \u201cTr\u00f9ng L\u1eb7p\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eefng m\u00e3 kh\u00f4ng c\u00f3 tr\u00ean Sheet1 s\u1ebd hi\u1ec3n th\u1ecb l\u00e0 \u201cKh\u00f4ng Tr\u00f9ng\u201d.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491751 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32.jpg\" alt=\"cach-loc-trung-trong-excel-32\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-32-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p khi th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel<\/span><\/h2>\n<h3><span style=\"font-weight: 400;\">C\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng \u1edf nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac trong Microsoft Excel kh\u00f4ng?<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00f3. Excel h\u1ed7 tr\u1ee3 ki\u1ec3m tra tr\u00f9ng l\u1eb7p tr\u00ean nhi\u1ec1u c\u1ed9t b\u1eb1ng Remove Duplicates. Khi b\u1ea1n ch\u1ecdn nhi\u1ec1u c\u1ed9t r\u1ed3i \u00e1p d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y, Excel s\u1ebd \u0111\u1ed1i chi\u1ebfu to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb theo t\u1eebng h\u00e0ng. Ch\u1ec9 nh\u1eefng h\u00e0ng c\u00f3 to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb \u1edf c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn gi\u1ed1ng nhau m\u1edbi b\u1ecb xem l\u00e0 tr\u00f9ng v\u00e0 b\u1ecb lo\u1ea1i b\u1ecf, c\u00e1c h\u00e0ng kh\u00e1c s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n x\u00e1c \u0111\u1ecbnh d\u1eef li\u1ec7u tr\u00f9ng m\u00e0 kh\u00f4ng x\u00f3a d\u00f2ng, b\u1ea1n c\u00f3 th\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u00f9ng Advanced Filter \u0111\u1ec3 l\u1ecdc ra danh s\u00e1ch gi\u00e1 tr\u1ecb duy nh\u1ea5t, v\u1eabn gi\u1eef nguy\u00ean b\u1ea3ng g\u1ed1c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ho\u1eb7c d\u00f9ng Power Query \u0111\u1ec3 nh\u00f3m v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p, ph\u00f9 h\u1ee3p khi c\u1ea7n so s\u00e1nh nhi\u1ec1u c\u1ed9t trong b\u1ea3ng l\u1edbn.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u1edd v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u tr\u00f9ng tr\u00ean nhi\u1ec1u c\u1ed9t m\u1ed9t c\u00e1ch an to\u00e0n v\u00e0 linh ho\u1ea1t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491752 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33.jpg\" alt=\"cach-loc-trung-trong-excel-33\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-33-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel c\u00f3 l\u00e0m b\u1ea3ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng ban \u0111\u1ea7u kh\u00f4ng?<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Remove Duplicates s\u1ebd kh\u00f4ng l\u00e0m m\u1ea5t ho\u00e0n to\u00e0n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a b\u1ea3ng, nh\u01b0ng c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng m\u1ed9t ph\u1ea7n \u0111\u1ebfn b\u1ed1 c\u1ee5c. C\u00e1c y\u1ebfu t\u1ed1 nh\u01b0 ki\u1ec3u ch\u1eef, m\u00e0u n\u1ec1n, vi\u1ec1n \u00f4 v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean \u1edf nh\u1eefng h\u00e0ng c\u00f2n l\u1ea1i. Tuy nhi\u00ean, v\u00ec c\u00e1c h\u00e0ng tr\u00f9ng s\u1ebd b\u1ecb x\u00f3a v\u00e0 nh\u1eefng h\u00e0ng b\u00ean d\u01b0\u1edbi \u0111\u01b0\u1ee3c d\u1ed3n l\u00ean, th\u1ee9 t\u1ef1 v\u00e0 b\u1ed1 c\u1ee5c ban \u0111\u1ea7u c\u1ee7a b\u1ea3ng c\u00f3 th\u1ec3 b\u1ecb thay \u0111\u1ed5i.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 tr\u00e1nh r\u1ee7i ro n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sao ch\u00e9p b\u1ea3ng d\u1eef li\u1ec7u sang m\u1ed9t sheet m\u1edbi tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n Remove Duplicates.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ho\u1eb7c d\u00f9ng Conditional Formatting \u2192 Highlight Duplicate Values \u0111\u1ec3 ch\u1ec9 \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng x\u00f3a, gi\u00fap gi\u1eef nguy\u00ean to\u00e0n b\u1ed9 b\u1ed1 c\u1ee5c v\u00e0 \u0111\u1ecbnh d\u1ea1ng g\u1ed1c c\u1ee7a b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-491753 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34.jpg\" alt=\"cach-loc-trung-trong-excel-34\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel-34-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c th\u00e0nh th\u1ea1o c\u00e1c c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u m\u00e0 c\u00f2n n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c cho m\u1ecdi b\u00e1o c\u00e1o. H\u00e3y \u00e1p d\u1ee5ng linh ho\u1ea1t t\u1eebng ph\u01b0\u01a1ng ph\u00e1p t\u00f9y v\u00e0o t\u00ecnh hu\u1ed1ng \u0111\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u qu\u1ea3 x\u1eed l\u00fd b\u1ea3ng t\u00ednh v\u00e0 tr\u00e1nh sai s\u00f3t kh\u00f4ng \u0111\u00e1ng c\u00f3 trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\">2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>D\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p l\u00e0 m\u1ed9t trong nh\u1eefng nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn g\u00e2y sai l\u1ec7ch k\u1ebft qu\u1ea3 khi ph\u00e2n t\u00edch tr\u00ean Excel. V\u00ec v\u1eady, c\u00e1ch l\u1ecdc tr\u00f9ng trong Excel l\u00e0 thao t\u00e1c quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u lu\u00f4n ch\u00ednh x\u00e1c v\u00e0 g\u1ecdn g\u00e0ng. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t s\u1ed1 [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":491719,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-491718","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","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 tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.\" \/>\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-trung-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 tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-20T03:47:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.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=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\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=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 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-trung-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5\"},\"headline\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng\",\"datePublished\":\"2025-09-20T03:47:30+00:00\",\"dateModified\":\"2025-09-20T03:47:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\"},\"wordCount\":3133,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\",\"name\":\"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg\",\"datePublished\":\"2025-09-20T03:47:30+00:00\",\"dateModified\":\"2025-09-20T03:47:30+00:00\",\"description\":\"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-loc-trung-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-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 tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng\"}]},{\"@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\/0790996b964a39ecaeee5b5cabc821b5\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3","description":"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.","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-trung-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng","og_description":"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-09-20T03:47:30+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"18 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/0790996b964a39ecaeee5b5cabc821b5"},"headline":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng","datePublished":"2025-09-20T03:47:30+00:00","dateModified":"2025-09-20T03:47:30+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/"},"wordCount":3133,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/","name":"C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg","datePublished":"2025-09-20T03:47:30+00:00","dateModified":"2025-09-20T03:47:30+00:00","description":"B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc tr\u00f9ng trong Microsoft Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t, gi\u00fap b\u1ea1n nhanh ch\u00f3ng l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng t\u00ednh.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/cach-loc-trung-trong-excel.jpg","width":1200,"height":628,"caption":"cach-loc-trung-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-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 tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng"}]},{"@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\/0790996b964a39ecaeee5b5cabc821b5","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/491718","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\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=491718"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/491718\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/491719"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=491718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=491718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=491718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}