{"id":7117,"date":"2024-12-21T16:53:55","date_gmt":"2024-12-21T16:53:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-tu-2-danh-sach-gia-tri-giong-nhau\/"},"modified":"2024-12-21T16:53:55","modified_gmt":"2024-12-21T16:53:55","slug":"loc-tu-2-danh-sach-gia-tri-giong-nhau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/loc-tu-2-danh-sach-gia-tri-giong-nhau\/","title":{"rendered":"L\u1ecdc t\u1eeb 2 danh s\u00e1ch gi\u00e1 tr\u1ecb gi\u1ed1ng nhau"},"content":{"rendered":"
\n

L\u1ecdc t\u1eeb 2 danh s\u00e1ch nh\u1eefng gi\u00e1 tr\u1ecb gi\u1ed1ng nhau l\u00e0 vi\u1ec7c ch\u00fang ta hay ph\u1ea3i l\u00e0m khi so s\u00e1nh d\u1eef li\u1ec7u, trong b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t c\u00f4ng c\u1ee5 m\u1edbi c\u1ee7a Excel c\u00f3 th\u1ec3 gi\u00fap ch\u00fang ta l\u00e0m \u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch r\u1ea5t nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3, \u0111\u00f3 l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER<\/a><\/strong> k\u1ebft h\u1ee3p v\u1edbi h\u00e0m COUNTIF<\/a>.<\/em><\/p>\n

\"L\u1ecdc<\/a>
L\u1ecdc gi\u00e1 tr\u1ecb c\u00f3 trong c\u1ea3 2 danh s\u00e1ch<\/figcaption><\/figure>\n

L\u1ecdc t\u1eeb 2 danh s\u00e1ch gi\u00e1 tr\u1ecb gi\u1ed1ng nhau<\/span><\/h2>\n

\u0110\u1ec3 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 trong c\u1ea3 2 danh s\u00e1ch, ch\u00fang ta c\u00f3 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER\u00a0 nh\u01b0 sau:<\/p>\n

=FILTER( danh_sach_1 ,COUNTIF( danh_sach_2 , danh_sach_1 ))<\/code><\/p>\n

Trong v\u00ed d\u1ee5 \u1edf \u1ea3nh tr\u00ean, c\u00f4ng th\u1ee9c \u0111\u1ec3 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 m\u1eb7t trong c\u1ea3 2 danh s\u00e1ch l\u00e0<\/p>\n

=FILTER(B5:B14,COUNTIF(D5:D14,B5:B14))<\/code><\/p>\n

N\u1ebfu ch\u00fang ta d\u00f9ng chu\u1ed9t qu\u00e9t ch\u1ecdn v\u00f9ng COUNTIF<\/a>(D5:D14,B5:B14)<\/code> r\u1ed3i b\u1ea5m ph\u00edm F9 tr\u00ean b\u00e0n ph\u00edm th\u00ec k\u1ebft qu\u1ea3 s\u1ebd nh\u01b0 sau<\/p>\n

{0;1;1;0;1;1;0;0;0;0}<\/code><\/p>\n

Trong m\u1ea3ng tr\u00ean, \u1edf nh\u1eefng n\u01a1i c\u00f3 s\u1ed1 1 s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi nh\u1eefng th\u00e0nh ph\u1ea7n trong danh s\u00e1ch 2 m\u00e0 c\u00f3 m\u1eb7t trong danh s\u00e1ch 1. Nh\u01b0 v\u1eady h\u00e0m FILTER c\u1ee7a ch\u00fang ta b\u00e2y gi\u1edd s\u1ebd c\u00f3 tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n\u00a0include\u00a0<\/em>nh\u01b0 sau<\/p>\n

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

=FILTER(B5:B14,{0;1;1;0;1;1;0;0;0;0})<\/code><\/p>\n

\u1ede \u0111\u00e2y, nh\u1eefng d\u00f2ng n\u00e0o trong B5:B14 t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 1 s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i, t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 0 s\u1ebd b\u1ecb lo\u1ea1i ra.<\/p>\n

Trong m\u1ed9t b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m FILTER<\/a>, ch\u00fang ta \u0111\u00e3 bi\u1ebft r\u1eb1ng, tham s\u1ed1 \u0111i\u1ec1u ki\u1ec7n\u00a0include\u00a0<\/em>c\u1ee7a h\u00e0m FILTER s\u1ebd nh\u1eadn v\u1ec1 gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE, \u1edf trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb ch\u1ec9 l\u00e0 0 v\u00e0 1. \u1ede \u0111\u00e2y, Excel \u0111\u00e3 ng\u1ea7m hi\u1ec3u gi\u00e1 tr\u1ecb 1 \u2013 t\u01b0\u01a1ng \u1ee9ng v\u1edbi TRUE v\u00e0 gi\u00e1 tr\u1ecb 0 \u2013 t\u01b0\u01a1ng \u1ee9ng v\u1edbi FALSE. N\u1ebfu b\u1ea1n mu\u1ed1n vi\u1ebft r\u00f5 r\u00e0ng c\u00f4ng th\u1ee9c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd nh\u01b0 sau:<\/p>\n

=FILTER(B5:B14,COUNTIF(D5:D14,B5:B14)>0)<\/code><\/p>\n

\u0110\u1ecdc t\u1edbi \u0111\u00e2y, c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd t\u1ef1 h\u1ecfi, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u1ecdc ra nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 \u1edf trong danh s\u00e1ch 1 nh\u01b0ng kh\u00f4ng c\u00f3 \u1edf trong danh s\u00e1ch 2, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n

=FILTER(B5:B14,COUNTIF(D5:D14,B5:B14)=0)<\/code><\/p>\n

\u0110\u1ec3 \u00f4n l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 h\u00e0m FILTER trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o video sau \u0111\u00e2y:<\/p>\n