{"id":7153,"date":"2024-12-21T17:00:44","date_gmt":"2024-12-21T17:00:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-filter-loc-du-lieu-trong-khoang-ngay\/"},"modified":"2024-12-21T17:00:44","modified_gmt":"2024-12-21T17:00:44","slug":"ham-filter-loc-du-lieu-trong-khoang-ngay","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ham-filter-loc-du-lieu-trong-khoang-ngay\/","title":{"rendered":"H\u00e0m FILTER l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng ng\u00e0y"},"content":{"rendered":"
\n

L\u1ecdc d\u1eef li\u1ec7u trong th\u1eddi gian t\u1eeb ng\u00e0y \u0111\u1ebfn ng\u00e0y hay l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng ng\u00e0y<\/strong> l\u00e0 m\u1ed9t nhu c\u1ea7u kh\u00f4ng th\u1ec3 thi\u1ebfu khi b\u1ea1n l\u00e0m b\u00e1o c\u00e1o, nh\u1ea5t l\u00e0 nh\u1eefng b\u00e1o c\u00e1o theo kho\u1ea3ng th\u1eddi gian. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n th\u00eam m\u1ed9t c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER<\/strong><\/a> ; c\u1ee5 th\u1ec3 l\u00e0 l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng ng\u00e0y.<\/em><\/p>\n

\"H\u00e0m<\/a>
H\u00e0m filter l\u1ecdc d\u1eef li\u1ec7u trong kho\u1ea3ng ng\u00e0y<\/figcaption><\/figure>\n

C\u00f4ng th\u1ee9c chung cho vi\u1ec7c l\u1ecdc d\u1eef li\u1ec7u theo ng\u00e0y th\u00e1ng c\u1ee7a ch\u00fang ta nh\u01b0 sau:<\/p>\n

=FILTER(d\u1eef_li\u1ec7u, (c\u1ed9t_ng\u00e0y >= F2) * (c\u1ed9t_ng\u00e0y <= G2), \"No data\")<\/code><\/p>\n

Trong v\u00ed d\u1ee5 \u1edf \u1ea3nh tr\u00ean, c\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3 c\u1ee7a ch\u00fang ta l\u00e0:<\/p>\n

=FILTER(B5:D13,(D5:D13>=F2)*(D5:D13<=G2),\"No data\")<\/code><\/p>\n

M\u1ed9t l\u01b0u \u00fd cho c\u00e1c b\u1ea1n\u00a0 khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u00f3 l\u00e0 ph\u1ea3i \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u00fang l\u00e0 d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng<\/a>, ch\u1ee9 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u201cc\u00f3 v\u1ebb\u201d nh\u01b0 ng\u00e0y th\u00e1ng nh\u01b0ng l\u1ea1i l\u00e0 d\u1ea1ng text<\/p>\n

C\u00f4ng th\u1ee9c tr\u00ean ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/p>\n

Ph\u1ea7n ph\u1ee9c t\u1ea1p trong c\u00f4ng th\u1ee9c tr\u00ean l\u00e0 ph\u1ea7n \u0111i\u1ec1u ki\u1ec7n (D5:D13>=F2)*(D5:D13<=G2)<\/code>. \u1ede \u0111\u00e2y, d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c l\u01b0u trong v\u00f9ng D5:D13, c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd th\u1ef1c hi\u1ec7n so s\u00e1nh D5:D13 l\u1ea7n l\u01b0\u1ee3t v\u1edbi F2 v\u00e0 G2 l\u00e0 \u00f4 ch\u1ee9a d\u1eef ki\u1ec7n t\u1eeb ng\u00e0y v\u00e0 \u0111\u1ebfn ng\u00e0y. N\u1ebfu b\u1ea1n ch\u1ecdn v\u00f9ng \u0111i\u1ec1u ki\u1ec7n tr\u00ean thanh c\u00f4ng th\u1ee9c v\u00e0 b\u1ea5m ph\u00edm F9, th\u00ec k\u1ebft qu\u1ea3 s\u1ebd l\u00e0:<\/p>\n

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

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

K\u1ebft qu\u1ea3 c\u1ee7a 2 m\u1ea3ng \u0111i\u1ec1u ki\u1ec7n n\u00e0y khi nh\u00e2n v\u1edbi nhau s\u1ebd l\u00e0<\/p>\n

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

nh\u01b0 v\u1eady ch\u1ec9 nh\u1eefng d\u00f2ng t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 1 trong m\u1ea3ng tr\u00ean m\u1edbi \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i \u0111\u1ec3 ch\u00fang ta c\u00f3 k\u1ebft qu\u1ea3 l\u1ecdc gi\u1eefa kho\u1ea3ng ng\u00e0y \u0111\u00e3 \u0111\u1ecbnh ngh\u0129a \u1edf F2 v\u00e0 G2<\/p>\n

\u0110\u1ec3 \u00f4n l\u1ea1i ki\u1ebfn th\u1ee9c v\u1ec1 h\u00e0m Filter<\/strong>, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i video sau \u0111\u00e2y c\u1ee7a H\u1ecdc Excel Online<\/strong><\/a>:<\/p>\n