{"id":6944,"date":"2024-12-21T16:34:05","date_gmt":"2024-12-21T16:34:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loai-bo-o-trong-trong-ket-qua-khi-loc-du-lieu-duy-nhat\/"},"modified":"2024-12-21T16:34:05","modified_gmt":"2024-12-21T16:34:05","slug":"loai-bo-o-trong-trong-ket-qua-khi-loc-du-lieu-duy-nhat","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loai-bo-o-trong-trong-ket-qua-khi-loc-du-lieu-duy-nhat\/","title":{"rendered":"Lo\u1ea1i b\u1ecf \u00f4 tr\u1ed1ng trong k\u1ebft qu\u1ea3 khi l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t"},"content":{"rendered":"
\n

Xin ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Thanh, trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u c\u00e1ch lo\u1ea1i b\u1ecf \u00f4 tr\u1ed1ng khi l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter<\/a><\/strong> k\u1ebft h\u1ee3p v\u1edbi h\u00e0m Unique<\/a>.<\/strong><\/em><\/p>\n

\"Lo\u1ea1i<\/a>
Lo\u1ea1i b\u1ecf \u00f4 tr\u1ed1ng trong k\u1ebft qu\u1ea3 l\u1ecdc d\u1eef li\u1ec7u duy nh\u1ea5t<\/figcaption><\/figure>\n

Ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m Filter v\u00e0 h\u00e0m Unique trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u01b0 sau:<\/p>\n

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

\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c n\u00e0y, ch\u00fang ta h\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb trong ra ngo\u00e0i, ngh\u0129a l\u00e0 b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0m Filter.<\/p>\n

N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Filter, m\u1eddi b\u1ea1n \u0111\u1ecdc b\u00e0i:\u00a0H\u00e0m FILTER, c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u<\/a><\/p>\n

H\u00e0m Filter trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd l\u1ecdc d\u1eef li\u1ec7u trong v\u00f9ng B5:B16 v\u00e0 ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng \u00f4 kh\u00f4ng tr\u1ed1ng trong c\u1ed9t B, \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c vi\u1ebft cho h\u00e0m Filter trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 B5:B16 <> \u201c\u201d, k\u1ebft qu\u1ea3 c\u1ee7a s\u1ef1 so s\u00e1nh n\u00e0y l\u00e0<\/p>\n

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

Trong m\u1ea3ng d\u1eef li\u1ec7u ch\u1ec9 g\u1ed3m c\u00e1c gi\u00e1 tr\u1ecb TRUE v\u00e0 FALSE n\u00e0y, theo c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m FILTER th\u00ec nh\u1eefng \u00f4 t\u01b0\u01a1ng \u1ee9ng n\u00e0o trong v\u00f9ng B5:B16 kh\u00f4ng r\u1ed7ng s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i trong k\u1ebft qu\u1ea3 Filter nh\u01b0 sau:<\/p>\n

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

{\"\u0110\u1ecf\";\"V\u00e0ng\";\"Xanh\";\"Xanh\";\"T\u00edm\";\"\u0110\u1ecf\";\"X\u00e1m\";\"\u0110\u1ecf\";\"Xanh\"}<\/code><\/p>\n

Sau khi \u0111\u00e3 chu\u1ea9n b\u1ecb \u0111\u1ee7 d\u1eef li\u1ec7u, vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 c\u1ee7a h\u00e0m Unique \u0111\u1ec3 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t trong k\u1ebft qu\u1ea3 tr\u00ean:<\/p>\n

{\"\u0110\u1ecf\";\"V\u00e0ng\";\"Xanh\";\"T\u00edm\";\"X\u00e1m\"}<\/code><\/p>\n

Nh\u01b0 v\u1eady, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c r\u1eb1ng, v\u1edbi s\u1ef1 k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m Filter v\u00e0 h\u00e0m Unique<\/strong><\/a>, ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf \u0111\u01b0\u1ee3c nh\u1eefng \u00f4 tr\u1ed1ng ra kh\u1ecfi k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Unique.<\/p>\n

C\u00e1c b\u00e0i vi\u1ebft li\u00ean quan c\u1ee7a H\u1ecdc Excel Online<\/strong><\/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

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m FILTER nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n tr\u1ea3 k\u1ebft qu\u1ea3 h\u1ed7n h\u1ee3p<\/a><\/p>\n

C\u00e1c video li\u00ean quan:<\/p>\n