{"id":7140,"date":"2024-12-21T16:58:40","date_gmt":"2024-12-21T16:58:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/bo-dong-trong-bang-ham-filter\/"},"modified":"2024-12-21T16:58:40","modified_gmt":"2024-12-21T16:58:40","slug":"bo-dong-trong-bang-ham-filter","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/bo-dong-trong-bang-ham-filter\/","title":{"rendered":"B\u1ecf d\u00f2ng tr\u1ed1ng b\u1eb1ng h\u00e0m FILTER"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER<\/a><\/strong> \u0111\u1ec3 lo\u1ea1i hay l\u1ecdc b\u1ecf\u00a0 d\u00f2ng tr\u1ed1ng<\/strong> trong b\u1ea3ng d\u1eef li\u1ec7u, v\u1edbi s\u1ef1 h\u01b0\u1edbng d\u1eabn c\u1ee7a H\u1ecdc Excel Online.<\/strong><\/a> C\u00f9ng b\u1eaft \u0111\u00e0u b\u00e0i h\u1ecdc ngay th\u00f4i.\u00a0<\/em><\/p>\n

\"H\u00e0m<\/a>
H\u00e0m Filter l\u1ecdc b\u1ecf d\u00f2ng c\u00f3 d\u1eef li\u1ec7u tr\u1ed1ng<\/figcaption><\/figure>\n

Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u1ea7n ph\u1ea3i lo\u1ea1i b\u1ecf nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u c\u00f3 \u00edt nh\u1ea5t 1 \u00f4 tr\u1ed1ng ho\u1eb7c ch\u00fang ta ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u1ea3 3 c\u1ed9t B, C, D \u0111\u01b0\u1ee3c \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin. Vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n r\u1ea5t nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER. C\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng v\u1edbi tr\u01b0\u1eddng h\u1ee3p tr\u00ean l\u00e0:<\/p>\n

=FILTER(B5:D13,(B5:B13<>\"\")*(C5:C13<>\"\")*(D5:D13<>\"\"),\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/p>\n

Nh\u01b0 v\u1eady, \u0111\u1ec3 hi\u1ec3u c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n c\u1ea7n hi\u1ec3u h\u00e0m FILTER ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o, v\u00e0 c\u1ee5 th\u1ec3 l\u00e0 ph\u1ea7n v\u00f9ng \u0111i\u1ec1u ki\u1ec7n (B5:B13<>\"\")*(C5:C13<>\"\")*(D5:D13<>\"\")<\/code> ngh\u0129a l\u00e0 g\u00ec. M\u1ed7i c\u1ee5m (B5:B13<>\"\")<\/code> s\u1ebd so s\u00e1nh l\u1ea7n l\u01b0\u1ee3t c\u00e1c \u00f4 trong v\u00f9ng B5:B13 v\u1edbi \u201c\u201d, vi\u1ec7c so s\u00e1nh n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 1 m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb TRUE \/ FALSE. Khi nh\u00e2n 3 m\u1ea3ng gi\u00e1 tr\u1ecb TRUE \/ FALSE n\u00e0y v\u1edbi nhau th\u00ec Excel s\u1ebd hi\u1ec3u \u0111i\u1ec1u ki\u1ec7n l\u00e0 ch\u1ecdn ra nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t B kh\u00f4ng r\u1ed7ng V\u00c0\u00a0<\/strong>c\u1ed9t C kh\u00f4ng r\u1ed7ng\u00a0V\u00c0\u00a0<\/strong>c\u1ed9t D kh\u00f4ng r\u1ed7ng.<\/p>\n

V\u1edbi logic \u0111\u00e3 h\u1ecdc \u0111\u01b0\u1ee3c t\u1eeb b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng m\u1edf r\u1ed9ng ra nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p so s\u00e1nh kh\u00e1c v\u00e0 k\u1ebft h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n v\u1edbi h\u00e0m FILTER. Logic s\u1eed d\u1ee5ng trong b\u00e0i vi\u1ebft n\u00e0y c\u00f2n c\u00f3 t\u00ean l\u00e0 Boolean Logic \u2013 d\u00e0nh cho nh\u1eefng b\u1ea1n ch\u0103m ch\u1ec9 mu\u1ed1n Google l\u1ea1i v\u00e0 h\u1ecdc th\u00eam. C\u00e1c b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 quan t\u00e2m t\u1edbi logic n\u00e0y trong b\u00e0i vi\u1ebft v\u1ec1 h\u00e0m SUMPRODUCT sau \u0111\u00e2y:<\/p>\n

B\u00ed k\u00edp v\u00f5 l\u00e2m 2: SUMPRODUCT th\u1ea7n ch\u01b0\u1edfng<\/a><\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng ki\u1ebfn th\u1ee9c trong b\u00e0i vi\u1ebft n\u00e0y<\/p>\n

\u0110T Nguy\u1ec5n.<\/p>\n

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

P.S: C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd mu\u1ed1n xem l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 h\u00e0m FILTER<\/a> \u1edf video n\u00e0y<\/p>\n