{"id":28979,"date":"2023-11-12T14:29:54","date_gmt":"2023-11-12T07:29:54","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=28979"},"modified":"2024-08-28T16:59:35","modified_gmt":"2024-08-28T09:59:35","slug":"2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=28979","title":{"rendered":"2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea1n mu\u1ed1n <strong>\u0111\u1ebfm nh\u1eefng gi\u00e1 tr\u1ecb duy nh\u1ea5t trong b\u1ea3ng Excel<\/strong>? V\u1eady h\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a H\u1ecdc vi\u1ec7n iT.vn \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau nh\u00e9!<\/span><\/p>\n<figure id=\"attachment_28980\" aria-describedby=\"caption-attachment-28980\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28980 size-full\" title=\"2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat.jpg\" alt=\"2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t\" width=\"750\" height=\"401\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-300x160.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-510x273.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28980\" class=\"wp-caption-text\">2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify; padding-left: 40px;\"><span style=\"font-weight: 400;\">Xem th\u00eam: <\/span><a href=\"https:\/\/hocvienit.vn\/sua-loi-product-activation-failed-office-2010\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eeda l\u1ed7i Product Activation Failed Office 2010 ch\u01b0a?<\/span><\/a><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch 1: S\u1eed d\u1ee5ng h\u00e0m COUNTIF \u0111\u1ec3 \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 1:<\/strong> \u0110\u1ebfm s\u1ed1 l\u1ea7n gi\u00e1 tr\u1ecb t\u1ea1i d\u00f2ng \u0111\u00f3 xu\u1ea5t hi\u1ec7n b\u1eb1ng c\u00e1ch nh\u1eadp h\u00e0m: <strong>=COUNTIF(B\u1ea1n mu\u1ed1n t\u00ecm \u1edf \u0111\u00e2u?, B\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb n\u00e0o?)<\/strong>.<\/span><\/p>\n<figure id=\"attachment_28981\" aria-describedby=\"caption-attachment-28981\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28981 size-full\" title=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-1.jpg\" alt=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n\" width=\"750\" height=\"464\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-1.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-1-300x186.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-1-510x316.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28981\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: =COUNTIF($C$2:C11,C11)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd gi\u00fap \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n t\u1ea1i m\u1ed7i d\u00f2ng b\u1eb1ng c\u00e1ch x\u00e9t t\u0103ng d\u1ea7n theo c\u00e1c d\u00f2ng v\u00e0 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u0111i\u1ec3m \u0111\u1ea7u C2 trong v\u00f9ng Range. (L\u01b0u \u00fd, \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u00f4, b\u1ea1n b\u00f4i \u0111en \u00f4 b\u1eaft \u0111\u1ea7u trong c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n ph\u00edm F4).<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu k\u1ebft qu\u1ea3 b\u1eb1ng 1 th\u00ec c\u00f3 ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng t\u1ea1i c\u1ed9t C xu\u1ea5t hi\u1ec7n m\u1ed9t l\u1ea7n duy nh\u1ea5t, t\u1ee9c l\u00e0 ch\u01b0a b\u1ecb tr\u00f9ng. C\u00e1c gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 1 l\u00e0 b\u1ecb tr\u00f9ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp t\u1ee5c s\u1eed d\u1ee5ng h\u00e0m <strong>COUNTIF<\/strong> \u0111\u1ec3 \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong Excel.<\/span><\/p>\n<figure id=\"attachment_28982\" aria-describedby=\"caption-attachment-28982\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28982 size-full\" title=\"H\u00e0m \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-2.jpg\" alt=\"H\u00e0m \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"750\" height=\"464\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-2.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-2-300x186.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-2-510x316.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28982\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: = COUNTIF(F2:F11,1)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, ch\u1ec9 v\u1edbi h\u00e0m COUNTIF \u0111\u01a1n gi\u1ea3n, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong 1 danh s\u00e1ch tr\u00ean Excel. Tuy nhi\u00ean, trong tr\u01b0\u1eddng h\u1ee3p b\u1ea3ng d\u1eef li\u1ec7u qu\u00e1 d\u00e0i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau trong c\u00e1ch ti\u1ebfp theo sau \u0111\u00e2y.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><b>C\u00e1ch 2: S\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p FREQUENCY<\/b><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">FREQUENCY 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 m\u1ed9t ph\u1ea1m vi n\u00e0o \u0111\u00f3. C\u1ea5u tr\u00fac h\u00e0m FREQUENCY nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>=FREQUENCY(data_array,bins_array)<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>Data_array:<\/strong> M\u00f4\u0323t ma\u0309ng ho\u0103\u0323c tham chi\u00ea\u0301u t\u01a1\u0301i m\u00f4\u0323t t\u00e2\u0323p gia\u0301 tri\u0323 ma\u0300 ba\u0323n mu\u00f4\u0301n \u0111\u00ea\u0301m t\u00e2\u0300n su\u00e2\u0301t cu\u0309a no\u0301. N\u00ea\u0301u data_array kh\u00f4ng ch\u01b0\u0301a gia\u0301 tri\u0323, thi\u0300 ha\u0300m FREQUENCY tra\u0309 v\u00ea\u0300 ma\u0309ng ca\u0301c s\u00f4\u0301 kh\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><strong>Bins_array:<\/strong> Ma\u0309ng ho\u0103\u0323c tham chi\u00ea\u0301u t\u01a1\u0301i ca\u0301c khoa\u0309ng ma\u0300 ba\u0323n mu\u00f4\u0301n nho\u0301m ca\u0301c gia\u0301 tri\u0323 trong data_array va\u0300o trong \u0111o\u0301. N\u00ea\u0301u bins_array kh\u00f4ng ch\u01b0\u0301a gia\u0301 tri\u0323, thi\u0300 ha\u0300m FREQUENCY tra\u0309 v\u00ea\u0300 s\u00f4\u0301 tha\u0300nh ph\u00e2\u0300n trong data_array.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nguy\u00ean t\u1eafc c\u1ee7a h\u00e0m Frequency l\u00e0 \u0111\u1ebfm s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb tham s\u1ed1 <strong>bins_array<\/strong> trong <strong>data_array<\/strong>.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u1ee8ng d\u1ee5ng nguy\u00ean t\u1eafc tr\u00ean, ch\u00fang ta x\u00e9t 2 n\u1ed9i dung sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1ed1 th\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 1 \u0111\u1ebfn 10 (\u1ee9ng v\u1edbi c\u00e1c d\u00f2ng t\u1eeb C2:C11). Coi v\u00f9ng n\u00e0y l\u00e0 bins_array. Gi\u1ea3 s\u1eed x\u00e9t A2:A11 ch\u00ednh l\u00e0 n\u1ed9i dung ch\u00fang ta c\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t ng\u00e0y l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y v\u1edbi h\u00e0m MATCH. V\u00f9ng n\u00e0y \u0111\u01b0\u1ee3c coi l\u00e0 data_array.\u00a0<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1eeb \u0111\u00f3, ta c\u00f3 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 1:<\/strong> Nh\u1eadp h\u00e0m <strong>MATCH<\/strong> \u0111\u1ec3 \u0111\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y nh\u01b0 sau: <strong>=MATCH(gia\u0301 tri\u0323 ti\u0300m ki\u00ea\u0301m, ma\u0309ng ti\u0300m ki\u00ea\u0301m, [ki\u00ea\u0309u kh\u01a1\u0301p])<\/strong>.<\/span><\/p>\n<figure id=\"attachment_28983\" aria-describedby=\"caption-attachment-28983\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28983 size-full\" title=\"H\u00e0m \u0111\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-3.jpg\" alt=\"H\u00e0m \u0111\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y\" width=\"750\" height=\"475\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-3.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-3-300x190.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-3-510x323.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28983\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm xem m\u1ed7i gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n trong c\u1ed9t l\u00e0 gi\u00e1 tr\u1ecb th\u1ee9 m\u1ea5y<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: =MATCH(C2:C11,C2:C11,0)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 l\u00e0 1 m\u1ea3ng g\u1ed3m c\u00e1c ph\u1ea7n t\u1eed 1, 2, 3, 4, 4, 6, 7, 8, 9, 10. Trong \u0111\u00f3, ph\u1ea7n t\u1eed 4 xu\u1ea5t hi\u1ec7n 2 l\u1ea7n do ng\u00e0y 12\/5\/2023 xu\u1ea5t hi\u1ec7n 2 l\u1ea7n trong m\u1ea3ng.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1eadp ti\u1ebfp h\u00e0m: <strong>=FREQUENCY(data_array,bins_array)<\/strong> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb.\u00a0<\/span><\/p>\n<figure id=\"attachment_28984\" aria-describedby=\"caption-attachment-28984\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28984 size-full\" title=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-4.jpg\" alt=\"H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb\" width=\"750\" height=\"475\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-4.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-4-300x190.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-4-510x323.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28984\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: =FREQUENCY(MATCH(C2:C11, C2:C11,0),A2:A11)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>B\u01b0\u1edbc 3:<\/strong> B\u1ea1n \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong Excel b\u1eb1ng c\u00e1ch \u0111\u1ebfm s\u1ed1 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 trong m\u1ea3ng t\u1ea1o ra b\u1edfi h\u00e0m <strong>Frequency<\/strong> b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m: <strong>=SUMPRODUCT(array1, [array2], [array3], &#8230;)<\/strong>.<\/span><\/p>\n<figure id=\"attachment_28985\" aria-describedby=\"caption-attachment-28985\" style=\"width: 750px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-28985 size-full\" title=\"H\u00e0m \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" src=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-5.jpg\" alt=\"H\u00e0m \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng\" width=\"750\" height=\"475\" srcset=\"https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-5.jpg 750w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-5-300x190.jpg 300w, https:\/\/hocvienit.vn\/wp-content\/uploads\/2023\/11\/2-ham-dem-bo-qua-cac-gia-tri-trung-nhau-don-gian-nhat-5-510x323.jpg 510w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption id=\"caption-attachment-28985\" class=\"wp-caption-text\">H\u00e0m \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: =SUMPRODUCT(&#8211;(FREQUENCY(MATCH(C2:C11,C2:C11,0),A2:A11)&gt;0))\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Vi\u1ec7c so s\u00e1nh <strong>Frequency&gt;0<\/strong> s\u1ebd t\u1ea1o ra c\u00e1c m\u1ea3ng l\u00e0 k\u1ebft qu\u1ea3 <strong>True\/False<\/strong>. Khi \u0111\u00f3 chuy\u1ec3n c\u00e1c gi\u00e1 tr\u1ecb <strong>True\/False<\/strong> v\u1ec1 d\u1ea1ng <strong>1\/0<\/strong> b\u1eb1ng c\u00e1ch th\u00eam 2 d\u1ea5u tr\u1eeb \u1edf tr\u01b0\u1edbc bi\u1ec3u th\u1ee9c so s\u00e1nh \u0111\u00f3.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1eb7c d\u00f9 c\u00e1ch n\u00e0y \u0111\u00f2i h\u1ecfi b\u1ea1n c\u1ea7n nh\u1eadp h\u00e0m 3 l\u1ea7n, nh\u01b0ng \u0111\u1ed1i v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, vi\u1ec7c s\u1eed d\u1ee5ng <strong>SUMPRODUCT<\/strong> k\u1ebft h\u1ee3p <strong>FREQUENCY<\/strong> s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m kh\u00e1 nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c \u0111\u1ec3 \u0111\u1ebfm gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng trong Excel.<\/span><\/p>\n<p style=\"text-align: justify; padding-left: 40px;\"><span style=\"font-weight: 400;\">Xem th\u00eam: <\/span><a href=\"https:\/\/hocvienit.vn\/huong-dan-tao-bang-trong-excel-don-gian-va-nhanh-nhat\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn t\u1ea1o b\u1ea3ng trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh nh\u1ea5t<\/span><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a H\u1ecdc vi\u1ec7n iT.vn v\u1ec1 2 h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Hy v\u1ecdng nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 gi\u00fap \u00edch cho b\u1ea1n trong qu\u00e1 tr\u00ecnh h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o th\u00ec h\u00e3y inbox tr\u1ef1c ti\u1ebfp cho H\u1ecdc vi\u1ec7n iT.vn ho\u1eb7c li\u00ean h\u1ec7 qua <strong>Hotline 0981 223 001<\/strong> \u0111\u1ec3 \u0111\u01b0\u1ee3c gi\u1ea3i \u0111\u00e1p t\u1ed1t nh\u1ea5t. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n<p style=\"text-align: left;\"><i>M\u1ecdi chi ti\u1ebft xin vui l\u00f2ng li\u00ean h\u1ec7:<br \/>\n<\/i><strong>C\u00d4NG TY C\u1ed4 PH\u1ea6N H\u1eccC VI\u1ec6N IT<br \/>\n<\/strong><strong>MST: 0108733789<br \/>\n<\/strong><strong>Hotline: 0981 223 001<br \/>\n<\/strong><strong>Facebook:<\/strong>\u00a0<a href=\"http:\/\/www.fb.com\/hocvienit\" target=\"_blank\" rel=\"noopener\">www.fb.com\/hocvienit<\/a><br \/>\n<strong>\u0110\u0103ng k\u00fd k\u00eanh Youtube \u0111\u1ec3 theo d\u00f5i c\u00e1c b\u00e0i h\u1ecdc c\u1ee7a Hu\u1ea5n luy\u1ec7n vi\u00ean t\u1ed1t nh\u1ea5t:<\/strong>\u00a0<a href=\"http:\/\/bit.ly\/Youtube_HOCVIENiT\" target=\"_blank\" rel=\"noopener nofollow\">http:\/\/bit.ly\/Youtube_HOCVIENiT<\/a><br \/>\n<b>H\u1ec7 th\u1ed1ng c\u01a1 s\u1edf \u0111\u00e0o t\u1ea1o:\u00a0<\/b><a href=\"https:\/\/hocvienit.vn\/lien-he\/\" target=\"_blank\" rel=\"noopener\">https:\/\/hocvienit.vn\/lien-he\/<\/a><br \/>\n<strong><i>H\u1ecdc vi\u1ec7n IT.vn \u2013 Truy\u1ec1n ngh\u1ec1 th\u1ef1c t\u1ebf c\u00f9ng b\u1ea1n \u0111\u1ebfn th\u00e0nh c\u00f4ng!\u00a0<\/i><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e3y tham kh\u1ea3o ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a H\u1ecdc vi\u1ec7n iT.vn \u0111\u1ec3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau nh\u00e9!<\/p>\n","protected":false},"author":95,"featured_media":28980,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[95,94],"tags":[],"_links":{"self":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/28979"}],"collection":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=28979"}],"version-history":[{"count":0,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/28979\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/media\/28980"}],"wp:attachment":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}