{"id":387121,"date":"2024-09-17T20:11:11","date_gmt":"2024-09-17T13:11:11","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=387121"},"modified":"2024-09-17T20:11:11","modified_gmt":"2024-09-17T13:11:11","slug":"cach-loc-du-lieu-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/","title":{"rendered":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111ang x\u1eed l\u00fd file Excel v\u00e0 th\u1ea5y c\u00f3 qu\u00e1 nhi\u1ec1u d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng bi\u1ebft c\u00e1ch gi\u1ea3i quy\u1ebft nh\u01b0 th\u1ebf n\u00e0o? Hay b\u1ea1n c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u Excel theo t\u1eebng ti\u00eau ch\u00ed kh\u00e1c nhau m\u00e0 ch\u01b0a t\u00ecm \u0111\u01b0\u1ee3c th\u1ee7 thu\u1eadt? V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 t\u00ecm \u0111\u1ebfn \u0111\u00fang b\u00e0i vi\u1ebft r\u1ed3i nh\u00e9. Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n <\/span><b>2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01a1n gi\u1ea3n m\u00e0 ai c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>L\u1ecdc d\u1eef li\u1ec7u trong Excel l\u00e0 g\u00ec?<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ecdc d\u1eef li\u1ec7u trong Excel l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng quan tr\u1ecdng gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd v\u00e0 ph\u00e2n t\u00edch th\u00f4ng tin t\u1eeb b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3. Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c t\u00ecm ki\u1ebfm v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng tin theo \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh l\u00e0 c\u1ea7n thi\u1ebft. V\u00e0 \u0111\u00f3 ch\u00ednh l\u00e0 l\u00fac t\u00ednh n\u0103ng l\u1ecdc d\u1eef li\u1ec7u tr\u1edf n\u00ean h\u1eefu \u00edch.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-387123 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1.jpg\" alt=\"cach-loc-du-lieu-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng hi\u1ec3n th\u1ecb ch\u1ec9 nh\u1eefng h\u00e0ng th\u1ecfa m\u00e3n c\u00e1c ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. N\u00f3 gi\u00fap b\u1ecf qua nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan v\u00e0 t\u1eadp trung v\u00e0o th\u00f4ng tin c\u1ea7n thi\u1ebft. T\u00ednh n\u0103ng n\u00e0y kh\u00f4ng ch\u1ec9 ti\u1ebft ki\u1ec7m th\u1eddi gian m\u00e0 c\u00f2n t\u0103ng c\u01b0\u1eddng hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c khi ph\u00e2n t\u00edch v\u00e0 so s\u00e1nh d\u1eef li\u1ec7u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c bi\u1ebft c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ee3i \u00edch c\u1ee7a th\u1ee7 thu\u1eadt n\u00e0y r\u1ea5t \u0111a d\u1ea1ng v\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng \u01b0u \u0111i\u1ec3m n\u00e0y \u0111\u1ec3 t\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c tri\u1ec7t \u0111\u1ec3 t\u00ednh n\u0103ng c\u1ee7a Excel nh\u00e9.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>T\u0103ng t\u00ednh ch\u00ednh x\u00e1c trong ph\u00e2n t\u00edch<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi \u00e1p d\u1ee5ng c\u00e1c b\u1ed9 l\u1ecdc, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u1ea9n \u0111i c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan ho\u1eb7c kh\u00f4ng c\u1ea7n thi\u1ebft cho m\u1ee5c ti\u00eau ph\u00e2n t\u00edch. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi danh s\u00e1ch d\u1eef li\u1ec7u b\u00e1n h\u00e0ng. Vi\u1ec7c l\u1ecdc ra c\u00e1c s\u1ea3n ph\u1ea9m kh\u00f4ng thu\u1ed9c nh\u00f3m h\u00e0ng b\u1ea1n \u0111ang quan t\u00e2m s\u1ebd gi\u00fap b\u1ea1n t\u1eadp trung v\u00e0o c\u00e1c s\u1ea3n ph\u1ea9m m\u1ee5c ti\u00eau. T\u1eeb \u0111\u00f3 ph\u00e2n t\u00edch ch\u00ednh x\u00e1c h\u01a1n v\u1ec1 doanh thu ho\u1eb7c hi\u1ec7u su\u1ea5t b\u00e1n h\u00e0ng c\u1ee7a nh\u00f3m s\u1ea3n ph\u1ea9m \u0111\u00f3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-387124 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2.jpg\" alt=\"cach-loc-du-lieu-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng s\u1ebd d\u1ec5 d\u00e0ng x\u1ea3y ra sai s\u00f3t do vi\u1ec7c ph\u00e2n t\u00edch sai th\u00f4ng tin ho\u1eb7c b\u1ecf s\u00f3t d\u1eef li\u1ec7u quan tr\u1ecdng. B\u1eb1ng <\/span><b>c\u00e1ch l\u1ecdc trong Excel<\/b><span style=\"font-weight: 400;\"> gi\u00fap gi\u1ea3m thi\u1ec3u nh\u1eefng r\u1ee7i ro n\u00e0y b\u1eb1ng c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a qu\u00e1 tr\u00ecnh ch\u1ecdn l\u1ecdc th\u00f4ng tin. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng c\u00e1c b\u1ed9 l\u1ecdc d\u1ef1a tr\u00ean c\u00e1c ti\u00eau ch\u00ed. Ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1ed1 li\u1ec7u, ng\u00e0y th\u00e1ng, ho\u1eb7c t\u1eeb kh\u00f3a, gi\u00fap vi\u1ec7c l\u1ecdc v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. Thay v\u00ec ph\u1ea3i s\u00e0ng l\u1ecdc t\u1eebng m\u1ee5c d\u1eef li\u1ec7u, b\u1ed9 l\u1ecdc gi\u00fap b\u1ea1n t\u00ecm \u0111\u00fang th\u00f4ng tin m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, gi\u1ea3m thi\u1ec3u c\u00e1c l\u1ed7i kh\u00f4ng \u0111\u00e1ng c\u00f3.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>D\u1ec5 d\u00e0ng t\u1ed5ng h\u1ee3p v\u00e0 so s\u00e1nh d\u1eef li\u1ec7u<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng c\u1ee5 l\u1ecdc trong Excel h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng so s\u00e1nh d\u1eef li\u1ec7u gi\u1eefa c\u00e1c nh\u00f3m v\u1edbi nhau m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i thao t\u00e1c ph\u1ee9c t\u1ea1p. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng l\u1ecdc \u0111\u1ec3 ch\u1ecdn ra c\u00e1c nh\u00f3m d\u1eef li\u1ec7u kh\u00e1c nhau v\u00e0 so s\u00e1nh c\u00e1c gi\u00e1 tr\u1ecb gi\u1eefa ch\u00fang. Ch\u1eb3ng h\u1ea1n, khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a th\u00f4ng tin v\u1ec1 doanh s\u1ed1 b\u00e1n h\u00e0ng c\u1ee7a c\u00e1c khu v\u1ef1c kh\u00e1c nhau. B\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc theo t\u1eebng khu v\u1ef1c c\u1ee5 th\u1ec3 \u0111\u1ec3 so s\u00e1nh doanh s\u1ed1 v\u00e0 \u0111\u01b0a ra nh\u1eadn \u0111\u1ecbnh v\u1ec1 khu v\u1ef1c n\u00e0o \u0111ang ho\u1ea1t \u0111\u1ed9ng t\u1ed1t h\u01a1n. Vi\u1ec7c so s\u00e1nh n\u00e0y di\u1ec5n ra nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng ch\u1ec9 v\u1edbi v\u00e0i c\u00fa click chu\u1ed9t nh\u1edd v\u00e0o <\/span><b>c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/b><span style=\"font-weight: 400;\"> m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter wp-image-387125 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3.jpg\" alt=\"cach-loc-du-lieu-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u01a1n n\u1eefa, vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u kh\u00f4ng ch\u1ec9 h\u1eefu \u00edch trong c\u00e1c l\u0129nh v\u1ef1c nh\u01b0 t\u00e0i ch\u00ednh hay k\u1ebf to\u00e1n m\u00e0 c\u00f2n \u1ee9ng d\u1ee5ng linh ho\u1ea1t trong nhi\u1ec1u ng\u00e0nh ngh\u1ec1 kh\u00e1c. T\u1eeb qu\u1ea3n l\u00fd d\u1ef1 \u00e1n, ph\u00e2n t\u00edch b\u00e1n h\u00e0ng cho \u0111\u1ebfn vi\u1ec7c theo d\u00f5i ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c. B\u1ea5t k\u1ef3 ai l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u s\u1ed1 \u0111\u1ec1u c\u00f3 th\u1ec3 h\u01b0\u1edfng l\u1ee3i t\u1eeb t\u00ednh n\u0103ng n\u00e0y. \u0110i\u1ec1u n\u00e0y l\u00e0m cho vi\u1ec7c t\u1ed5ng h\u1ee3p v\u00e0 so s\u00e1nh d\u1eef li\u1ec7u tr\u1edf th\u00e0nh m\u1ed9t nhi\u1ec7m v\u1ee5 d\u1ec5 d\u00e0ng, kh\u00f4ng \u0111\u00f2i h\u1ecfi ph\u1ea3i c\u00f3 c\u00e1c k\u1ef9 n\u0103ng ph\u00e2n t\u00edch ph\u1ee9c t\u1ea1p.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>H\u1ed7 tr\u1ee3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u ch\u00ednh x\u00e1c<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t quy\u1ebft \u0111\u1ecbnh \u0111\u00fang \u0111\u1eafn lu\u00f4n c\u1ea7n d\u1ef1a tr\u00ean d\u1eef li\u1ec7u ph\u00e2n t\u00edch ch\u00ednh x\u00e1c. <\/span><b>C\u00e1ch l\u1ecdc trong Excel <\/b><span style=\"font-weight: 400;\">gi\u00fap b\u1ea1n gi\u1ea3m thi\u1ec3u sai s\u00f3t trong qu\u00e1 tr\u00ecnh ph\u00e2n t\u00edch, nh\u1edd v\u00e0o kh\u1ea3 n\u0103ng s\u1eafp x\u1ebfp v\u00e0 ch\u1ecdn l\u1ecdc c\u00e1c th\u00f4ng tin m\u1ed9t c\u00e1ch c\u00f3 h\u1ec7 th\u1ed1ng. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n xem x\u00e9t hi\u1ec7u su\u1ea5t b\u00e1n h\u00e0ng c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3 trong m\u1ed9t giai \u0111o\u1ea1n nh\u1ea5t \u0111\u1ecbnh. B\u1ed9 l\u1ecdc s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng hi\u1ec3n th\u1ecb \u0111\u00fang d\u1eef li\u1ec7u \u0111\u00f3 m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ecm ki\u1ebfm th\u1ee7 c\u00f4ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387126 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4.jpg\" alt=\"cach-loc-du-lieu-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1eb7c bi\u1ec7t khi ra quy\u1ebft \u0111\u1ecbnh, b\u1ea1n kh\u00f4ng nh\u1eefng d\u1ef1a v\u00e0o c\u00e1c con s\u1ed1 hi\u1ec7n t\u1ea1i, m\u00e0 c\u00f2n c\u1ea7n ph\u1ea3i d\u1ef1 \u0111o\u00e1n xu h\u01b0\u1edbng t\u01b0\u01a1ng lai. Vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng nh\u00ecn th\u1ea5y c\u00e1c xu h\u01b0\u1edbng \u1ea9n gi\u1ea5u b\u00ean trong d\u1eef li\u1ec7u th\u00f4. Nh\u01b0 th\u1ebf, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh gi\u00e1 s\u1ef1 t\u0103ng tr\u01b0\u1edfng ho\u1eb7c s\u1ef1 suy gi\u1ea3m c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m, d\u1ecbch v\u1ee5 ho\u1eb7c th\u1ecb tr\u01b0\u1eddng c\u1ee5 th\u1ec3. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n ph\u00e2n t\u00edch doanh thu h\u00e0ng th\u00e1ng v\u00e0 ph\u00e1t hi\u1ec7n ra r\u1eb1ng m\u1ed9t s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3 \u0111ang c\u00f3 xu h\u01b0\u1edbng gi\u1ea3m doanh thu. Vi\u1ec7c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n s\u1edbm c\u00f3 nh\u1eefng bi\u1ec7n ph\u00e1p \u0111i\u1ec1u ch\u1ec9nh chi\u1ebfn l\u01b0\u1ee3c kinh doanh ho\u1eb7c ti\u1ebfp th\u1ecb \u0111\u1ec3 c\u1ea3i thi\u1ec7n t\u00ecnh h\u00ecnh.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel b\u1eb1ng b\u1ed9 l\u1ecdc Filter<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ed9 l\u1ecdc (Filter) trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng s\u1eafp x\u1ebfp, l\u1ecdc v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i ho\u1eb7c x\u00f3a d\u1eef li\u1ec7u g\u1ed1c. V\u1edbi Filter, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm th\u00f4ng tin nhanh ch\u00f3ng, ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c h\u01a1n v\u00e0 d\u1ec5 d\u00e0ng so s\u00e1nh c\u00e1c nh\u00f3m d\u1eef li\u1ec7u kh\u00e1c nhau.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n bi\u1ebft c\u00e1ch m\u1edf b\u1ed9 l\u1ecdc b\u1eb1ng c\u00e1ch m\u1edf file Excel ch\u1ee9a d\u1eef li\u1ec7u. Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n c\u1ea7n ch\u1ecdn v\u00f9ng ch\u1ecdn mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387127 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5.jpg\" alt=\"cach-loc-du-lieu-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n h\u00e3y truy c\u1eadp v\u00e0o &#8220;Home&#8221; tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a &#8220;Excel&#8221; v\u00e0 ch\u1ecdn &#8220;Sort &amp; Filter&#8221;, ti\u1ebfp ch\u1ecdn &#8220;Filter&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387128 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6.jpg\" alt=\"cach-loc-du-lieu-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u1ea1n \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn c\u1ed9t m\u00e0 m\u00ecnh mu\u1ed1n l\u1ecdc v\u00e0 ch\u1ecdn v\u00e0o m\u0169i t\u00ean h\u01b0\u1edbng xu\u1ed1ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387129 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7.jpg\" alt=\"cach-loc-du-lieu-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: K\u1ebf \u0111\u1ebfn b\u1ea1n c\u1ea7n b\u1ecf ch\u1ecdn \u00f4 &#8220;Select All&#8221; v\u00e0 ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng. K\u1ebft th\u00fac thao t\u00e1c l\u00e0 nh\u1ea5n ch\u1ecdn &#8220;OK&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387130 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8.jpg\" alt=\"cach-loc-du-lieu-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: B\u1ea1n ki\u1ec3m tra k\u1ebft qu\u1ea3 th\u00ec s\u1ebd \u0111\u01b0\u1ee3c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00ecnh \u1ea3nh minh h\u1ecda nh\u00e9.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387131 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9.jpg\" alt=\"cach-loc-du-lieu-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel b\u1eb1ng h\u00e0m Filter<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u00e0m Filter cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng l\u1ecdc d\u1eef li\u1ec7u t\u1eeb m\u1ed9t ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. Kh\u00e1c v\u1edbi b\u1ed9 l\u1ecdc Filter th\u00f4ng th\u01b0\u1eddng, h\u00e0m FILTER tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u0111\u1ed9ng, ngh\u0129a l\u00e0 khi d\u1eef li\u1ec7u ngu\u1ed3n thay \u0111\u1ed5i, k\u1ebft qu\u1ea3 l\u1ecdc c\u0169ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt. H\u00e0m n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n tr\u00edch xu\u1ea5t v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng l\u1edbn m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng \u0111\u1ebfn c\u00e1c thao t\u00e1c th\u1ee7 c\u00f4ng ho\u1eb7c b\u1ea3ng ph\u1ee5.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1i <\/span><b>c\u00e1ch l\u1ecdc trong Excel <\/b><span style=\"font-weight: 400;\">b\u1eb1ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m Filter &#8220;=FILTER(array,include,[if_empty])&#8221;.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387132 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10.jpg\" alt=\"cach-loc-du-lieu-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, array l\u00e0 ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc. C\u00f2n include l\u00e0 \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c ti\u00eau ch\u00ed l\u1ecdc (m\u1ed9t bi\u1ec3u th\u1ee9c logic), c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ea3ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n TRUE s\u1ebd \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1. V\u00e0 if_empty ch\u00ednh l\u00e0 t\u00f9y ch\u1ecdn, gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 n\u1ebfu kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 n\u00e0o th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc. N\u1ebfu kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh, Excel s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #CALC! n\u1ebfu d\u1eef li\u1ec7u kh\u00f4ng th\u1ecfa m\u00e3n ti\u00eau ch\u00ed.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd quan tr\u1ecdng l\u00e0 ch\u1ec9 c\u00f3 phi\u00ean b\u1ea3n Excel 2019 v\u00e0 Excel 365 th\u00ec m\u1edbi h\u1ed7 tr\u1ee3 h\u00e0m filter th\u00f4i b\u1ea1n nh\u00e9.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel b\u1ecb tr\u00f9ng<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel l\u00e0 qu\u00e1 tr\u00ecnh x\u00e1c \u0111\u1ecbnh v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c d\u00f2ng c\u00f3 gi\u00e1 tr\u1ecb tr\u00f9ng nhau trong m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u g\u1ecdn g\u00e0ng, tr\u00e1nh tr\u00f9ng l\u1eb7p kh\u00f4ng c\u1ea7n thi\u1ebft. Nh\u01b0 th\u1ebf s\u1ebd gi\u00fap ph\u00e2n t\u00edch v\u00e0 b\u00e1o c\u00e1o d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. Excel cung c\u1ea5p c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 ph\u01b0\u01a1ng ph\u00e1p d\u1ec5 s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc v\u00e0 x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p, nh\u01b0 ch\u1ee9c n\u0103ng Remove Duplicates v\u00e0 Conditional Formatting.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00e0 trong ph\u1ea7n n\u1ed9i dung n\u00e0y Ho\u00e0ng H\u00e0 Mobile s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u b\u1ecb trong d\u00e0nh cho t\u1ea5t c\u1ea3 phi\u00ean b\u1ea3n Excel t\u1eeb c\u0169 cho \u0111\u1ebfn m\u1edbi nh\u1ea5t nh\u00e9.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><b>Excel 2019, 2016, 2013<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y t\u00f4 \u0111en nh\u1eefng c\u1ed9t m\u00e0 m\u00ecnh mu\u1ed1n l\u1ecdc th\u00f4ng tin v\u00e0 ch\u1ecdn v\u00e0o t\u00ednh n\u0103ng &#8220;Remove Duplicates&#8221; t\u1ea1i thanh c\u00f4ng c\u1ee5 &#8220;Data&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387133 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11.jpg\" alt=\"cach-loc-du-lieu-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nhanh ch\u00f3ng h\u1ed9p th\u00f4ng tin &#8220;Remove Duplicates&#8221; xu\u1ea5t hi\u1ec7n v\u00e0 cung c\u1ea5p cho b\u1ea1n 2 s\u1ef1 l\u1ef1a ch\u1ecdn. \u0110\u1ea7u ti\u00ean l\u00e0 &#8220;Select All&#8221; t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u tr\u00f9ng trong v\u00f9ng ch\u1ecdn. V\u00e0 hai l\u00e0 &#8220;Unselect All&#8221; ch\u1ec9 l\u1ef1a ch\u1ecdn m\u1ed9t s\u1ed1 tr\u01b0\u1eddng nh\u1ea5t \u0111\u1ecbnh \u0111\u1ec3 l\u1ecdc. Sau khi ch\u1ecdn xong th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n &#8220;OK&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387134 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12.jpg\" alt=\"cach-loc-du-lieu-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c \u0111o\u1ea1n th\u00f4ng b\u00e1o v\u1ec1 <\/span><b>c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel <\/b><span style=\"font-weight: 400;\">n\u00e0y. C\u1ee5 th\u1ec3 th\u00f4ng b\u00e1o g\u1ed3m c\u00e1c n\u1ed9i dung l\u00e0 s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u tr\u00f9ng, s\u1ed1 d\u1eef li\u1ec7u b\u1ecb x\u00f3a v\u00e0 t\u1ed5ng s\u1ed1 gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eeda l\u1ea1i. B\u1ea1n s\u1ebd \u0111\u1ecdc d\u1eef li\u1ec7u v\u00e0 ch\u1ecdn &#8220;OK&#8221; l\u00e0 xong nh\u00e9.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387135 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13.jpg\" alt=\"cach-loc-du-lieu-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><b>Excel 2010, 2007<\/b><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n c\u0169ng s\u1ebd b\u00f4i \u0111en ch\u1ecdn v\u00f9ng ch\u1ecdn mu\u1ed1n x\u1eed l\u00fd th\u00f4ng tin. Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n c\u1ea7n ch\u1ecdn &#8220;Conditional Formatting&#8221; \u1edf m\u1ee5c &#8220;Home&#8221;. Sau \u0111\u00f3 l\u1ea7n l\u01b0\u1ee3t l\u00e0 ch\u1ecdn &#8220;Highlight Cells Rules&#8221; v\u00e0 &#8220;Duplicate Value&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387136 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14.jpg\" alt=\"cach-loc-du-lieu-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Khi b\u1ea1n th\u1ef1c hi\u1ec7n <\/span><b>c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel <\/b><span style=\"font-weight: 400;\">n\u00e0y th\u00ec s\u1ebd xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i &#8220;Duplicate Value&#8221;. V\u1edbi &#8220;Values with&#8221; l\u00e0 l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u tr\u00f9ng \u0111\u01b0\u1ee3c ph\u00e2n chia. \u1ede \u00f4 t\u00ednh n\u0103ng b\u00ean c\u1ea1nh, n\u1ebfu b\u1ea1n ch\u1ecdn &#8220;Unique&#8221; th\u00ec s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb duy nh\u1ea5t. C\u00f2n n\u1ebfu b\u1ea1n ch\u1ecdn &#8220;Duplicate&#8221; th\u00ec b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387137 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15.jpg\" alt=\"cach-loc-du-lieu-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><b>L\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch l\u1ecdc trong Excel<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi ti\u1ebfn h\u00e0nh <\/span><b>c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/b><span style=\"font-weight: 400;\">, \u0111i\u1ec1u quan tr\u1ecdng \u0111\u1ea7u ti\u00ean l\u00e0 ph\u1ea3i \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng b\u1ecb l\u1ed7i ho\u1eb7c thi\u1ebfu s\u00f3t. D\u1eef li\u1ec7u b\u1ecb thi\u1ebfu ho\u1eb7c kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t c\u00f3 th\u1ec3 l\u00e0m sai l\u1ec7ch k\u1ebft qu\u1ea3 khi l\u1ecdc. V\u00ed d\u1ee5, c\u00e1c \u00f4 tr\u1ed1ng ho\u1eb7c d\u1eef li\u1ec7u b\u1ecb nh\u1eadp sai (ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1ed1 v\u00e0 v\u0103n b\u1ea3n trong c\u00f9ng m\u1ed9t c\u1ed9t) c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn vi\u1ec7c Excel kh\u00f4ng l\u1ecdc \u0111\u00fang c\u00e1ch ho\u1eb7c lo\u1ea1i b\u1ecf nh\u1eefng d\u00f2ng quan tr\u1ecdng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u01a1n n\u1eefa, Excel cung c\u1ea5p nhi\u1ec1u t\u00f9y ch\u1ecdn l\u1ecdc, t\u1eeb l\u1ecdc d\u1eef li\u1ec7u theo s\u1ed1, v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng cho \u0111\u1ebfn l\u1ecdc d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n t\u00f9y ch\u1ec9nh nh\u01b0 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf ho\u1eb7c t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn theo m\u1ed9t ng\u01b0\u1ee1ng c\u1ee5 th\u1ec3. Ch\u00ednh v\u00ec th\u1ebf, vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1c t\u00f9y ch\u1ecdn l\u1ecdc n\u00e0y l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o b\u1ea1n \u00e1p d\u1ee5ng \u0111\u00fang \u0111i\u1ec1u ki\u1ec7n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 mong mu\u1ed1n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-387138 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16.jpg\" alt=\"cach-loc-du-lieu-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed3ng th\u1eddi khi l\u1ecdc d\u1eef li\u1ec7u, Excel s\u1ebd \u1ea9n c\u00e1c d\u00f2ng kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n l\u1ecdc, nh\u01b0ng ch\u00fang kh\u00f4ng b\u1ecb x\u00f3a. Do \u0111\u00f3, n\u1ebfu b\u1ea1n sao ch\u00e9p d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc m\u00e0 kh\u00f4ng \u0111\u1ec3 \u00fd, b\u1ea1n c\u00f3 th\u1ec3 v\u00f4 t\u00ecnh sao ch\u00e9p c\u1ea3 nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u b\u1ecb \u1ea9n. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 g\u00e2y ra nh\u1eefng sai s\u00f3t nghi\u00eam tr\u1ecdng khi b\u1ea1n t\u1ed5ng h\u1ee3p ho\u1eb7c chia s\u1ebb d\u1eef li\u1ec7u.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ra, sau khi l\u1ecdc d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y c\u1ea9n th\u1eadn khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c nh\u01b0 x\u00f3a ho\u1eb7c ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u. V\u00ec Excel ch\u1ec9 \u00e1p d\u1ee5ng thay \u0111\u1ed5i tr\u00ean c\u00e1c d\u00f2ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. C\u00e1c d\u00f2ng d\u1eef li\u1ec7u b\u1ecb \u1ea9n s\u1ebd kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn s\u1ef1 kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t trong d\u1eef li\u1ec7u n\u1ebfu b\u1ea1n kh\u00f4ng ki\u1ec3m tra k\u1ef9.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p style=\"text-align: justify;\"><b>C\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng h\u1eefu \u00edch gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd, ph\u00e2n t\u00edch v\u00e0 x\u1eed l\u00fd c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. Tuy nhi\u00ean, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 ch\u00ednh x\u00e1c v\u00e0 tr\u00e1nh sai s\u00f3t, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n c\u1ea9n th\u1eadn trong vi\u1ec7c ki\u1ec3m tra t\u00ednh to\u00e0n v\u1eb9n c\u1ee7a d\u1eef li\u1ec7u b\u1ea1n nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Xem th\u00eam:<\/b><\/p>\n<ul>\n<li><span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\"><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #339966;\"><strong><a style=\"color: #339966;\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/loi-name-trong-excel\/\">L\u1ed7i NAME trong Excel l\u00e0 g\u00ec? Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/a><\/strong><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111ang x\u1eed l\u00fd file Excel v\u00e0 th\u1ea5y c\u00f3 qu\u00e1 nhi\u1ec1u d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng l\u1eb7p m\u00e0 kh\u00f4ng bi\u1ebft c\u00e1ch gi\u1ea3i quy\u1ebft nh\u01b0 th\u1ebf n\u00e0o? Hay b\u1ea1n c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u Excel theo t\u1eebng ti\u00eau ch\u00ed kh\u00e1c nhau m\u00e0 ch\u01b0a t\u00ecm \u0111\u01b0\u1ee3c th\u1ee7 thu\u1eadt? V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 t\u00ecm \u0111\u1ebfn \u0111\u00fang b\u00e0i vi\u1ebft r\u1ed3i nh\u00e9. [&hellip;]<\/p>\n","protected":false},"author":84,"featured_media":387122,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-387121","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>2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.\" \/>\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-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-17T13:11:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-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=\"Daisy Daisy\" \/>\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=\"Daisy Daisy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 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-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\"},\"author\":{\"name\":\"Daisy Daisy\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c\"},\"headline\":\"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"datePublished\":\"2024-09-17T13:11:11+00:00\",\"dateModified\":\"2024-09-17T13:11:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\"},\"wordCount\":3383,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\",\"name\":\"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg\",\"datePublished\":\"2024-09-17T13:11:11+00:00\",\"dateModified\":\"2024-09-17T13:11:11+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t\"}]},{\"@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\/a7254cd2473ea15c26ef1b1fcd58398c\",\"name\":\"Daisy Daisy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/4261b6751d190cb0b62038d948ff8dbb.jpg?ver=1774865089\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/4261b6751d190cb0b62038d948ff8dbb.jpg?ver=1774865089\",\"caption\":\"Daisy Daisy\"},\"description\":\"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","description":"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.","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-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","og_description":"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-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":"2024-09-17T13:11:11+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg","type":"image\/jpeg"}],"author":"Daisy Daisy","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Daisy Daisy","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/"},"author":{"name":"Daisy Daisy","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/a7254cd2473ea15c26ef1b1fcd58398c"},"headline":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","datePublished":"2024-09-17T13:11:11+00:00","dateModified":"2024-09-17T13:11:11+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/"},"wordCount":3383,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/","name":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg","datePublished":"2024-09-17T13:11:11+00:00","dateModified":"2024-09-17T13:11:11+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn cho b\u1ea1n 2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1ea5t hi\u1ec7n nay v\u00e0 cho ra k\u1ebft qu\u1ea3 r\u1ea5t ch\u00ednh x\u00e1c.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/cach-loc-du-lieu-trong-excel.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-du-lieu-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"2 c\u00e1ch l\u1ecdc d\u1eef li\u1ec7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t"}]},{"@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\/a7254cd2473ea15c26ef1b1fcd58398c","name":"Daisy Daisy","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/4261b6751d190cb0b62038d948ff8dbb.jpg?ver=1774865089","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/4261b6751d190cb0b62038d948ff8dbb.jpg?ver=1774865089","caption":"Daisy Daisy"},"description":"M\u00ecnh l\u00e0 Daisy, m\u1ed9t ng\u01b0\u1eddi d\u00f9ng th\u00edch kh\u00e1m ph\u00e1 c\u00f4ng ngh\u1ec7 v\u00e0 chia s\u1ebb nh\u1eefng tr\u1ea3i nghi\u1ec7m th\u1ef1c t\u1ebf. C\u1ea3m \u01a1n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 \u0111\u1ecdc v\u00e0 chia s\u1ebb b\u00e0i vi\u1ebft c\u1ee7a m\u00ecnh nh\u00e9.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-bao-ni\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/387121","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\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=387121"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/387121\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/387122"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=387121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=387121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=387121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}