{"id":4905,"date":"2025-11-19T18:20:55","date_gmt":"2025-11-19T11:20:55","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-unique-trong-excel-de-loc-du-lieu-cuc-don-gian\/"},"modified":"2025-11-19T18:20:55","modified_gmt":"2025-11-19T11:20:55","slug":"cach-su-dung-ham-unique-trong-excel-de-loc-du-lieu-cuc-don-gian","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-unique-trong-excel-de-loc-du-lieu-cuc-don-gian\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE trong Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ef1c \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m UNIQUE trong Excel \u0111\u1ec3 l\u1ecdc ra d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u1eb7p ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c. Nh\u1edd kh\u1ea3 n\u0103ng t\u1ea1o m\u1ea3ng \u0111\u1ed9ng, h\u00e0m h\u1ed7 tr\u1ee3 x\u1eed l\u00fd b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3 h\u01a1n trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng. \u0110\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch d\u00f9ng v\u00e0 \u00e1p d\u1ee5ng \u0111\u00fang cho t\u1eebng t\u00ecnh hu\u1ed1ng, b\u1ea1n h\u00e3y xem h\u01b0\u1edbng d\u1eabn chi ti\u1ebft ngay b\u00ean d\u01b0\u1edbi.<\/p>\n

\"H\u00e0mH\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m UNIQUE trong Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u, lo\u1ea1i b\u1ecf gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p<\/em><\/p>\n

\n

1. H\u00e0m UNIQUE trong Excel l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m UNIQUE l\u00e0 c\u00f4ng c\u1ee5 d\u00f9ng \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n trong danh s\u00e1ch ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u, gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u1ea1o ra t\u1eadp d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u1eb7p m\u1ed9t c\u00e1ch ti\u1ec7n l\u1ee3i v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

\n

2. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m UNIQUE<\/h2>\n<\/div>\n

H\u00e0m UNIQUE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00fa ph\u00e1p: =UNIQUE(array, [by_col], [occurs_once])<\/strong><\/p>\n

Gi\u1ea3i th\u00edch:<\/p>\n

    \n
  • array (B\u1eaft bu\u1ed9c)<\/strong>: V\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch l\u1ecdc danh s\u00e1ch gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng l\u1eb7p. C\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u1ed9t, m\u1ed9t h\u00e0ng ho\u1eb7c m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n
  • by_col (Tu\u1ef3 ch\u1ecdn)<\/strong>: Tham s\u1ed1 logic x\u00e1c \u0111\u1ecbnh h\u01b0\u1edbng so s\u00e1nh. N\u1ebfu \u0111\u1ec3 FALSE th\u00ec Excel ki\u1ec3m tra theo h\u00e0ng; n\u1ebfu \u0111\u1eb7t TRUE th\u00ec so s\u00e1nh theo c\u1ed9t.<\/li>\n
  • occurs_once (Tu\u1ef3 ch\u1ecdn)<\/strong>: Gi\u00e1 tr\u1ecb logic gi\u00fap x\u00e1c \u0111\u1ecbnh ki\u1ec3u l\u1ecdc. Khi \u0111\u1ec3 FALSE, h\u00e0m tr\u1ea3 v\u1ec1 m\u1ed7i nh\u00f3m gi\u00e1 tr\u1ecb m\u1ed9t l\u1ea7n. Khi \u0111\u1eb7t TRUE, h\u00e0m ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n \u0111\u00fang m\u1ed9t l\u1ea7n trong to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n

    \"C\u00f4ngC\u00fa ph\u00e1p h\u00e0m UNIQUE trong Excel<\/em><\/p>\n

    Xem th\u00eam: <\/strong>H\u00e0m CODE trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y m\u00e3 CODE<\/div>\n
    \n

    3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UNIQUE trong Excel \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/h2>\n<\/div>\n
    \n

    3.1 D\u00f9ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb duy nh\u1ea5t trong b\u1ea3ng<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> L\u1ecdc danh s\u00e1ch \u0111\u1ec3 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n xu\u1ea5t k\u1ebft qu\u1ea3 (v\u00ed d\u1ee5 \u00f4 B2), nh\u1eadp c\u00f4ng th\u1ee9c:=UNIQUE(A2:A8)<\/strong><\/p>\n

    \"C\u00f4ngNh\u1eadp h\u00e0m UNIQUE v\u00e0o \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Sau khi nh\u1eadp h\u00e0m xong, b\u1ea1n nh\u1ea5n Enter<\/strong>. L\u00fac n\u00e0y Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t t\u1eeb v\u00f9ng A2:A8.<\/p>\n

    \"K\u1ebftK\u1ebft qu\u1ea3 l\u1ecdc gi\u00e1 tr\u1ecb duy nh\u1ea5t<\/em><\/p>\n

    \n

    3.2 K\u1ebft h\u1ee3p v\u1edbi h\u00e0m SORT<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> T\u1ea1o danh s\u00e1ch gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng l\u1eb7p v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb danh s\u00e1ch k\u1ebft qu\u1ea3 (v\u00ed d\u1ee5 B2), nh\u1eadp c\u00f4ng th\u1ee9c: =SORT(UNIQUE(A2:A10))<\/strong><\/p>\n

    \"S\u1eedD\u00f9ng SORT k\u1ebft h\u1ee3p UNIQUE<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong>. Excel s\u1ebd tr\u1ea3 l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 trong v\u00f9ng A2:A10, \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf tr\u00f9ng l\u1eb7p v\u00e0 s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn nh\u1edd s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa UNIQUE v\u00e0 SORT.<\/p>\n

    \"L\u1ecdcDanh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp<\/em><\/p>\n

    \n

    3.3 L\u1ecdc tr\u00f9ng theo c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> L\u1ecdc danh s\u00e1ch m\u1eb7t h\u00e0ng m\u1ed7i nh\u00e2n vi\u00ean \u0111\u00e3 b\u00e1n (kh\u00f4ng tr\u00f9ng l\u1eb7p)<\/p>\n

    B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 (v\u00ed d\u1ee5 B9), nh\u1eadp c\u00f4ng th\u1ee9c: =UNIQUE(B3:D3; TRUE; FALSE)<\/strong><\/p>\n

    Gi\u1ea3i th\u00edch:<\/p>\n

      \n
    • B3:D3:<\/strong> V\u00f9ng ch\u1ee9a danh s\u00e1ch m\u1eb7t h\u00e0ng c\u1ee7a nh\u00e2n vi\u00ean.<\/li>\n
    • TRUE:<\/strong> L\u1ecdc theo chi\u1ec1u c\u1ed9t trong m\u1ed9t h\u00e0ng ngang.<\/li>\n
    • FALSE:<\/strong> Gi\u1eef l\u1ea1i m\u1ed9t \u0111\u1ea1i di\u1ec7n cho m\u1ed7i gi\u00e1 tr\u1ecb tr\u00f9ng l\u1eb7p.<\/li>\n<\/ul>\n

      \"S\u1eedNh\u1eadp h\u00e0m UNIQUE \u0111\u1ec3 l\u1ecdc m\u1eb7t h\u00e0ng<\/em><\/p>\n

      B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 Excel tr\u1ea3 v\u1ec1 danh s\u00e1ch m\u1eb7t h\u00e0ng t\u01b0\u01a1ng \u1ee9ng.<\/p>\n

      B\u01b0\u1edbc 3:<\/strong> T\u1eeb \u00f4 v\u1eeba t\u00ednh, k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi \u0111\u1ec3 \u00e1p d\u1ee5ng cho nh\u1eefng nh\u00e2n vi\u00ean c\u00f2n l\u1ea1i.<\/p>\n

      \n

      3.4 L\u1ea5y gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n duy nh\u1ea5t m\u1ed9t l\u1ea7n trong danh s\u00e1ch<\/h3>\n<\/div>\n

      V\u00ed d\u1ee5:<\/strong> L\u1ecdc ra m\u00e0u v\u1ea3i xu\u1ea5t hi\u1ec7n duy nh\u1ea5t trong b\u1ea3ng<\/p>\n

      B\u01b0\u1edbc 1:<\/strong> T\u1ea1i \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 (v\u00ed d\u1ee5 C2), nh\u1eadp c\u00f4ng th\u1ee9c: =UNIQUE(B2:B7;;TRUE)<\/strong><\/p>\n

      Gi\u1ea3i th\u00edch:<\/p>\n

        \n
      • B2:B7:<\/strong> V\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a c\u00e1c m\u00e0u v\u1ea3i c\u1ea7n ph\u00e2n t\u00edch.<\/li>\n
      • TRUE:<\/strong> Ch\u1ec9 tr\u1ea3 v\u1ec1 nh\u1eefng m\u00e0u xu\u1ea5t hi\u1ec7n \u0111\u00fang m\u1ed9t l\u1ea7n trong danh s\u00e1ch.<\/li>\n<\/ul>\n

        \"D\u00f9ngNh\u1eadp h\u00e0m UNIQUE cho c\u1ed9t lo\u1ea1i v\u1ea3i<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter<\/strong> \u0111\u1ec3 Excel th\u1ef1c hi\u1ec7n l\u1ecdc v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 ngay trong \u00f4 \u0111\u00e3 ch\u1ecdn.<\/p>\n

        \"UNIQUEK\u1ebft qu\u1ea3 l\u1ecdc m\u00e0u v\u1ea3i duy nh\u1ea5t<\/em><\/p>\n

        \n

        4. L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m UNIQUE trong excel<\/h2>\n<\/div>\n

        D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i \u0111i\u1ec1u b\u1ea1n c\u1ea7n ch\u00fa \u00fd khi d\u00f9ng h\u00e0m UNIQUE \u0111\u1ec3 tr\u00e1nh m\u1eafc l\u1ed7i v\u00e0 thao t\u00e1c thu\u1eadn l\u1ee3i h\u01a1n:<\/p>\n

          \n
        • H\u00e0m UNIQUE ch\u1ec9 c\u00f3 trong Excel 365, c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 h\u01a1n (2016, 2013, 2010\u2026) kh\u00f4ng h\u1ed7 tr\u1ee3 h\u00e0m n\u00e0y, v\u00ec v\u1eady b\u1ea1n s\u1ebd kh\u00f4ng t\u00ecm th\u1ea5y n\u00f3 trong c\u00e1c b\u1ea3n Excel truy\u1ec1n th\u1ed1ng.<\/li>\n
        • K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m UNIQUE l\u00e0 m\u1ed9t m\u1ea3ng \u0111\u1ed9ng. Excel s\u1ebd t\u1ef1 m\u1edf r\u1ed9ng v\u00f9ng hi\u1ec3n th\u1ecb v\u00e0 \u0111i\u1ec1n k\u1ebft qu\u1ea3 v\u00e0o s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u1ea7n thi\u1ebft m\u00e0 kh\u00f4ng ph\u1ea3i sao ch\u00e9p th\u1ee7 c\u00f4ng.<\/li>\n
        • UNIQUE c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng gi\u1eefa nhi\u1ec1u file Excel, nh\u01b0ng ch\u1ec9 khi t\u1ea5t c\u1ea3 c\u00e1c file \u0111\u1ec1u \u0111ang m\u1edf. N\u1ebfu file ch\u1ee9a d\u1eef li\u1ec7u ngu\u1ed3n b\u1ecb \u0111\u00f3ng, k\u1ebft qu\u1ea3 li\u00ean k\u1ebft s\u1ebd kh\u00f4ng c\u00f2n h\u1ee3p l\u1ec7 v\u00e0 Excel s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i #REF! khi c\u1eadp nh\u1eadt l\u1ea1i d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n

          H\u00e0m UNIQUE l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n x\u1eed l\u00fd danh s\u00e1ch nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n khi l\u00e0m vi\u1ec7c trong Excel. Ch\u1ec9 c\u1ea7n n\u1eafm v\u1eefng c\u00e1ch s\u1eed d\u1ee5ng v\u00e0 c\u00e1c l\u01b0u \u00fd quan tr\u1ecdng, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng linh ho\u1ea1t cho nhi\u1ec1u d\u1ea1ng b\u1ea3ng d\u1eef li\u1ec7u kh\u00e1c nhau. H\u00e3y th\u1eed th\u1ef1c h\u00e0nh ngay \u0111\u1ec3 t\u1ed1i \u01b0u thao t\u00e1c c\u1ee7a m\u00ecnh trong c\u00f4ng vi\u1ec7c.<\/p>\n

          \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o hay ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n

          N\u1ebfu b\u1ea1n \u0111ang c\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb l\u00e0m vi\u1ec7c, \u0111\u1eebng b\u1ecf qua c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7u n\u0103ng cao t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn. Tham kh\u1ea3o ngay \u0111\u1ec3 ch\u1ecdn \u0111\u01b0\u1ee3c s\u1ea3n ph\u1ea9m ph\u00f9 h\u1ee3p nhu c\u1ea7u h\u1ecdc t\u1eadp v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u Excel.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          \u00a0 Trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m UNIQUE trong Excel \u0111\u1ec3 l\u1ecdc ra d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng l\u1eb7p ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c. Nh\u1edd kh\u1ea3 n\u0103ng t\u1ea1o m\u1ea3ng \u0111\u1ed9ng, h\u00e0m h\u1ed7 tr\u1ee3 x\u1eed l\u00fd b\u1ea3ng t\u00ednh hi\u1ec7u qu\u1ea3 h\u01a1n trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng. \u0110\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch d\u00f9ng v\u00e0 […]<\/p>\n","protected":false},"author":1,"featured_media":4906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4905","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19372.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4905"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4905\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4906"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}