{"id":6883,"date":"2024-12-21T16:24:23","date_gmt":"2024-12-21T16:24:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-du-lieu-theo-dieu-kien-duy-nhat-ket-hop-ham-unique-filter\/"},"modified":"2024-12-21T16:24:23","modified_gmt":"2024-12-21T16:24:23","slug":"loc-du-lieu-theo-dieu-kien-duy-nhat-ket-hop-ham-unique-filter","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-du-lieu-theo-dieu-kien-duy-nhat-ket-hop-ham-unique-filter\/","title":{"rendered":"L\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t \u2013 k\u1ebft h\u1ee3p h\u00e0m Unique, Filter"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong> <\/a>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n k\u1ebft h\u1ee3p c\u00e1c h\u00e0m Unique<\/a>, h\u00e0m Filter<\/a> \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n.<\/strong><\/a><\/em><\/p>\n

\"L\u1ecdc<\/a>
L\u1ecdc duy nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n<\/figcaption><\/figure>\n

V\u1edbi y\u00eau c\u1ea7u l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t theo \u0111i\u1ec1u ki\u1ec7n, ch\u00fang ta c\u00f3 th\u1ec3 ngh\u0129 t\u1edbi m\u1ed9t c\u00e1ch l\u00e0m chung cho tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0: s\u1eed d\u1ee5ng h\u00e0m Filter trong Excel 365 <\/a>\u0111\u1ec3 l\u1ecdc tr\u01b0\u1edbc r\u1ed3i sau \u0111\u00f3 tu\u1ef3 v\u00e0o nhu c\u1ea7u x\u1eed l\u00fd d\u1eef li\u1ec7u ti\u1ebfp m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m Unique \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y ra d\u1eef li\u1ec7u duy nh\u1ea5t.<\/p>\n

C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p v\u00ed d\u1ee5 tr\u00ean h\u00ecnh l\u00e0<\/p>\n

=UNIQUE(FILTER(B5:B16,C5:C16=E4))<\/code><\/p>\n

Trong c\u00f4ng th\u1ee9c tr\u00ean, h\u00e0m FILTER s\u1ebd ch\u1ecbu tr\u00e1ch nhi\u1ec7m l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n \u1edf c\u1ed9t \u201cNh\u00f3m\u201d, vi\u1ec7c n\u00e0y \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n qua tham s\u1ed1 th\u1ee9 2 trong h\u00e0m FILTER \u1edf \u0111o\u1ea1n C5:C16=E4, k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c so s\u00e1nh n\u00e0y s\u1ebd l\u00e0 1 m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE:<\/p>\n

{TRUE;FALSE;TRUE;TRUE;FALSE;FALSE;FALSE;TRUE;FALSE;TRUE;FALSE;FALSE}<\/code><\/p>\n

Sau \u0111\u00f3, h\u00e0m Filter s\u1ebd l\u1ea5y ra nh\u1eefng d\u00f2ng trong v\u00f9ng B5:B16 t\u01b0\u01a1ng \u1ee9ng v\u1edbi gi\u00e1 tr\u1ecb TRUE trong m\u1ea3ng ph\u00eda tr\u00ean, v\u1eady l\u00e0 k\u1ebft qu\u1ea3 c\u00f2n l\u1ea1i c\u1ee7a ch\u00fang ta s\u1ebd l\u00e0<\/p>\n

{\"\u0110\u1ecf\";\"Xanh\";\"Xanh\";\"\u0110\u1ecf\";\"Xanh lam\"}<\/code><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

T\u1ea1i \u0111\u00e2y, sau khi h\u00e0m FILTER \u0111\u00e3 chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u, h\u00e0m Unique s\u1ebd l\u00e0m n\u1ed1t ph\u1ea7n vi\u1ec7c c\u1ee7a m\u00ecnh l\u00e0 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t, v\u00e0 cu\u1ed1i c\u00f9ng ch\u00fang ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0<\/p>\n

{\"\u0110\u1ecf\";\"Xanh\";\"Xanh lam\"}<\/code><\/p>\n

\u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u trong v\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/p>\n

L\u1ecdc duy nh\u1ea5t theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n trong c\u1ed9t<\/a><\/p>\n

Tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan t\u1edbi n\u1ed9i dung trong b\u00e0i vi\u1ebft n\u00e0y:<\/p>\n

H\u00e0m FILTER, c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/a><\/p>\n

B\u1ecf d\u00f2ng tr\u1ed1ng b\u1eb1ng h\u00e0m FILTER<\/a><\/p>\n

H\u00e0m FILTER l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng ng\u00e0y<\/a><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6883","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6883"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6883\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6884"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}