{"id":2109,"date":"2024-12-02T06:57:25","date_gmt":"2024-12-02T06:57:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel\/"},"modified":"2024-12-02T06:57:25","modified_gmt":"2024-12-02T06:57:25","slug":"huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 2 c\u00e1ch \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong 1 danh s\u00e1ch tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>D\u1eef li\u1ec7u trong Excel r\u1ea5t \u0111a d\u1ea1ng v\u00e0 c\u1ea7n c\u00f3 nhi\u1ec1u c\u00e1ch x\u1eed l\u00fd kh\u00e1c nhau \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi t\u1eebng lo\u1ea1i d\u1eef li\u1ec7u. Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 m\u1ed9t ch\u1ee7 \u0111\u1ec1 kh\u00f3 nh\u01b0ng r\u1ea5t th\u00fa v\u1ecb l\u00e0: <strong>\u0110\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/strong> trong 1 danh s\u00e1ch. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u xem kh\u00f3 \u1edf \u0111\u00e2u v\u00e0 th\u00fa v\u1ecb \u1edf \u0111\u00e2u nh\u00e9.<\/em><\/p>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 1 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<figure id=\"attachment_19915\" aria-describedby=\"caption-attachment-19915\" style=\"width: 491px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19915 size-full\" title=\"1 - \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-01.png\" alt=\"1 - \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"491\" height=\"279\"><figcaption id=\"caption-attachment-19915\" class=\"wp-caption-text\">1 \u2013 \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>M\u1ed9t y\u00eau c\u1ea7u \u0111\u1eb7t ra l\u00e0 \u0111\u1ebfm xem trong c\u1ed9t Nh\u00e2n vi\u00ean c\u00f3 bao nhi\u00eau ng\u01b0\u1eddi,\u00a0c\u1ed9t Ng\u00e0y c\u00f3 bao nhi\u00eau ng\u00e0y, c\u1ed9t T\u00ean h\u00e0ng c\u00f3 bao nhi\u00eau m\u1eb7t h\u00e0ng <strong>nh\u01b0ng kh\u00f4ng t\u00ednh c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau<\/strong>. V\u1eady ch\u00fang ta s\u1ebd gi\u1ea3i quy\u1ebft ra sao v\u1edbi b\u00e0i to\u00e1n n\u00e0y?<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d5a54b98ca\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel.html#Cach_thu_1_Them_cot_phu_va_dung_ham_COUNTIF\" title=\"C\u00e1ch th\u1ee9 1: Th\u00eam c\u1ed9t ph\u1ee5 v\u00e0 d\u00f9ng h\u00e0m COUNTIF\">C\u00e1ch th\u1ee9 1: Th\u00eam c\u1ed9t ph\u1ee5 v\u00e0 d\u00f9ng h\u00e0m COUNTIF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-2-cach-dem-so-gia-tri-khong-trung-trong-1-danh-sach-tren-excel.html#Cach_thu_2_Cong_thuc_mang_SUMPRODUCT_ket_hop_FREQUENCY\" title=\"C\u00e1ch th\u1ee9 2: C\u00f4ng th\u1ee9c m\u1ea3ng SUMPRODUCT k\u1ebft h\u1ee3p FREQUENCY\">C\u00e1ch th\u1ee9 2: C\u00f4ng th\u1ee9c m\u1ea3ng SUMPRODUCT k\u1ebft h\u1ee3p FREQUENCY<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_1_Them_cot_phu_va_dung_ham_COUNTIF\"><\/span>C\u00e1ch th\u1ee9 1: Th\u00eam c\u1ed9t ph\u1ee5 v\u00e0 d\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\">h\u00e0m COUNTIF<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch l\u00e0m c\u01a1 b\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n v\u00e0 c\u0169ng d\u1ec5 hi\u1ec3u. Nh\u01b0\u1ee3c \u0111i\u1ec3m duy nh\u1ea5t c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 l\u00e0m qua nhi\u1ec1u b\u01b0\u1edbc v\u00e0 t\u0103ng s\u1ed1 c\u00f4ng th\u1ee9c ph\u1ea3i t\u00ednh l\u00ean nhi\u1ec1u.<\/p>\n<p>V\u00ed d\u1ee5 v\u1edbi c\u1ed9t Ng\u00e0y, ch\u00fang ta s\u1ebd t\u1ea1o 1 c\u1ed9t ph\u1ee5 l\u00e0 c\u1ed9t F v\u00e0 s\u1eed d\u1ee5ng\u00a0h\u00e0m COUNTIF t\u1ea1i \u0111\u00f3. H\u00e0m COUNTIF kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi ch\u00fang ta ph\u1ea3i kh\u00f4ng n\u00e0o.\u00a0N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1edb h\u00e0m COUNTIF d\u00f9ng th\u1ebf n\u00e0o th\u00ec xem t\u1ea1i \u0111\u00e2y nh\u00e9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-countif-trong-excel-huong-dan-cu-va-co-vi-du-minh-hoa.html\">H\u00e0m CountIf trong excel, h\u01b0\u1edbng d\u1eabn c\u1ee5 th\u1ec3 v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda<\/a><\/p>\n<p>\u0110\u1ec3 ph\u00e2n bi\u1ec7t gi\u00e1 tr\u1ecb\u00a0t\u1ea1i d\u00f2ng \u0111\u00f3 xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 m\u1ea5y th\u00ec ch\u00fang ta d\u00f9ng h\u00e0m COUNTIF nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-159.gif\" title=\"ex101_92019-nho-159\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_19917\" aria-describedby=\"caption-attachment-19917\" style=\"width: 830px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19917 size-full\" title=\"2- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-countif-cot-phu.png\" alt=\"2- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"830\" height=\"302\"><figcaption id=\"caption-attachment-19917\" class=\"wp-caption-text\">2- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<ul>\n<li>Th\u1ee9 1: \u0110\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n t\u1ea1i m\u1ed7i d\u00f2ng trong v\u00f9ng t\u00ednh t\u1eeb d\u00f2ng \u0111\u1ea7u ti\u00ean t\u1edbi d\u00f2ng \u0111ang \u0111\u1ebfm. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng b\u1edfi khi t\u00ednh theo c\u00e1ch n\u00e0y th\u00ec gi\u00e1 tr\u1ecb COUNTIF \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ebd l\u1ea7n l\u01b0\u1ee3t l\u00e0 1, 2 , 3\u2026 t\u0103ng d\u1ea7n theo s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u0111i\u1ec1u ki\u1ec7n (criteria) \u0111ang x\u00e9t. Kh\u00e1c v\u1edbi vi\u1ec7c ch\u1ecdn Range l\u00e0 c\u1ea3 v\u00f9ng d\u1eef li\u1ec7u t\u1eeb C2:C11, \u1edf \u0111\u00e2y ch\u1ec9 x\u00e9t t\u1eeb C2 t\u0103ng d\u1ea7n theo c\u00e1c d\u00f2ng. Gi\u00e1 tr\u1ecb \u0111i\u1ec3m \u0111\u1ea7u C2 trong v\u00f9ng Range \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/li>\n<li>Th\u1ee9 2: Sau khi d\u00f9ng h\u00e0m COUNTIF ch\u00fang ta s\u1ebd ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ea1i c\u1ed9t F t\u1eeb F2:F11. M\u1ed7i 1 gi\u00e1 tr\u1ecb s\u1ed1 1 th\u1ec3 hi\u1ec7n l\u00e0 ng\u00e0y t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t C xu\u1ea5t hi\u1ec7n l\u1ea7n th\u1ee9 1, t\u1ee9c l\u00e0 ch\u01b0a b\u1ecb tr\u00f9ng. C\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 1 l\u00e0 tr\u00f9ng. Khi \u0111\u00f3 k\u1ebft qu\u1ea3 \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng ch\u1ec9 c\u1ea7n d\u00f9ng h\u00e0m COUNTIF trong c\u1ed9t F v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 s\u1ed1 1<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c l\u00e0 9<\/p>\n<p>Nh\u01b0 v\u1eady khi s\u1eed d\u1ee5ng h\u00e0m COUNTIF trong c\u1ed9t ph\u1ee5 th\u00ec gi\u1ea3i quy\u1ebft y\u00eau c\u1ea7u tr\u00ean kh\u00e1 d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m<\/strong><\/p>\n<p>C\u00e1ch n\u00e0y tuy \u0111\u01a1n gi\u1ea3n nh\u01b0ng l\u1ea1i c\u00f3 nh\u01b0\u1ee3c \u0111i\u1ec3m l\u00e0 t\u00ednh th\u1ee7 c\u00f4ng. B\u1ea1n ph\u1ea3i ch\u1ecdn 1 c\u1ed9t ph\u1ee5. D\u00f9ng c\u00f4ng th\u1ee9c t\u1ea1i c\u1ed9t ph\u1ee5. D\u00f9ng c\u00f4ng th\u1ee9c t\u00ednh k\u1ebft qu\u1ea3. R\u1ea5t nhi\u1ec1u b\u01b0\u1edbc ph\u1ea3i kh\u00f4ng n\u00e0o? H\u01a1n n\u1eefa v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn th\u00ec vi\u1ec7c n\u00e0y khi\u1ebfn\u00a0t\u0103ng th\u00eam 1 l\u01b0\u1ee3ng c\u00f4ng th\u1ee9c r\u1ea5t l\u1edbn, v\u1edbi m\u1ed7i d\u00f2ng d\u1eef li\u1ec7u l\u00e0 1 c\u00f4ng th\u1ee9c.<\/p>\n<p>V\u1eady n\u00ean trong nh\u1eefng\u00a0b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 kh\u1ea3 n\u0103ng Excel c\u1ee7a b\u1ea1n t\u1ed1t th\u00ec t\u1ea1i sao ch\u00fang ta kh\u00f4ng t\u00ecm hi\u1ec3u c\u00e1ch th\u1ee9 2 nh\u1ec9?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_2_Cong_thuc_mang_SUMPRODUCT_ket_hop_FREQUENCY\"><\/span>C\u00e1ch th\u1ee9 2: C\u00f4ng th\u1ee9c m\u1ea3ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumproduct-trong-excel-va-vi-du-cong-thuc.html\">SUMPRODUCT<\/a> k\u1ebft h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-va-cu-phap-ham-frequency-trong-excel.html\">FREQUENCY<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u1eb3n b\u1ea1n th\u1ea5y FREQUENCY l\u00e0 m\u1ed9t h\u00e0m h\u01a1i l\u1ea1 ph\u1ea3i kh\u00f4ng. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng m\u1ea3ng, d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong 1 ph\u1ea1m vi n\u00e0o \u0111\u00f3. Trong y\u00eau c\u1ea7u c\u1ee7a b\u00e0i to\u00e1n n\u00e0y, n\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5 th\u00ec ch\u00fang ta ph\u1ea3i\u00a0s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c x\u1eed l\u00fd d\u1eef li\u1ec7u theo m\u1ea3ng \u0111\u1ec3 t\u00ednh.<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft v\u1ec1 h\u00e0m Frequency c\u00f3 th\u1ec3 xem t\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-va-cu-phap-ham-frequency-trong-excel.html\">Ch\u1ee9c n\u0103ng v\u00e0 c\u00fa ph\u00e1p h\u00e0m FREQUENCY trong Excel<\/a><\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m FREQUENCY nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=FREQUENCY(data_array,bins_array)<\/p>\n<p>Nguy\u00ean t\u1eafc c\u1ee7a h\u00e0m Frequency l\u00e0 \u0111\u1ebfm xem c\u00e1c gi\u00e1 tr\u1ecb trong tham s\u1ed1 <strong>bins_array<\/strong> \u0111\u01b0\u1ee3c l\u1eb7p l\u1ea1i bao nhi\u00eau l\u1ea7n trong <strong>data_array<\/strong>. V\u1ec1 b\u1ea3n ch\u1ea5t th\u00ec \u0111\u00e2y gi\u1ed1ng nh\u01b0 vi\u1ec7c d\u00f9ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm t\u1eebng ph\u1ea7n t\u1eed trong <strong>bins_array<\/strong>\u00a0(criteria) trong v\u00f9ng <strong>data_array<\/strong>\u00a0(range) v\u1eady.<\/p>\n<p>\u1ee8ng d\u1ee5ng nguy\u00ean t\u1eafc tr\u00ean, ch\u00fang ta x\u00e9t 2 n\u1ed9i dung sau:<\/p>\n<ul>\n<li>S\u1ed1\u00a0th\u1ee9 t\u1ef1 d\u00f2ng c\u1ee7a m\u1ed7i d\u00f2ng d\u1eef li\u1ec7u trong c\u1ed9t c\u1ea7n \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng s\u1ebd l\u1ea7n l\u01b0\u1ee3t l\u00e0 t\u1eeb\u00a01 \u0111\u1ebfn 10 (\u1ee9ng v\u1edbi c\u00e1c d\u00f2ng t\u1eeb C2:C11). Coi v\u00f9ng n\u00e0y l\u00e0 <strong>bins_array<\/strong>. Gi\u1ea3 s\u1eed x\u00e9t A2:A11 ch\u00ednh l\u00e0 n\u1ed9i dung ch\u00fang ta c\u1ea7n.<\/li>\n<li>\u0110\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t\u00a0ng\u00e0y\u00a0l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y v\u1edbi h\u00e0m MATCH. V\u00f9ng n\u00e0y \u0111\u01b0\u1ee3c coi l\u00e0 <strong>data_array<\/strong>. H\u00e0m MATCH \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/li>\n<\/ul>\n<figure id=\"attachment_19920\" aria-describedby=\"caption-attachment-19920\" style=\"width: 390px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19920 size-full\" title=\"3- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-match-01.png\" alt=\"3- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"390\" height=\"376\"><figcaption id=\"caption-attachment-19920\" class=\"wp-caption-text\">3- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>Khi ki\u1ec3m tra k\u1ebft qu\u1ea3 h\u00e0m MATCH b\u1eb1ng c\u00e1ch b\u00f4i \u0111en c\u00f4ng th\u1ee9c tr\u00ean thanh Formulas Bar v\u00e0 nh\u1ea5n ph\u00edm F9 ta c\u00f3:<\/p>\n<figure id=\"attachment_19921\" aria-describedby=\"caption-attachment-19921\" style=\"width: 354px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19921 size-full\" title=\"4- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-match-02.png\" alt=\"4- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"354\" height=\"373\"><figcaption id=\"caption-attachment-19921\" class=\"wp-caption-text\">4- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>C\u00e1c gi\u00e1 tr\u1ecb l\u1ea7n l\u01b0\u1ee3t tr\u1ea3 v\u1ec1 l\u00e0 1 m\u1ea3ng g\u1ed3m c\u00e1c ph\u1ea7n t\u1eed 1, 2, 3, 4, 5, 6, 7, 8, 10 trong \u0111\u00f3 ph\u1ea7n t\u1eed 8 xu\u1ea5t hi\u1ec7n 2 l\u1ea7n do\u00a0ng\u00e0y 27\/6\/2018 xu\u1ea5t hi\u1ec7n 2 l\u1ea7n trong m\u1ea3ng. \u0110i\u1ec1u n\u00e0y t\u01b0\u01a1ng \u1ee9ng v\u1edbi\u00a0c\u00e1ch bi\u1ec3u di\u1ec5n h\u00e0m MATCH nh\u01b0 sau:<\/p>\n<figure id=\"attachment_19923\" aria-describedby=\"caption-attachment-19923\" style=\"width: 579px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19923 size-full\" title=\"5- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-match-03.png\" alt=\"5- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"579\" height=\"274\"><figcaption id=\"caption-attachment-19923\" class=\"wp-caption-text\">5- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>Khi k\u1ebft h\u1ee3p 2 th\u00e0nh ph\u1ea7n tr\u00ean v\u00e0o h\u00e0m Frequency ta \u0111\u01b0\u1ee3c:<\/p>\n<figure id=\"attachment_19924\" aria-describedby=\"caption-attachment-19924\" style=\"width: 704px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19924 size-full\" title=\"6- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-frequency-match.png\" alt=\"6- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"704\" height=\"387\"><figcaption id=\"caption-attachment-19924\" class=\"wp-caption-text\">6- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>Vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 trong m\u1ea3ng t\u1ea1o ra b\u1edfi h\u00e0m Frequency l\u00e0 ra k\u1ebft qu\u1ea3.<\/p>\n<p>Tuy nhi\u00ean v\u00ec c\u00f4ng th\u1ee9c ch\u1ec9 \u0111\u1eb7t trong 1 \u00f4 n\u00ean h\u00e0m \u0111\u1ebfm gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 ph\u1ea3i d\u00f9ng \u0111\u1ebfn h\u00e0m SUMPRODUCT. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e9t c\u00e1c gi\u00e1 tr\u1ecb t\u1ea1o ra b\u1edfi m\u1ea3ng trong h\u00e0m Frequency so s\u00e1nh v\u1edbi 0, l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb &gt;0<\/li>\n<li>Vi\u1ec7c so s\u00e1nh Frequency&gt;0 s\u1ebd t\u1ea1o ra c\u00e1c m\u1ea3ng l\u00e0 k\u1ebft qu\u1ea3 True\/False. Khi \u0111\u00f3 chuy\u1ec3n c\u00e1c gi\u00e1 tr\u1ecb True\/False v\u1ec1 d\u1ea1ng 1\/0 b\u1eb1ng c\u00e1ch th\u00eam 2 d\u1ea5u tr\u1eeb \u1edf tr\u01b0\u1edbc bi\u1ec3u th\u1ee9c so s\u00e1nh \u0111\u00f3<\/li>\n<\/ul>\n<figure id=\"attachment_19926\" aria-describedby=\"caption-attachment-19926\" style=\"width: 774px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19926 size-full\" title=\"7- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dem-ds-khong-trung-sumproduct-frequency-match.png\" alt=\"7- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"774\" height=\"348\"><figcaption id=\"caption-attachment-19926\" class=\"wp-caption-text\">7- \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3 c\u0169ng ra l\u00e0 9<\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 c\u1ea7n \u0111\u1eb7t 1 bi\u1ec3u th\u1ee9c t\u1ea1i 1 \u00f4 C13 ch\u00fang ta c\u0169ng ra \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 gi\u1ed1ng nh\u01b0 c\u00e1ch th\u1ee9 1.<\/p>\n<p><strong>\u01afu \u0111i\u1ec3m:<\/strong><\/p>\n<ul>\n<li>Kh\u1eafc ph\u1ee5c \u0111\u01b0\u1ee3c nh\u01b0\u1ee3c \u0111i\u1ec3m c\u1ee7a c\u00e1ch 1<\/li>\n<li>Gi\u00fap ch\u00fang ta n\u00e2ng cao h\u01a1n kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng Excel v\u00e0 c\u00e1c t\u01b0 duy v\u1ec1 s\u1eed d\u1ee5ng h\u00e0m, x\u1eed l\u00fd d\u1eef li\u1ec7u, lo\u1ea1i d\u1eef li\u1ec7u tr\u00ean Excel.<\/li>\n<li>\u1ee8ng d\u1ee5ng trong vi\u1ec7c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u kh\u00f4ng tr\u00f9ng t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m<\/li>\n<\/ul>\n<p><strong>Nh\u01b0\u1ee3c \u0111i\u1ec3m:<\/strong><\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c kh\u00e1 ph\u1ee9c t\u1ea1p n\u00ean c\u1ea7n hi\u1ec3u k\u1ef9 v\u1ec1 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng<\/li>\n<\/ul>\n<p><strong>N\u00e2ng cao:<\/strong><\/p>\n<p>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng s\u1eed d\u1ee5ng c\u1ed9t STT trong b\u1ea3ng d\u1eef li\u1ec7u. V\u1eady n\u00ean vi\u1ec7c s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp v\u00f9ng A2:A11 v\u00e0o tham s\u1ed1 <strong>bins_array<\/strong> trong h\u00e0m Frequency ph\u1ea3i thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch kh\u00e1c. Theo b\u1ea1n th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch n\u00e0o? H\u00e3y chia s\u1ebb v\u1edbi H\u1ecdc Excel Online c\u00e1ch gi\u1ea3i quy\u1ebft trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y nh\u00e9.<\/p>\n<p>Tham kh\u1ea3o:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-dung-ham-sumproduct-de-dem-theo-nhieu-dieu-kien.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m SUMPRODUCT \u0111\u1ec3 \u0111\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tong-hop-cac-phuong-phap-loai-bo-du-lieu-lap.html\">T\u1ed5ng h\u1ee3p c\u00e1c ph\u01b0\u01a1ng ph\u00e1p lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1eb7p<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-loc-ra-mot-danh-sach-cac-gia-tri-duy-nhat-va-khac-biet-trong-excel.html\">C\u00e1ch l\u1ecdc ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t v\u00e0 kh\u00e1c bi\u1ec7t trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2Kyz86j\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-159.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2110,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2109","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2109"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2109\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2110"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}