{"id":297038,"date":"2023-12-18T14:03:03","date_gmt":"2023-12-18T07:03:03","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=297038"},"modified":"2023-12-18T14:03:03","modified_gmt":"2023-12-18T07:03:03","slug":"ham-unique","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel"},"content":{"rendered":"<p><b>H\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel r\u1ea5t h\u1eefu \u00edch gi\u00fap m\u1ecdi ng\u01b0\u1eddi gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng. V\u1eady c\u00fa ph\u00e1p c\u1ee7a UNIQUE l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00fa ph\u00e1p UNIQUE trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p? M\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c UNIQUE trong Excel nh\u00e9!\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m UNIQUE l\u00e0 g\u00ec?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Unique l\u00e0 h\u00e0m \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh. K\u1ebft c\u1ee7a c\u1ee7a c\u00f4ng th\u1ee9c UNIQUE gi\u00fap l\u1ecdc ra gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n t\u00ecm m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, kh\u00f4ng t\u1ed1n nhi\u1ec1u th\u1eddi gian. H\u01a1n n\u1eefa, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p UNIQUE v\u1edbi c\u00e1c h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch chuy\u00ean nghi\u1ec7p.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-297118 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-2.jpg\" alt=\"ham-unique-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m UNIQUE nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><strong>=UNIQUE(array, [by_col], [occurs_once])\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Array ch\u00ednh l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n l\u1ecdc gi\u00e1 tr\u1ecb.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[by_col] l\u00e0 tham s\u1ed1 \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh gi\u00e1 tr\u1ecb FALSE (n\u1ebfu s\u1eafp x\u1ebfp theo h\u00e0ng) v\u00e0 TRUE (n\u1ebfu s\u1eafp x\u1ebfp theo c\u1ed9t).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[occurs_once] l\u00e0 tham s\u1ed1 m\u1eb7c \u0111\u1ecbnh gi\u00e1 tr\u1ecb FALSE (n\u1ebfu mu\u1ed1n l\u1ea5y m\u1ed9t \u0111\u1ea1i di\u1ec7n cho c\u00e1c gi\u00e1 tr\u1ecb) v\u00e0 TRUE (n\u1ebfu l\u1ea5y nh\u1eefng gi\u00e1 tr\u1ecb ch\u1ec9 xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n).\u00a0<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE trong Excel d\u1ec5 hi\u1ec3u\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00fa ph\u00e1p UNIQUE trong Excel, \u0111\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n c\u00e1ch d\u00f9ng, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3. L\u01b0u \u00fd, \u0111\u1ec3 k\u1ebft qu\u1ea3 h\u00e0m ch\u00ednh x\u00e1c, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng UNIQUE \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Ch\u1eb3ng h\u1ea1n trong b\u1ea3ng d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb t\u00ean c\u1ee7a c\u00e1c t\u1ec9nh th\u00e0nh. Tuy nhi\u00ean, c\u00e1c d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng nhau, b\u1ea1n mu\u1ed1n l\u1ecdc l\u1ea5y m\u1ed9t gi\u00e1 tr\u1ecb duy nh\u1ea5t th\u00ec th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-297119 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-3.jpg\" alt=\"ham-unique-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i v\u1ecb tr\u00ed c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, c\u00e1c b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =UNIQUE(A2:A10).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-297120 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-4.jpg\" alt=\"ham-unique-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n h\u00e3y nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 k\u1ebft qu\u1ea3 xu\u1ea5t hi\u1ec7n. Nh\u01b0 v\u1eady, <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> s\u1ebd gi\u00fap b\u1ea1n l\u1ecdc ra d\u1eef li\u1ec7u duy nh\u1ea5t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, thu\u1eadn ti\u1ec7n.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297121 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-5.jpg\" alt=\"ham-unique-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng UNIQUE k\u1ebft h\u1ee3p v\u1edbi h\u00e0m SORT\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">SORT l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo \u00fd mu\u1ed1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u0111\u1ec3 d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd. M\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SORT \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u t\u0103ng &#8211; gi\u1ea3m d\u1ea7n, theo ch\u1eef c\u00e1i,&#8230; H\u00e0m SORT c\u00f3 c\u00f4ng th\u1ee9c <strong>=SORT(array, sort_index, sort_order, by_col)<\/strong>. Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">array l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">sort_index l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u s\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u00f3 th\u1ec3 l\u00e0 c\u1ed9t\/ d\u00f2ng \u0111\u1ea7u ti\u00ean hay c\u1ed9t\/ d\u00f2ng th\u1ee9 m\u1ea5y \u0111\u1ec1u \u0111\u01b0\u1ee3c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">sort_order d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo ti\u00eau ch\u00ed t\u0103ng &#8211; gi\u1ea3m tu\u1ef3 thu\u1ed9c v\u00e0o nhu c\u1ea7u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">by_col ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp theo c\u1ed9t ho\u1eb7c d\u00f2ng nh\u01b0 h\u1ec7 th\u1ed1ng s\u1ebd m\u1eb7c \u0111\u1ecbnh theo c\u1ed9t.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m SORT c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 sau khi l\u1ecdc d\u1eef li\u1ec7u, h\u1ec7 th\u1ed1ng s\u1ebd s\u1eafp x\u1ebfp. \u0110i\u1ec1u n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng, chuy\u00ean nghi\u1ec7p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau, \u0111\u1ea7u ti\u00ean c\u00e1c b\u1ea1n h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =SORT(UNIQUE(A2:A10)) t\u1ea1i v\u1ecb tr\u00ed mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297122 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-6.jpg\" alt=\"ham-unique-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp theo, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n ph\u00edm Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 l\u1ea5y ra gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u1ed3ng th\u1eddi s\u1eafp x\u1ebfp ch\u00fang theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297123 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-7.jpg\" alt=\"ham-unique-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng UNIQUE \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong b\u1ea3ng<\/span><\/h3>\n<p><b>H\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> c\u00f2n \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau ch\u1eb3ng h\u1ea1n nh\u01b0 danh s\u00e1ch b\u00e1n h\u00e0ng c\u1ee7a nh\u00e2n vi\u00ean. Ch\u00fang t\u00f4i s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9 UNIQUE trong b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi d\u1ec5 h\u00ecnh dung.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297124 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-8.jpg\" alt=\"ham-unique-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 trong b\u1ea3ng h\u00e3y nh\u1eadp c\u00fa ph\u00e1p\u00a0 =UNIQUE(B3:D3;TRUE;FALSE).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297125 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-9.jpg\" alt=\"ham-unique-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: C\u00e1c b\u1ea1n h\u00e3y nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297126 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-10.jpg\" alt=\"ham-unique-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: T\u1eeb v\u1ecb tr\u00ed hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, b\u1ea1n h\u00e3y gi\u1eef v\u00e0 k\u00e9o h\u00ecnh vu\u00f4ng nh\u1ecf xu\u1ed1ng nh\u1eefng d\u00f2ng c\u00f2n l\u1ea1i. Nh\u01b0 v\u1eady, b\u1ea1n h\u00e3y ho\u00e0n th\u00e0nh thao t\u00e1c l\u1ecdc gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u b\u1ecb tr\u00f9ng trong c\u1ed9t Excel.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297127 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-11.jpg\" alt=\"ham-unique-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng UNIQUE \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n duy nh\u1ea5t<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u Excel kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u tr\u00f9ng nhau. \u0110\u1ec3 t\u00ecm ra gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t r\u1ea5t \u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\">. C\u00e1c b\u1ea1n h\u00e3y theo d\u00f5i v\u00ed d\u1ee5 sau th\u1ef1c hi\u1ec7n l\u1ecdc gi\u00e1 tr\u1ecb trong Excel \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n nh\u00e9!\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, t\u1ea1i v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 h\u00e3y nh\u1eadp c\u00fa ph\u00e1p =UNIQUE(B2:B10;;TRUE).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297128 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-12.jpg\" alt=\"ham-unique-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, c\u00e1c b\u1ea1n h\u00e3y nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. V\u1edbi hai b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0 tr\u00ean, c\u00e1c b\u1ea1n \u0111\u00e3 l\u1ecdc \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n duy nh\u1ea5t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297130 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-13.jpg\" alt=\"ham-unique-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Filter \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\">, \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong Excel m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Filter. Tr\u01b0\u1edbc khi t\u00ecm hi\u1ec3u h\u00e0m Filter, m\u1ecdi ng\u01b0\u1eddi c\u1ea7n t\u00ecm hi\u1ec3u b\u1ed9 l\u1ecdc Filter. B\u1ed9 l\u1ecdc n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng l\u1ecdc d\u1eef li\u1ec7u theo m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n t\u1eeb ng\u01b0\u1eddi d\u00f9ng. B\u1ed9 l\u1ecdc d\u1eef li\u1ec7u g\u1ed3m m\u1eb7c \u0111\u1ecbnh (Auto Filter) v\u00e0 Advanced Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u n\u00e2ng cao.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m Filter c\u00f3 c\u00fa ph\u00e1p:\u00a0<\/span><\/p>\n<p><strong>=FILTER(array,include,if_empty)\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">array l\u00e0 v\u00f9ng gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc trong b\u1ea3ng t\u00ednh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">include l\u00e0 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0a ra.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">if_empty k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 n\u1ebfu kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o tho\u1ea3 m\u00e3n v\u1edbi \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng b\u1ed9 l\u1ecdc Filter\u00a0\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u1ed9 l\u1ecdc Filter \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p tr\u00ean thanh c\u00f4ng c\u1ee5 Excel v\u00e0 t\u00ecm ki\u1ebfm d\u1ec5 d\u00e0ng. Sau \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 b\u1ed9 l\u1ecdc Filter c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi c\u00f3 c\u00e1i nh\u00ecn tr\u1ef1c quan h\u01a1n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n t\u1ea1o b\u1ed9 l\u1ecdc Filter trong b\u1ea3ng t\u00ednh Excel b\u1eb1ng c\u00e1ch ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297131 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-14.jpg\" alt=\"ham-unique-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n h\u00e3y ch\u1ecdn Sort &amp; Filter t\u1ea1i tab Home sau \u0111\u00f3 ch\u1ecdn Filter.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297132 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-15.jpg\" alt=\"ham-unique-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u m\u1eb7c \u0111\u1ecbnh Auto Filter th\u00ec th\u1ef1c hi\u1ec7n:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n h\u00e3y b\u1ea5m ch\u1ecdn m\u0169i t\u00ean c\u1ea1nh v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfn h\u00e0nh t\u00edch ch\u1ecdn c\u00e1c ti\u00eau ch\u00ed, trong v\u00ed d\u1ee5 n\u00e0y ch\u00fang t\u00f4i t\u00edch ch\u1ecdn l\u1ecdc gi\u1edbi t\u00ednh nam.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297133 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-16.jpg\" alt=\"ham-unique-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n ch\u1ecdn OK. L\u00fac n\u00e0y, h\u1ec7 th\u1ed1ng s\u1ebd hi\u1ec3n th\u1ecb nh\u1eefng ng\u01b0\u1eddi gi\u1edbi t\u00ednh nam, c\u00f2n nh\u1eefng h\u00e0ng kh\u00e1c s\u1ebd b\u1ecb \u1ea9n t\u1ea1m th\u1eddi.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">D\u00f9ng h\u00e0m Filter v\u1edbi \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i d\u00f9ng <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc Filter theo \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao. V\u1edbi c\u00e1ch l\u1ecdc gi\u00e1 tr\u1ecb n\u00e0y \u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i thi\u1ebft l\u1eadp b\u1ea3ng ti\u00eau ch\u00ed l\u1ecdc. D\u1ef1a v\u00e0o \u0111\u00e2y, k\u1ebft qu\u1ea3 sau khi l\u1ecdc d\u1eef li\u1ec7u s\u1ebd \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u c\u1ee7a ng\u01b0\u1eddi d\u00f9ng \u0111\u1ec1 ra.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297135 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-17.jpg\" alt=\"ham-unique-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i tab Data c\u1ee7a b\u1ea3ng t\u00ednh, b\u1ea1n h\u00e3y ch\u1ecdn Sort &amp; Filter ti\u1ebfp theo ch\u1ecdn m\u1ee5c Advanced.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297136 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-18.jpg\" alt=\"ham-unique-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfn h\u00e0nh l\u1ef1a ch\u1ecdn th\u00f4ng s\u1ed1 l\u1ecdc Action (v\u1ecb tr\u00ed xu\u1ea5t hi\u1ec7n k\u1ebft qu\u1ea3), List range (v\u00f9ng gi\u00e1 tr\u1ecb th\u1ef1c hi\u1ec7n l\u1ecdc), Criteria range (b\u1ea3ng ti\u00eau ch\u00ed \u0111\u1ec3 l\u1ecdc), Copy to (v\u1ecb tr\u00ed k\u1ebft qu\u1ea3 l\u1ecdc c\u1ee5 th\u1ec3).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297137 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-19.jpg\" alt=\"ham-unique-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Cu\u1ed1i c\u00f9ng, b\u1ea1n h\u00e3y b\u1ea5m OK \u0111\u1ec3 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb \u0111ang t\u00ecm ki\u1ebfm.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297138 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-20.jpg\" alt=\"ham-unique-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-20-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\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">T\u1edbi \u0111\u00e2y, ch\u1eafc h\u1eb3n m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> trong Excel. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u1ec3 v\u1eeba l\u1ecdc v\u1eeba s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, c\u00e1c b\u1ea1n s\u1ebd k\u1ebft h\u1ee3p h\u00e0m Filter v\u00e0 UNIQUE, c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i h\u01b0\u1edbng d\u1eabn chi ti\u1ebft ph\u00eda tr\u00ean. Tuy nhi\u00ean, nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn c\u00f2n g\u1eb7p v\u1ea5n \u0111\u1ec1 khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c UNIQUE. Hi\u1ec3u \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, sau \u0111\u00e2y ch\u00fang t\u00f4i s\u1ebd gi\u1ea3i \u0111\u00e1p nh\u1eefng th\u1eafc m\u1eafc th\u01b0\u1eddng g\u1eb7p v\u1ec1 c\u00f4ng th\u1ee9c UNIQUE, c\u1ee5 th\u1ec3:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00f3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c h\u00e0m Unique trong Google Sheet kh\u00f4ng?<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Hi\u1ec7n nay, b\u00ean c\u1ea1nh Excel, Google Sheet l\u00e0 m\u1ed9t ti\u1ec7n \u00edch \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng v\u1edbi c\u00e1c t\u00ednh n\u0103ng t\u01b0\u01a1ng t\u1ef1. Do \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong v\u00f9ng d\u1eef li\u1ec7u. V\u1ec1 c\u01a1 b\u1ea3n, c\u00f4ng th\u1ee9c c\u1ee7a UNIQUE v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean nh\u01b0 tr\u00ean, ng\u01b0\u1eddi d\u00f9ng h\u00e3y \u00e1p d\u1ee5ng \u0111\u1ec3 t\u00ecm l\u1ecdc gi\u00e1 tr\u1ecb nhanh ch\u00f3ng. B\u00ean c\u1ea1nh \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ea3m b\u1ea3o nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p, x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc, c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam \u0111i\u1ec1u ki\u1ec7n \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">T\u1ea1i sao xu\u1ea5t hi\u1ec7n l\u1ed7i #REF!\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb nh\u01b0ng k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb #REF! c\u00f3 th\u1ec3 do d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n nh\u1eadp kh\u00f4ng ch\u00ednh x\u00e1c ho\u1eb7c kh\u00f4ng \u0111\u1ee7 kh\u00f4ng gian \u0111\u1ec3 hi\u1ec3n th\u1ecb n\u1ed9i dung c\u1ee7a t\u1ec7p d\u1eef li\u1ec7u. Do \u0111\u00f3, b\u1ea1n h\u00e3y nh\u1eadp \u0111\u00fang c\u00fa ph\u00e1p, x\u00e1c \u0111\u1ecbnh \u0111\u00fang v\u1ecb tr\u00ed v\u00f9ng d\u1eef li\u1ec7u v\u00e0 \u0111i\u1ec1u ki\u1ec7n k\u00e8m theo. N\u1ebfu ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n xo\u00e1 c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 UNIQUE \u0111\u00e3 hi\u1ec3n th\u1ecb th\u00ec h\u00e3y xo\u00e1 v\u1ecb tr\u00ed nh\u1eadp c\u00f4ng th\u1ee9c. Ngo\u00e0i ra, n\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p gi\u00e1 tr\u1ecb UNIQUE tr\u1ea3 v\u1ec1 th\u00ec h\u00e3y nh\u1ea5n t\u1ed5 h\u1ee3p Ctrl + C \u0111\u1ec3 sao ch\u00e9p. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Edit \u0111\u1ec3 ch\u1ec9nh s\u1eeda r\u1ed3i d\u00e1n v\u00e0o v\u1ecb tr\u00ed b\u1ea3ng t\u00ednh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/ham-unique-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-297139 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-21.jpg\" alt=\"ham-unique-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE tr\u00ean c\u00e1c phi\u00ean b\u1ea3n Excel gi\u1ed1ng nhau kh\u00f4ng?\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi m\u1ed7i phi\u00ean b\u1ea3n Excel s\u1ebd c\u00f3 s\u1ef1 kh\u00e1c nhau v\u1ec1 giao di\u1ec7n, tuy nhi\u00ean c\u00e1ch s\u1eed d\u1ee5ng c\u00fa ph\u00e1p UNIQUE gi\u1ed1ng nhau. C\u00e1c b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t nhanh ch\u00f3ng. \u0110\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o c\u00f4ng th\u1ee9c UNIQUE \u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean, l\u1eb7p \u0111i l\u1eb7p l\u1ea1i trong Excel.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p UNIQUE<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">UNIQUE l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh. Do \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng h\u00e3y x\u00e1c \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc trong Excel. Ngo\u00e0i ra, khi nh\u1eadp c\u00fa ph\u00e1p h\u00e0m, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n \u0111\u1ea3m b\u1ea3o c\u00e1c gi\u00e1 tr\u1ecb tham chi\u1ebfu ch\u00ednh x\u00e1c. C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p UNIQUE v\u1edbi h\u00e0m SORT \u0111\u1ec3 sau khi l\u1ecdc gi\u00e1 tr\u1ecb h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng t\u1ed1n th\u1eddi gian l\u00e0m thao t\u00e1c th\u1ee7 c\u00f4ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ghi nh\u1edb c\u00f4ng th\u1ee9c UNIQUE, ng\u01b0\u1eddi d\u00f9ng h\u00e3y \u00e1p d\u1ee5ng m\u1ed7i khi c\u1ea7n l\u1ecdc gi\u00e1 tr\u1ecb. Vi\u1ec7c l\u1eb7p l\u1ea1i c\u1ee7a thao t\u00e1c s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng ghi nh\u1edb l\u00e2u h\u01a1n. Ngo\u00e0i ra, khi s\u1eed d\u1ee5ng c\u00fa ph\u00e1p UNIQUE trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n tr\u00e1nh nh\u1eadp sai d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 b\u00e1o l\u1ed7i. \u0110\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc Filter, h\u00e0m Filter. Ng\u01b0\u1eddi d\u00f9ng h\u00e3y \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c linh ho\u1ea1t \u0111\u1ec3 \u0111\u1ea1t n\u0103ng su\u1ea5t lao \u0111\u1ed9ng nh\u00e9!\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">T\u1ea1m K\u1ebft\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft tr\u00ean, ch\u00fang t\u00f4i \u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng <\/span><b>h\u00e0m UNIQUE<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u cho c\u00e1c b\u1ea1n tham kh\u1ea3o. V\u1edbi m\u1ed7i c\u00e1ch l\u1ecdc gi\u00e1 tr\u1ecb, ch\u00fang t\u00f4i \u0111\u00e3 h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc chi ti\u1ebft. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 k\u1ebf h\u1ee3p c\u00fa ph\u00e1p UNIQUE v\u1edbi h\u00e0m SORT \u0111\u1ec3 l\u1ecdc \u0111\u1ed3ng th\u1eddi s\u1eafp x\u1ebfp gi\u00e1 tr\u1ecb theo mong mu\u1ed1n. Ngo\u00e0i UNIQUE, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m Filter \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel ti\u1ec7n l\u1ee3i.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e3y b\u1ea5m follow fanpage <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> v\u00e0 k\u00eanh Youtube <\/span><b>Ho\u00e0ng H\u00e0 Channel<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 kh\u00f4ng b\u1ecf l\u1ee1 nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch t\u1eeb ch\u00fang t\u00f4i nh\u00e9!<\/span><\/p>\n<p><strong>XEM TH\u00caM:<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-importrange\/\">C\u00e1ch d\u00f9ng h\u00e0m IMPORTRANGE trong Google Sheets<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-trim\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRIM trong Excel c\u00f3 v\u00ed d\u1ee5 minh ho\u1ea1<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-so-sanh-trong-excel\/\">C\u00e1ch d\u00f9ng h\u00e0m so s\u00e1nh \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u 2 c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n chi ti\u1ebft nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel r\u1ea5t h\u1eefu \u00edch gi\u00fap m\u1ecdi ng\u01b0\u1eddi gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng. V\u1eady c\u00fa ph\u00e1p c\u1ee7a UNIQUE l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng c\u00fa ph\u00e1p UNIQUE trong t\u1eebng tr\u01b0\u1eddng h\u1ee3p? M\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 bi\u1ebft c\u00e1ch [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":297117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-297038","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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 s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel<\/title>\n<meta name=\"description\" content=\"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!\" \/>\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\/ham-unique\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-18T07:03:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.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=\"H\u1ed3ng Th\u01a1\" \/>\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=\"H\u1ed3ng Th\u01a1\" \/>\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\/ham-unique\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\",\"datePublished\":\"2023-12-18T07:03:03+00:00\",\"dateModified\":\"2023-12-18T07:03:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\"},\"wordCount\":3072,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg\",\"datePublished\":\"2023-12-18T07:03:03+00:00\",\"dateModified\":\"2023-12-18T07:03:03+00:00\",\"description\":\"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-unique\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel\"}]},{\"@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\/fca08f68130533c2fcfd9928f5016a15\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel","description":"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!","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\/ham-unique\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel","og_description":"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-12-18T07:03:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\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\/ham-unique\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/fca08f68130533c2fcfd9928f5016a15"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel","datePublished":"2023-12-18T07:03:03+00:00","dateModified":"2023-12-18T07:03:03+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/"},"wordCount":3072,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg","datePublished":"2023-12-18T07:03:03+00:00","dateModified":"2023-12-18T07:03:03+00:00","description":"H\u00e0m UNIQUE d\u00f9ng \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/ham-unique.jpg","width":1200,"height":628,"caption":"ham-unique"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-unique\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t trong Excel"}]},{"@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\/fca08f68130533c2fcfd9928f5016a15","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/297038","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\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=297038"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/297038\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/297117"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=297038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=297038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=297038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}