![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-1\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-1.jpg.webp)
<\/picture><\/p>\n- \n
- L\u1ecdc d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n: Khi b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb c\u00e1c d\u1eef li\u1ec7u th\u1ecfa m\u00e3n m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc n\u00e0y. Ch\u1eb3ng h\u1ea1n nh\u01b0 l\u1ecdc danh s\u00e1ch kh\u00e1ch h\u00e0ng c\u00f3 \u0111\u1ed9 tu\u1ed5i t\u1eeb 30 tr\u1edf l\u00ean v\u1edbi s\u1ed1 ti\u1ec1n mua h\u00e0ng tr\u00ean 10 tri\u1ec7u \u0111\u1ed3ng.<\/li>\n
- T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u: T\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u1ec3 t\u1ed5ng h\u1ee3p th\u00e0nh m\u1ed9t b\u1ea3ng t\u00ednh nh\u1ecf h\u01a1n. Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c b\u1ea3ng l\u01b0\u01a1ng ri\u00eang cho m\u1ed7i nh\u00e2n vi\u00ean t\u1eeb b\u1ea3ng l\u01b0\u01a1ng chung c\u1ee7a m\u1ed9t v\u0103n ph\u00f2ng\/c\u00f4ng ty.<\/li>\n
- L\u1ecdc d\u1eef li\u1ec7u c\u00f3 kh\u1ea3 n\u0103ng thay \u0111\u1ed5i d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c l\u1ef1a ch\u1ecdn t\u00f9y ch\u1ec9nh: B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng ho\u1eb7c bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n thay \u0111\u1ed5i. Ch\u1eb3ng h\u1ea1n nh\u01b0 t\u1ea1o b\u1ea3ng hi\u1ec3n th\u1ecb ch\u1ec9 s\u1ed1 k\u1ebft qu\u1ea3 c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m v\u00e0 cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn lo\u1ea1i s\u1ea3n ph\u1ea9m c\u1ee5 th\u1ec3 t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng \u0111\u1ec3 xem k\u1ebft qu\u1ea3 chi ti\u1ebft.<\/li>\n
- T\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc: T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh nh\u01b0 t\u00ednh t\u1ed5ng, trung b\u00ecnh, min\/max\u2026 Ch\u1eb3ng h\u1ea1n nh\u01b0 \u0111\u1ec3 t\u1ea1o b\u1ea3ng th\u1ed1ng k\u00ea doanh thu c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc v\u00e0 t\u00ednh t\u1ed5ng theo t\u1eebng s\u1ea3n ph\u1ea9m ri\u00eang.<\/li>\n<\/ul>\n
C\u00e1ch d\u00f9ng b\u1ed9 l\u1ecdc FILTER trong Excel<\/h2>\n
\u0110\u1ec3 l\u1ecdc d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel – FILTER, ho\u1eb7c s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc FILTER c\u00f3 s\u1eb5n tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a Excel.<\/p>\n
Tr\u01b0\u1edbc khi kh\u00e1m ph\u00e1 c\u00e1ch d\u00f9ng h\u00e0m FILTER, ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 b\u1ed9 l\u1ecdc FILTER. B\u1ed9 l\u1ecdc FILTER trong Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng l\u1ecdc d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng m\u1ed9t ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. Sau khi \u00e1p d\u1ee5ng b\u1ed9 l\u1ecdc, t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n s\u1ebd hi\u1ec3n th\u1ecb, c\u00f2n nh\u1eefng d\u1eef li\u1ec7u c\u00f2n l\u1ea1i s\u1ebd b\u1ecb \u1ea9n \u0111i.<\/p>\n
Trong Excel c\u00f3 2 ch\u1ee9c n\u0103ng l\u1ecdc c\u01a1 b\u1ea3n l\u00e0:<\/p>\n
- \n
- Auto Filter: B\u1ed9 l\u1ecdc m\u1eb7c \u0111\u1ecbnh.<\/li>\n
- Advanced Filter: B\u1ed9 l\u1ecdc n\u00e2ng cao.<\/li>\n<\/ul>\n
\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o b\u1ed9 l\u1ecdc FILTER nh\u01b0 sau:<\/p>\n
- \n
- B\u01b0\u1edbc 1: Nh\u1eadp d\u1eef li\u1ec7u ho\u1eb7c m\u1edf b\u1ea3ng t\u00ednh c\u00f3 s\u1eb5n m\u00e0 b\u1ea1n c\u1ea7n l\u1ecdc tr\u00ean Excel.<\/li>\n<\/ul>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-2\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-2.jpg\")
<\/picture><\/p>\n- \n
- B\u01b0\u1edbc 2: Ch\u1ecdn v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch b\u00f4i \u0111en to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng t\u00ednh, ho\u1eb7c ch\u1ecdn h\u00e0ng ti\u00eau \u0111\u1ec3 m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc.<\/li>\n
- B\u01b0\u1edbc 3: B\u1ea1n b\u1ea5m v\u00e0o tab Home, sau \u0111\u00f3 click ch\u1ecdn Sort & Filter r\u1ed3i b\u1ea5m v\u00e0o Filter. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u1eed c\u00e1ch kh\u00e1c \u0111\u00f3 l\u00e0 t\u1ea1i tab Data, b\u1ea1n ch\u1ecdn Filter.<\/li>\n<\/ul>\n
S\u1eed d\u1ee5ng Auto Filter<\/h3>\n
\u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u1edbi b\u1ed9 l\u1ecdc m\u1eb7c \u0111\u1ecbnh, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
B\u01b0\u1edbc 1: Click v\u00e0o d\u1ea5u m\u0169i t\u00ean n\u1eb1m ngay b\u00ean c\u1ea1nh m\u1ee5c b\u1ea1n mu\u1ed1n l\u1ecdc.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-3\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-3.jpg\")
<\/picture><\/p>\nB\u01b0\u1edbc 2: B\u00e2y gi\u1edd, b\u1ea1n l\u1ea7n l\u01b0\u1ee3t b\u1ea5m ch\u1ecdn c\u00e1c ti\u00eau ch\u00ed m\u00e0 m\u00ecnh mu\u1ed1n l\u1ecdc, ch\u1eb3ng h\u1ea1n nh\u01b0 tick ch\u1ecdn \u00f4 \u201cNam\u201d \u0111\u1ec3 l\u1ecdc nh\u1eefng ng\u01b0\u1eddi c\u00f3 gi\u1edbi t\u00ednh l\u00e0 nam.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-4\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-4.jpg\")
<\/picture><\/p>\nB\u01b0\u1edbc 3: Sau khi ch\u1ecdn ti\u00eau ch\u00ed xong, b\u1ea1n b\u1ea5m OK v\u00e0 h\u1ec7 th\u1ed1ng s\u1ebd b\u1eaft \u0111\u1ea7u l\u1ecdc. Nh\u1eefng d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, trong khi \u0111\u00f3, c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n s\u1ebd b\u1ecb \u1ea9n \u0111i.<\/p>\n
S\u1eed d\u1ee5ng Advanced Filter<\/h3>\n
V\u1edbi b\u1ed9 l\u1ecdc d\u1eef li\u1ec7u n\u00e2ng cao, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t b\u1ea3ng ti\u00eau ch\u00ed l\u1ecdc m\u1edbi. C\u1ea7n l\u01b0u \u00fd l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c ti\u00eau ch\u00ed d\u00f9ng \u0111\u1ec3 l\u1ecdc n\u00e0y ph\u1ea3i tr\u00f9ng v\u1edbi ti\u00eau \u0111\u1ec1 b\u1ea1n \u0111\u00e3 \u0111\u1eb7t trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-5\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-5.jpg\")
<\/picture><\/p>\nB\u01b0\u1edbc 2: B\u1ea1n b\u1ea5m v\u00e0o m\u1ee5c Data, sau \u0111\u00f3 ch\u1ecdn Sort & Filter r\u1ed3i click v\u00e0o Advanced.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-6\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-6.jpg\")
<\/picture><\/p>\nB\u01b0\u1edbc 3: T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u1ea7n quan t\u00e2m \u0111\u1ebfn m\u1ed9t s\u1ed1 th\u00f4ng s\u1ed1 l\u1ecdc nh\u01b0:<\/p>\n
- \n
- Action: T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u sau khi l\u1ecdc \u0111\u01b0\u1ee3c xu\u1ea5t l\u00e0 \u1edf \u0111\u00e2u. N\u1ebfu ch\u1ecdn [Filter the list, in-place], k\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c xu\u1ea5t v\u00e0 hi\u1ec3n th\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc, c\u00f2n [Copy to another location] \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 vi\u1ec7c hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u \u1edf m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c trong trang t\u00ednh.<\/li>\n
- List Range: Khu v\u1ef1c \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u.<\/li>\n
- Criteria range: B\u1ea3ng ch\u1ee9a c\u00e1c ti\u00eau ch\u00ed (\u0111i\u1ec1u ki\u1ec7n) \u0111\u1ec3 l\u1ecdc.<\/li>\n
- Copy to: N\u1ebfu nh\u01b0 b\u1ea1n \u0111\u00e3 ch\u1ecdn [Copy to another location] \u1edf m\u1ee5c Action nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean, b\u1ea1n c\u1ea7n ph\u1ea3i cung c\u1ea5p v\u1ecb tr\u00ed xu\u1ea5t v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u l\u1ecdc c\u1ee5 th\u1ec3 t\u1ea1i \u0111\u00e2y.<\/li>\n<\/ul>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-7\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-7.jpg\")
<\/picture><\/p>\nB\u01b0\u1edbc 4: B\u1ea5m OK v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb trong gi\u00e2y l\u00e1t theo \u0111\u00fang \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111\u00e3 \u0111\u1eb7t ra.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-8\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-8.jpg\")
<\/picture><\/p>\nC\u00e1ch d\u00f9ng FILTER – H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/h2>\n
B\u00ean c\u1ea1nh b\u1ed9 l\u1ecdc FILTER, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel c\u00f3 t\u00ean t\u01b0\u01a1ng t\u1ef1 l\u00e0 FILTER \u0111\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u d\u1ef1a tr\u00ean 1 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh ban \u0111\u1ea7u. Tuy nhi\u00ean, c\u1ea7n l\u01b0u \u00fd l\u00e0 h\u00e0m n\u00e0y hi\u1ec7n ch\u1ec9 m\u1edbi h\u1ed7 tr\u1ee3 cho Excel 365.<\/p>\n
C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m FILTER \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh l\u00e0:<\/p>\n
=FILTER(array,include,if_empty)<\/strong><\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-9\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-9-1.jpg\")
<\/picture><\/p>\nTrong \u0111\u00f3:<\/p>\n
- \n
- Array l\u00e0 y\u1ebfu t\u1ed1 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3, t\u1ea1i \u0111\u00e2y b\u1ea1n c\u1ea7n cung c\u1ea5p ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u ban \u0111\u1ea7u m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc<\/li>\n
- Include c\u0169ng l\u00e0 m\u1ed9t th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c, d\u00f9ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ecdc.<\/li>\n
- If_empty l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn, cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o th\u1ecfa m\u00e3n nh\u1eefng \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1eb7t ra b\u00ean tr\u00ean. N\u1ebfu b\u1ecf tr\u1ed1ng gi\u00e1 tr\u1ecb n\u00e0y, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u00e0 m\u1ed9t v\u00f9ng tr\u1ed1ng.<\/li>\n<\/ul>\n
L\u01b0u \u00fd c\u1ea7n bi\u1ebft khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/h2>\n
Khi s\u1eed d\u1ee5ng h\u00e0m FILTER, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u sau:<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-10\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-10.jpg\")
<\/picture>H\u00e0m FILTER ch\u1ec9 m\u1edbi h\u1ed7 tr\u1ee3 cho phi\u00ean b\u1ea3n Microsoft Excel 365<\/figcaption><\/figure>\n - \n
- H\u00e0m FILTER ch\u1ec9 m\u1edbi h\u1ed7 tr\u1ee3 cho phi\u00ean b\u1ea3n Microsoft Excel 365.<\/li>\n
- Trong [Array], h\u00e0m kh\u00f4ng y\u00eau c\u1ea7u b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 h\u00e0ng ti\u00eau \u0111\u1ec1.<\/li>\n
- Trong [Include], b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng tham s\u1ed1 n\u00e0y ch\u1ee9a s\u1ed1 h\u00e0ng\/s\u1ed1 c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u1edbi ph\u1ea1m vi\/m\u1ea3ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n l\u1ecdc.<\/li>\n
- Sau khi g\u00f5 c\u00fa ph\u00e1p v\u00e0 b\u1ea5m Enter, k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng m\u1ea3ng d\u1eef li\u1ec7u v\u00e0 kh\u00f4ng \u0111i k\u00e8m v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u1ee7a khu v\u1ef1c d\u1eef li\u1ec7u g\u1ed1c \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 l\u1ecdc.<\/li>\n<\/ul>\n
M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/h2>\n
Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd b\u1eaft g\u1eb7p m\u1ed9t s\u1ed1 l\u1ed7i khi s\u1eed d\u1ee5ng h\u00e0m FILTER. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i qu\u00e1 lo l\u1eafng, h\u00e3y tham kh\u1ea3o ngay m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p, nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c chia s\u1ebb t\u1ea1i ph\u1ea7n n\u00e0y c\u1ee7a b\u00e0i vi\u1ebft:<\/p>\n
L\u1ed7i #CALC!<\/h3>\n
N\u1ebfu nh\u01b0 b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u1ec3 l\u1ecdc, l\u1ed7i #CALC! s\u1ebd xu\u1ea5t hi\u1ec7n. L\u00fac n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp th\u00eam\u00a0 [If_empty] ho\u1eb7c chuy\u1ec3n sang l\u1ecdc d\u1eef li\u1ec7u v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n kh\u00e1c.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-11\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-11.jpg\")
<\/picture><\/p>\nL\u1ed7i #NA!, #VALUE!<\/h3>\n
#NA!, #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi [Include] ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n b\u1ea5t h\u1ee3p l\u00fd ho\u1eb7c gi\u00e1 tr\u1ecb l\u1ed7i. L\u00fac n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda l\u1ea1i [Include] l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-12\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-12.jpg\")
<\/picture><\/p>\nL\u1ed7i #SPILL!<\/h3>\n
B\u1ea1n s\u1ebd b\u1eaft g\u1eb7p l\u1ed7i #SPILL khi trong khu v\u1ef1c xu\u1ea5t v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 \u0111\u00e3 ch\u1ee9a nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c. V\u1eady n\u00ean, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng v\u00f9ng xu\u1ea5t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n ch\u1ecdn l\u00e0 v\u00f9ng tr\u1ed1ng v\u00e0 kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o n\u1eb1m l\u1eabn trong \u0111\u00f3.<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-13\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-13.jpg\")
<\/picture><\/p>\nB\u00e0i t\u1eadp v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch d\u00f9ng FILTER – h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel<\/h2>\n
\u0110\u1ec3 r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 sau.<\/p>\n
L\u01b0u \u00fd: V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u01b0\u1ee3c tri\u1ec3n khai tr\u00ean Microsoft Excel 365.<\/p>\n
B\u00e0i t\u1eadp: Gi\u1ea3ng vi\u00ean y\u00eau c\u1ea7u b\u1ea1n l\u1ecdc th\u00f4ng tin c\u00e1 nh\u00e2n v\u00e0 \u0111i\u1ec3m thi c\u1ee7a c\u00e1c b\u1ea1n c\u00f9ng l\u1edbp nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi. B\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m g\u00ec?<\/strong><\/p>\n
L\u1ecdc 1 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n
V\u1edbi b\u1ea3ng tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel – FILTER. Ch\u1eb3ng h\u1ea1n nh\u01b0 b\u1ea1n c\u1ea7n l\u1ecdc ra c\u00e1c sinh vi\u00ean l\u00e0 nam gi\u1edbi, b\u1ea1n c\u00f3 c\u00fa ph\u00e1p sau:<\/p>\n
=FILTER(A1:E16,B1:B16=”nam”)<\/strong><\/p>\n
Sau khi nh\u1eadp c\u00fa ph\u00e1p v\u00e0 b\u1ea5m Enter, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-15\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-15.jpg\")
<\/picture><\/p>\nL\u00fac n\u00e0y, b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y m\u1ed9t b\u1ea3ng g\u1ed3m 5 h\u1ecdc sinh nam xu\u1ea5t hi\u1ec7n \u1edf \u00f4 b\u1ea1n \u0111\u00e3 nh\u1eadp h\u00e0m FILTER.<\/p>\n
Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n t\u00ecm nh\u1eefng sinh vi\u00ean c\u00f3 \u0111i\u1ec3m thi t\u1eeb 9 tr\u1edf l\u00ean, c\u00fa ph\u00e1p t\u01b0\u01a1ng \u1ee9ng s\u1ebd l\u00e0:<\/p>\n
=FILTER(A1:E16,E1:E16>=9)<\/strong><\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-16\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-16.jpg\")
<\/picture><\/p>\nL\u1ecdc 2 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n
Ho\u1eb7c b\u1ea1n mu\u1ed1n l\u1ecdc ra c\u00e1c b\u1ea1n sinh vi\u00ean nam c\u00f3 \u0111i\u1ec3m thi tr\u00ean 9 \u0111i\u1ec3m, h\u00e3y k\u1ebft h\u1ee3p 2 \u0111i\u1ec1u ki\u1ec7n l\u1ecdc b\u1eb1ng d\u1ea5u sao (*) nh\u01b0 c\u00fa ph\u00e1p d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n
=FILTER(A1:E16,(B1:B16=”nam”)*(E1:E16>=9))<\/strong><\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-17\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-17.jpg\")
<\/picture><\/p>\nL\u1ecdc 2 \u0111i\u1ec1u ki\u1ec7n v\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1<\/h3>\n
\u0110\u1ec3 l\u1ecdc c\u00e1c sinh vi\u00ean n\u1eef \u0111\u1ea1t t\u1eeb 9 \u0111i\u1ec3m thi tr\u1edf l\u00ean v\u00e0 s\u1eafp x\u1ebfp danh s\u00e1ch \u0111\u00f3 theo th\u1ee9 t\u1ef1 n\u0103m sinh t\u0103ng d\u1ea7n, b\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel – FILTER v\u00e0 h\u00e0m s\u1eafp x\u1ebfp – SORT.<\/p>\n
C\u1ee5 th\u1ec3, h\u00e0m SORT trong Excel th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 s\u1eafp x\u1ebfp c\u00e1c d\u1eef li\u1ec7u trong m\u1ed9t ph\u1ea1m vi ho\u1eb7c m\u1ea3ng d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 t\u1eeb t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SORT l\u00e0:<\/p>\n
=SORT(array,sort_index,sort_order,by_col)<\/strong><\/p>\n
Trong \u0111\u00f3:<\/p>\n
- \n
- Array: L\u00e0 ph\u1ea1m vi\/m\u1ea3ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp theo gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n. \u0110\u00e2y l\u00e0 th\u00e0nh ph\u1ea7n b\u1eaft bu\u1ed9c trong h\u00e0m.<\/li>\n
- Sort_index: \u0110\u00e2y l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn, \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 ra c\u1ed9t\/h\u00e0ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp (c\u1ed9t 1, h\u00e0ng 1), n\u1ebfu b\u1ecf tr\u1ed1ng \u00f4 n\u00e0y, h\u00e0m s\u1ebd s\u1eafp x\u1ebfp d\u1ef1a tr\u00ean c\u1ea3 m\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n
- Sort_order: \u0110\u00e2y l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn, \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp l\u00e0 t\u0103ng d\u1ea7n hay gi\u1ea3m d\u1ea7n. N\u1ebfu b\u1ecf tr\u1ed1ng \u00f4 n\u00e0y, Excel s\u1ebd s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 m\u1eb7c \u0111\u1ecbnh l\u00e0 th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n
- By_col: \u0110\u00e2y l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn. Trong \u0111\u00f3, TRUE l\u00e0 s\u1eafp x\u1ebfp theo c\u1ed9t c\u00f2n FALSE l\u00e0 theo h\u00e0ng. N\u1ebfu b\u1ecf tr\u1ed1ng \u00f4 n\u00e0y, Excel s\u1eafp x\u1ebfp theo m\u1eb7c \u0111\u1ecbnh l\u00e0 theo c\u1ed9t.<\/li>\n<\/ul>\n
Quay l\u1ea1i v\u00ed d\u1ee5, ch\u00fang ta c\u00f3 c\u00fa ph\u00e1p:<\/p>\n
=SORT(FILTER(A1:E16,(B1:B16=”n\u1eef”)*(E1:E16>=9)),3,1)<\/strong><\/p>\n
Trong \u0111\u00f3, s\u1ed1 \u201c3\u201d d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1eafp x\u1ebfp theo n\u0103m sinh v\u00e0 s\u1ed1 1 \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1eafp x\u1ebfp theo gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n. Ta c\u00f3 k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-18\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-18.jpg\")
<\/picture><\/p>\nL\u1eddi k\u1ebft<\/h2>\n
B\u00ean tr\u00ean l\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. Hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd h\u1eefu \u00edch v\u00e0 \u0111\u1eebng qu\u00ean \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc hay c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p, b\u1ea1n nh\u00e9!<\/p>\n
Xem th\u00eam:<\/p>\n
- \n
- C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel<\/a><\/li>\n
- C\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Word, Excel nhanh nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3. L\u00fac \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f9ng Ho\u00e0ng H\u00e0 Mobile t\u00ecm hi\u1ec3u c\u00e1ch d\u00f9ng b\u1ed9 l\u1ecdc FILTER, h\u00e0m FILTER v\u00e0 […]<\/p>\n","protected":false},"author":97,"featured_media":270450,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-270448","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"\n
H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p<\/title>\n<meta name=\"description\" content=\"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p\" \/>\n<meta property=\"og:description\" content=\"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-10T13:58:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\"},\"headline\":\"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p\",\"datePublished\":\"2023-10-10T13:58:43+00:00\",\"dateModified\":\"2023-10-10T13:58:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\"},\"wordCount\":3158,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\",\"name\":\"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg\",\"datePublished\":\"2023-10-10T13:58:43+00:00\",\"dateModified\":\"2023-10-10T13:58:43+00:00\",\"description\":\"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-loc-du-lieu-co-dieu-kien-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189\",\"name\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p","description":"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p","og_description":"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-10T13:58:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189"},"headline":"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p","datePublished":"2023-10-10T13:58:43+00:00","dateModified":"2023-10-10T13:58:43+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/"},"wordCount":3158,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/","name":"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg","datePublished":"2023-10-10T13:58:43+00:00","dateModified":"2023-10-10T13:58:43+00:00","description":"\u0110\u00f4i khi, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ednh to\u00e1n ho\u1eb7c l\u1ecdc b\u1ea3ng t\u00ednh cho m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel.jpg","width":1200,"height":628,"caption":"ham-loc-du-lieu-co-dieu-kien-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-loc-du-lieu-co-dieu-kien-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"H\u00e0m l\u1ecdc d\u1eef li\u1ec7u c\u00f3 \u0111i\u1ec1u ki\u1ec7n trong Excel v\u00e0 c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/8bdc637e22d0dfe8143434576119c189","name":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/74bcebffab89aeb362901537cb11326b?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Th\u1ecb M\u1ef9 Li\u00ean"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-my-lien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/270448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=270448"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/270448\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/270450"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=270448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=270448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=270448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - C\u00e1ch chuy\u1ec3n ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Word, Excel nhanh nh\u1ea5t<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
- C\u00e1ch d\u00f9ng h\u00e0m Countifs trong Excel<\/a><\/li>\n
- B\u01b0\u1edbc 1: Nh\u1eadp d\u1eef li\u1ec7u ho\u1eb7c m\u1edf b\u1ea3ng t\u00ednh c\u00f3 s\u1eb5n m\u00e0 b\u1ea1n c\u1ea7n l\u1ecdc tr\u00ean Excel.<\/li>\n<\/ul>\n
![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-2\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-2.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-3\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-3.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-4\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-4.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-5\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-5.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-6\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-6.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-7\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-7.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-8\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-8.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-9\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-9-1.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-10\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-10.jpg.webp)
<\/picture>![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-11\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-11.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-12\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-12.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-13\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-13.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-15\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-15.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-16\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-16.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-17\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-17.jpg.webp)
<\/picture><\/p>\n![\"ham-loc-du-lieu-co-dieu-kien-trong-excel-18\"](\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/10\/ham-loc-du-lieu-co-dieu-kien-trong-excel-18.jpg.webp)
<\/picture><\/p>\n